Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Tariff and other costs, Tracking

(0) ShareShare
ReportReport
Posted on by 5

Hello All,

I'm looking for some guidance. I want to be able to setup and track tariff, freight and other import costs at the sale of the goods, as opposed to the purchase of them.

I don't want to affect the value of the inventory. I have looked at tax codes and setting up an auto charge landed cost but that changed my manage costs. 

This is mainly for informational purposes and not accounting purposes. Any help is much appreciated. 

Many Thanks - Rob

Dynamics AX 2012 RU3

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Tariff and other costs, Tracking

    Presumably any charges you incur are invoiced so you can do as Ludwig;s suggest.

    If you want to see the cost by sales order then why not add those to the sales order at header level ,and don;lt allocate  by line.

    Under the Posting fast tab you  configure both the Debit and Credit side of the entry. There are three options in the Type dropdown:

    • Item- adds the charge to the item’s cost
    • Ledger account- main account where the Debit or Credit is posted
    • Customer/Vendor- charge is added to the customer or vendor balance

    I would use the last of these i.e. if you want to know by order then you presumably also want to know by customer?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Tariff and other costs, Tracking

    Hi Rob,

    If you need the $6 difference at the analytical / reporting level only then you can think about using financial dimensions e.g. for the sales order ID to bring those additional costs together with the other costs that you see when posting the SO invoice.

    Best regards,

    Ludwig

  • Rob Harriman Profile Picture
    Rob Harriman 5 on at
    RE: Tariff and other costs, Tracking

    Satish, thanks again for your help.

    The second part of this per my OP is seeing the charges reflect at the sale of goods for example, I purchase 100 pcs at 10.00 each. With all the import tariffs and freight costs etc, that unit price inflates to 16.00 each. I want to see the 16.00 when I sell each item, not on the sales order obviously but with reporting. It needs to be in there somewhere. I apologize if i'm being as clear as mud but I hope you can help.

    Thanks - Rob

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,649 on at
    RE: Tariff and other costs, Tracking

    Hi Rob,

    Glad it worked. Even though charge was setup to post in GL (Credit/Debit), you should go to GL and search for transactions and should see a voucher. it's not related to customer/sales as GL was used on both sides.

  • Rob Harriman Profile Picture
    Rob Harriman 5 on at
    RE: Tariff and other costs, Tracking

    Hello Ludwig,

    My first tests didn't have the charge going in and out of a ledger account, only half of it. This affected my managed cost. I set this up again for a different item with a charge going in and out as suggested, and it did not affect my manage cost, so in that respect that is good. Should I see my sales voucher have a portion of this charge in the voucher for inventory and cogs because I do not.  I must be clear too, I am not in accounting, I am researching AX options per a ticket request.

    Thank you

    Rob

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Tariff and other costs, Tracking

    Hello Rob,

    If you have a very close look at the screenprint that Satish shared then you will noticed that the charge code debits and credits a ledger account.

    Such a charge code will create a voucher in GL but (!) it will not affect your costs and inventory value.

    The transaction can be made purely on accounts that don't affect your P&L at all.

    If you like, you can even use 'statistical' accounts that are not part of your P&L.

    Based on the initial question raised this seems to be a solution to the problem from what I understand.

    Do you agree?

    Best regards,

    Ludwig

  • Rob Harriman Profile Picture
    Rob Harriman 5 on at
    RE: Tariff and other costs, Tracking

    Satish,

    Thank you for your response and suggestions. I have gone down the auto charge route but it changed the manage cost of the item and I don't want that. Would you suggest setting the tariff up as a tax group? Do you have any pointers on that?

    Thanks again - Rob

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,649 on at
    RE: Tariff and other costs, Tracking

    Hi Rob,

    Your best guess would be auto charges with code that's in and out of ledger account. Unfortunately, it will post to GL and you can't avoid it. Another option would be to track it on a separate field/table on order header but that would require customization. Screenshot below is from D365 but should be applicable to AX 2012 as well.

    pastedimage1573854151652v1.png

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans