Finance | Project Operations, Human Resources, ...

Tariff and other costs, Tracking

(0) Share

Report

Posted on by Rob Harriman

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Rob Harriman 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rob Harriman 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Rob Harriman 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report
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?

Was this reply helpful? Yes No