I have a customer that has a requirement to send detailed cost information of their parts manufactured in Mexico to the Mexican Government. To do this, they use an excel spreadsheet that is used to load into a customs broker system called Aranxel.
The standard report, “Cost Build-Up Report - High Detail”, contains all the necessary information but it is meant to be printed; not into Excel. The “Structure Multi-Level” display shows all the breakdowns but it does not include the cost bucket breakdowns. The “Part Routing Costs per Cost Bucket” display does not explode through the product structure.
Does anyone know of a standard query that can exreact multilevel cost information by bucket? Alternatively, has anyone developed such a query?
Here is the format used currently:
