Relation between Load, CustPackingSlipJour & CustPackingSlipTrans

(1) Share

Report

Posted on by D365 beginner

572

Hi Experts,

I have a scenario that we will be sending multiple sales order deliveries to same customer in one load. I am preparing a SSRS report for the same. What is .the relation between WhsLoadTable / CustPackingSlipJour / CustPackingSlipTrans.

I saw the table WhsLoadTableCustpackingSlipJour but when I tested some transaction, the relation WhsLoadTableCustPackingSlipjour.CustPackingSlipJourRecId = CustPackingSlipJour,recid relation did not find matching as required.

I need to fetch the packing slip transaction based on the parameter Load id from the table WHSLoadTable.

Thanks in advance.

All responses (1)

Answers (1)

Verified answer

Mohamed Amine Mahmoudi 9,531 Super User 2024 Season 2 on at

Like (0)

Report
Relation between Load, CustPackingSlipJour & CustPackingSlipTrans

Hi @Alex,

try this :

select * from custPackingSlipTrans join CustPackingSlipJour on CustPackingSlipJour.SalesId = custPackingSlipTrans.SalesId and CustPackingSlipJour.PackingSlipId = custPackingSlipTrans.PackingSlipId join WHSLoadLine on WHSLoadLine.InventTransType = 0 and WHSLoadLine.OrderNum = CustPackingSlipJour.SalesId join WHSLoadTable on WHSLoadLine.LoadId = WHSLoadTable.LoadId

Best regards,

Mohamed Amine MAHMOUDI