Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

How to automatically update Custom (duty) rate via Maintained Charges on Purchase order lines after changing the Custom Rate at the product level? (AX 2012)

Posted on by 5

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! 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to automatically update Custom (duty) rate via Maintained Charges on Purchase order lines after changing the Custom Rate at the product level? (AX 2012)

    Hello Sorrow2382,

    As Nuna Maia mentioned there is no standard feature available that would do the update automatically for you; at least not to my knowledge.

    If this is needed then an adjustment must be made.

    Best regards,

    Ludwig

  • nunomaia Profile Picture
    nunomaia 10,684 Super User 2024 Season 1 on at
    RE: How to automatically update Custom (duty) rate via Maintained Charges on Purchase order lines after changing the Custom Rate at the product level? (AX 2012)

    I don't think there is a standard way to perform an update of item charges in all Purchase Order with a new price. There are allocations, etc.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans