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.
Still need help?
Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.