Relation between Load, CustPackingSlipJour & CustPackingSlipTrans

(0) Share

Report

Posted on by D365 beginner

634

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.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No