Microsoft Dynamics NAV (Archived)

Relation between 2 Tables

(0) Share

Report

Posted on by jsshivalik

3,027

How the relationship can be maintained between Item Ledger Entry & Posted Warehouse Receipt Line.

Is this ok.

IlEntry.SETRANGE(IlEntry."Document No.","Posted Source No.");
IlEntry.SETRANGE(IlEntry."Item No.","Posted Whse. Receipt Line"."Item No.");
IlEntry.SETRANGE(IlEntry."Document Line No.","Posted Whse. Receipt Line"."Source Line No.");

In Posted Warehouse receipt line can 1 item occurs more than 1 time in a Document or there can be on;y 1 entry of a particular item

Thanks

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Ashwini Tripathi 4,624 on at

Like (0)

Report

RE: Relation between 2 Tables

Yes you can have multiple lines for same item as you can in Sales Line. Item No. is not part your Primary Key.
mmv 11,465 on at

Like (1)

Report

RE: Relation between 2 Tables

if there are multiple lines for the same item in the Source Document, even the Warehouse Receipt will have multiple lines for the same item.

you can try the below code:-

IlEntry.SETRANGE("Document No.","Source No.");

IlEntry.SETRANGE("Document Line No.","Source Line No.");

IF "Source Type" = 5741 THEN ( you need to change this based on the "Source Type")

IlEntry.SETRANGE("Document Type",IlEntry."Document Type"::"Transfer Receipt");
Suggested answer

Amol Salvi 18,694 on at

Like (1)

Report

RE: Relation between 2 Tables

In Posted Warehouse receipt line 1 item can occurs multiple times as table's primary key No and Line No and same way it will post to ILE.