Hi,
I've looked for answers on the forums for a while now and could not find it, so there is my problem:
At my company, we sell bike related products to the customer. In our AX 2012 system, each item (SKU) has its own HS code and a "Customs Rate" associated to it. The "Custom Rate" is a rate in % representing the % of Duty when the product is imported from overseas.
Landed cost of imported products are calculated by : Purchase cost + Transport Cost + Custom Rate = Landed Cost.
We have established standard rates in % for each SKU for Transport Cost. Each time a Purchase Order (PO) is created, at the PO line by clicking on "maintained charges", the value of Transport Cost will be calculated and added automatically by the system. Same logic goes for Duty cost, the system will calculate the Duty cost based on the "Custom Rate" at the product level and add a "maintained charges" called "customs" on the PO line.
The problem is, when we change/update the "Custom Rate" at the product level, and if there are PO already created, the "customs" maintained charges will NOT update automatically. It will keep the old "custom rate".
I have been updating manually, line by line for each outstanding PO each time a "Custom rate" is updated in the system...
Is there any way (any set up) in AX 2012 for the PO lines to automatically update the PO lines with the correct "customs" rate?
Thank you in advance!