Our company has the following landed costs - Freight, Duty, Disbursements. What I need is a report stating how much the freight was on each inventory item for a purchase, and the same as disbursements and duty. This way I can go over the report with production and ensure we are costing at the correct values. In some cases our freight can change by over 50% so this needs to be highlighted.
Is there a way I can pull out this information? What I really want is the inventory item FOB cost, freight attributable, disbursements attributable etc coming to the total cost of the inventory item.