Different cost amount in ledger and inventory transactions of purchase invoice (AX 2012 R2 CU7)

[Morpheus]

Let us consider the case when the accounting currency is EUR and the purchase invoice currency is USD. Below is presented the list of the invoice lines. Assume that the exchange rate is 89,8069 EUR per 100 USD.

Product       Qty       Price     Amount, USD    Amount, EUR    Amount rounded, EUR

Product_1     5,00       40,00     200,00          179,6138            179,61

Product_2     5,00       56,00     280,00          251,4593            251,46

Product_3     25,00     100,00   2.500,00        2.245,1725          2.245,17

Product_4     25,00     120,00   3.000,00        2.694,2070          2.694,21

Product_5     50,00      30,00   1.500,00        1.347,1035          1.347,10

Invoice total                    7.480,00                            6.717,55

The rounded amount in EUR will be used as the cost amount in the inventory transaction. Thus the total inventory cost calculated basing on inventory transactions will be 6.717,55 EUR. And what about the cost amount posted into the General Ledger transaction? It will be calculated as a product of the invoice total amount in USD and the exchange rate, afterwards the result will be rounded to two decimal places. 7.480,00 * (89,8069 /100) = 6.717,5561 = 6.717,56

Continue reading