Warehouse Management Shipment Question

(0) Share

Report

Posted on by brianmaric

I am trying to find all the invoices that have been shipped for a certain time period with no Miscellaneous charges (I can get this from custinvoicejour.

I am linking the custinvoicejour.salesid with the WHSShipmentTable.ordernum with a status of shipped.

But I've found that the whsLoadline.ordernum can differ from the WHSShipmentTable.ordernum. Can anyone explain why this is the case?

Thanks

Brian

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report
Copy link

Link copied!

Could it be similar issue like the summary update?

A load can have multiple shipments and a shipment can have multiple loads. So the header has one field that should have multiple references and thus only refer to one. Like an invoice header for multiple sales orders will only list one of the sales orders it references...

You would like to look at the line level to find shipping time, but isn't it much better to just go to custpackingslip instead?

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,977 Moderator on at

Like (0)

Report
Copy link

Link copied!

WHSLoadLine = Shipment lines (and Load lines).

It is possible to put multiple sales orders on to a single shipment, if the sales orders are for the same customer/address/mode of delivery (from memory). If you look at one of the Shipments (where the order number of the header is different from one of its lines), and those sales orders, is this what has happened?

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
Copy link

Link copied!

Yes, it seems to be happening only with our intercompany orders...I guess I must reference these differently than the non-intercompany orders.

Was this reply helpful? Yes No