Reconcile Carrier Invoice

Reconcile Carrier Invoice

You are here:

Freight Cost data is stored in Business Central so that you can reconcile it with your carrier invoices.

If you have Power BI on Business Central SaaS, install the Dynamic Ship Analysis app which has additional reports, including total shipping spend by month. Otherwise, you can view the Freight Information report for an individual order from a license plate on the Insight Works License Plates list.

You can build a report based on the DSHIP Label Data (23044622) table (the listed prices are per order, not per box). Any report would need to make sure it is only looking at 1 line per shipment, which would require linking back to the IWX LP Header (23044330) table.

You could also run a Ledger Entries report on the G/L account if you have “Update the Freight Line Description” = “Add Five Tracking Characters” configured in Dynamic Ship Setup. This records the last 5 digits of the tracking number from the carrier in the G/L description, which can make it easier for the accounting team to match the transactions.

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?

Leave A Comment

Go to Top