Dynamics Community Forum Thread Details

Surcharge on purchase from costingsheet

Hello experts,

I am currently setting up a freight surcharge on all purchase orders, with the functionality that is available in the costing sheet (type: cost of purchase). However, I have encountered an issue. AX seems to be calculating the surcharge two times. Let me explain the scenario.

The calculation basis for the surcharge is the cost groups for the purchased items with a percentage of 2,5%.

Lets say i purchase an item, call it item "100", with the following details:

STD-cost
Price in the purchase tab in item details: 8,00
Price in the manage costs tab in item details: 8,20 (this is the calculated STD-cost price, 8,00*1,025=8,20). This is the active cost in the costing version. If i click calculation details for this price, i see a base price of 8,00 and a surcharge of 0,2

When i do a product receipt on an order with 10 qty of item 100, I should get the following postings:

Credit 82,00 on my inventory account
Debit 2,00 on my indirect cost account (from the freight surcharge)
Debit 80 on the purchase accrual account

However, i get the following postings:

Credit 82,00 on my inventory account
Debit 2,05 on my indirect cost account
Credit 0,05 on my purchase price variance account
Debit 80,00 on my purchase accrual account

So the issue is that AX seems to be calculating the surcharge twice, resulting in a "surcharge on the surcharge". Any ideas of what might be causing this issue?

I know there are alot of parameters that can affect the result, if you need any more details than the ones speciefied above just tell me and i will post them here.

I am running AX 2012 R3 CU11

Quick Links