I'm trying to match the sales in the Item Ledger Entry table and the Sales Invoice Lines. Does anyone know how to relate the two tables? I looked at the Posted Warehouse Shipment table as a linking table
but the source no in there doesn't seem to match Sales Invoice or Sales Order tables although the PostedWarehouseShipment.desintationNo does match the Item Ledger Entry (sourceno) table.

Report
All responses (
Answers (