Linking Item Ledger Entry and Warehouse Entry tables

nasheer

Hi All

Can anyone help me to know how do i link the tables 'Item Ledger Entry' and 'Warehouse Entry' (means how do I grab the related record values from the 'Warehouse Entry' table for each lines in the 'Item Ledger Entry' table respectively).

The below fields are common in both tables and can compare.

Item Ledger Entry Warehouse Entry
Posting Date -- Register Date
Document No -- Reference No
Item No -- Item No
Location Code -- Location Code

The Bin Code field only exist in Warehouse Entry.
How to fetch the related values from the Item Ledger Entry group by the Warehouse Entry's Bin Code.

For same Posting Date, Document no, Item No and Location Code, there more than one Bin Code values in the Warehouse Entry table. (ex. Positive adjustment)

Appriciate If anyone help me at the earliest.

Thanks & Regards
Nasheer.

Shenpen

I'd suggest to change the program to put warehouse document type, no. line no. to item ledger tru item journal the same way it is put in warehouse entries.