Item Ledger Entry

LewisTioga

I'm creating a report for which I need to link the Item Ledger Dataset to an Item Dataset.
I'm unsure on how to set the DataItemTableView and DataitemLink. My thoughts were the DataItemLink would be Item No. = FIELD(No.)?

Here's my code for the purpose of retreiving the Item Ledger Entry.

recInvtSetup.FINDFIRST;

CLEAR(gstrItemVariant);
gstrItemVariant := "Item Ledger Entry"."Item No.";

IF recitem.GET("Bin Content"."Item No.") THEN
"Item Description" := recitem.Description;

recItemLedgerEntry.GET(recItemLedgerEntry."Entry No.");
IF recItemLedgerEntry."Variant Code" <> '' THEN BEGIN
LotNo :=
recItemLedgerEntry."Item No."+
' - ' +
recItemLedgerEntry."Variant Code";
EncodedBarCode :=
cuCPUtils.EncodeBarcode128(
recItemLedgerEntry."Item No."+
'|' +
recItemLedgerEntry."Variant Code"
);
END ELSE BEGIN
LotNo := recItemLedgerEntry."Item No.";
EncodedBarCode :=
cuCPUtils.EncodeBarcode128(
recItemLedgerEntry."Item No."
)
END;

ERROR('ll');

LotNoLabel := Text004;

NoOfLoops := 1

vaprog

You should probably not use a filter in "Item No." in the DataItemTableView of the Item Ledger Entry if you link on that field. If you need to narrow down the Items with a filter, as a general rule, you should set the filter on the Item Dataitem.

mohana_cse06

yes, dataitemlink will be Item No.=FIELD(No.)

LewisTioga

What will the DataitemTableView be? On the debugger It's not bringing in any records

mohana_cse06

DataitemTableView Sets the key, sort order, and filter for the data item.
check whether you are getting records in item dataitem.

vaprog

You should probably not use a filter in "Item No." in the DataItemTableView of the Item Ledger Entry if you link on that field. If you need to narrow down the Items with a filter, as a general rule, you should set the filter on the Item Dataitem.