For customs purposes, we are required to present to our shipping broker a "summary" of shipments/orders along with the total *cost* price of those orders. Essentially a Bill of Lading with added "totals for item cost price" data. This is used to apply export tarrifs so we want the cost price and not the sell price.
We have Load Planning Workbench setup, however we're not actively using it. I'm wondering if there is a report or summary available out-of-box within load planning (I don't see anything within Shipments) that would detail the totality of item cost price for each shipment/order? Would this happen to be a commercial invoice? So, producing both the out-of-box Bill of Lading report and Commercial Invoice (with cost values) that should be sufficient I'm guessing.
If not, where best to add a customization? To the Bill of Lading report? Pull the info using Office Excel Add-In and throw into a pivot table?
