Skip to main content



No record found.

Microsoft Dynamics AX forum
Suggested answer

Relation between Load, CustPackingSlipJour & CustPackingSlipTrans

Posted on by 502
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. 
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 4,831 User Group Leader on at
    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

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans