Relation between Load, CustPackingSlipJour & CustPackingSlipTrans

(1) Share

Report

Posted on by D365 beginner

642

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 (3)

Answers (1)

Sort by

Verified answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
EB-26061403-0 2 on at

Like (0)

Report
Copy link

Link copied!

i am getting multiple records from these connections because of there being multiple shipments for the same sales order line/Inventtransid on different dates which results in something like the following:

SalesId LineNum InventTransId PackingSlipId ShipmentId   InvoiceId   SignDate RouteCode loadid
10SO1965556   1.0000000000000000   10ILOT0000690   10RPS250190   10SH0000220 2026-07-08 0   hay 10LD0000309
10SO1965556   1.0000000000000000   10ILOT0000690   10RPS250206   10SH0000220 2026-07-10 0   hay 10LD0000309
10SO1965556   1.0000000000000000   10ILOT0000690   10RPS250190   10SH0000240 2026-07-08 0   hay 10LD0000330
10SO1965556   1.0000000000000000   10ILOT0000690   10RPS250206   10SH0000240 2026-07-10   0   hay 10LD0000330

We have been hacking away at this for days. What are we missing???

Was this reply helpful? Yes No
Martin Dráb 240,538 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The verified answer is indeed wrong. It gives you lines of all loads that are related to the "main" sales order of the packing slip. They may be unrelated to the given packing slip (or any packing slip at all), and the query ignores other sales orders included in the packing slip.

It can be improved by taking specific sales lines (InventTransId) and CustPackingSlipSalesLink into account. But the key question is whether there is a logical relation between load lines and packing slip lines, which should be answered by someone familiar with the business process. There surely is a relation from a load line to an order line (and you can find all packing slips for that order line), but I'm not aware of a relation between load lines and specific packing slip lines.

Was this reply helpful? Yes No