How to get Shipping Carrier of Shipment on Custom Sales Invoice in D365 F&O

(3) Share

Report

Posted on by harshil9898

100

Hello folks

I want to get the shipping carrier of shipment on Sales Invoice such that whenever the Shipping carrier got updated it should be visible on Invoice. I want to know the full process how the Invoice get the Shipping carrier... I have the CustInvoiceJour table now with the help of this table how can i get the Shipping Carrier of Shipment. Please let me know from where should I take ? Note: We won’t be combining multiple shipments/packing slips under a single sales invoice.

Also; Please let me know the full flow of when the Shipment is created after Packing slip or before packing slip. I want to know the full flow from SalesOrder -> Invoice. I also want to know the table relation from SalesTable, CustInvoiceJour to WHSShipment table.

Here is the SQL Query;

select * from salestable
LEFT JOIN CustPackingSlipJour
on CustPackingSlipJour.SalesId = SalesTable.SalesId and
CustPackingSlipJour.DATAAREAID = SalesTable.DATAAREAID

where salestable.salesid = 'C-120293'

I cant use this Query because i have only one field on Sales Invoice where I want to display only single shipment. Dont know how because this query shows two shipment for the order.

Thanks in advance :)

Categories:

Microsoft Dynamics AX

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Please make use of table named WHSHistoricalLoad

You can see all logic in the form named WHSHistoricalLoad

Please note that Loads has relationship with shipments as you can put multiple loads into a single shipment.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 15,220 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,
The SalesLine table has a relation to WHSLoadLine. From there, you can navigate to WHSShipmentTable, where you can retrieve the CarrierCode value.

Was this reply helpful? Yes No
harshil9898 100 on at

Like (0)

Report
Copy link

Link copied!

Hi @Alireza Eshaghzadeh, Thanks for the reply. But what in case if i only want a shipment related to Invoice ? Whenever I update the Shipping carrier on Shipment it should update it on Invoice. So i want that relation.

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you manage to look at the logic written inside the form named WHSHistoricalLoad?

Was this reply helpful? Yes No