How to add Lot No. field from Item Ledger Entry table into Report ?What C/al coding for that?

mdsr

i have taken item ledger entry table as record variable in report.
RecILE.RESET;
RecILE.SETRANGE("Document No.","Purch. Rcpt. Line"."No.");
IF RecILE.FINDFIRST THEN
LotNo:=RecILE."Lot No.";

midego

You don't have a GET in your code.

mdsr

Hi midego, i have added get in code it still not giving output
RecILE.RESET;
RecILE.GET();
RecILE.SETRANGE("Document No.",RecILE."Document No.");
RecILE.SETRANGE("Item No.","Purch. Rcpt. Line"."No.");
IF RecILE.FINDFIRST THEN
LotNo:=RecILE."Lot No.";

now it giving error while running report:
error:the item Ledger Entry does not exist.identification and values Entry No.='0'

mdsr

I used following code and it works it prints Lot No.
RecILE.RESET;
RecILE.SETRANGE("Document No.","Purch. Rcpt. Line"."Document No.");
RecILE.SETRANGE("Item No.","Purch. Rcpt. Line"."No.");
IF RecILE.FINDFIRST THEN
LotNo:=RecILE."Lot No.";

sorenhinrup

This will work, but only if you only have 1 lot no. per Purchase reciept line.

mdsr

Exactly sir, Now I am facing problem It prints only one lot No. But I want to print multiple lot No.
Suppose item consuming 50kg out of 100 kg from lot no 1 and 50 kg from lot No.2
Now questions is that how to print both lot No. in report what C/AL code for that please help
Thanks in advance

sorenhinrup

I believe you can do it by adding another element on your report dataset. Datasource RecILE, and FILTER as you have previously.
Then you can add another repeater element on your report with the RecILE and lotnumbers.

mdsr

Sir,I didn't get what exactly you trying to say.
Adding recILE in data source give me following error:
'Record' is not valid column type

Duikmeester

You will have to build a dataitem like this: . Then you can print multiple lot numbers per purchase receipt.

mdsr

Hi sir, added dataitem ILE and column Lot No.
How adding dataitem ILE and column Lot No. gives multiple lot No.in report.
RecILE.RESET;
RecILE.SETRANGE("Document No.","Purch. Rcpt. Line"."Document No.");
RecILE.SETRANGE("Item No.","Purch. Rcpt. Line"."No.");
//IF RecILE.FINDFIRST THEN
//LotNo:=RecILE."Lot No.";
IF RecILE.FINDSET THEN
REPEAT
LotNo:=RecILE."Lot No.";
UNTIL RecILE.NEXT=0;

Is it right for multiple lot no.

Duikmeester

No need for additional code. You just map Lot No. on your layout.