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
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:
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?
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
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
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.
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
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
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
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.
#1
André Arnaud de Cal...
292,865
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
