Skip to main content

Notifications

Announcements

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!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans