News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX forum Relation between Load,...

Microsoft Dynamics AX forum

Answered

Relation between Load, CustPackingSlipJour & CustPackingSlipTrans

(1) Share

Report

Report

Posted on by D365 beginner

543

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.

Categories:

Development / Customization / SDK

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Mohamed Amine Mahmoudi 9,316 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2

Martin Dráb 228,501 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans