Dynamics Community Forum Thread Details

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

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.