axinthefield: Currency Round-off and Maximum Penny Difference

[Blog bot]

Источник: http://blogs.msdn.com/b/axinthefield...ifference.aspx
==============

Knowledge Base article 923022 explains when the penny difference account is used in Dynamics AX. I was recently asked how this works in connection with the maximum penny difference setting in GL Parameters. In this post, I have used the example provided in the mentioned article to illustrate how the two settings work together.

When a foreign currency is used, each line in a given voucher is translated to the functional currency, and is rounded separately, according to the setup on the functional currency.



Vouchers may have multiple debit and credit entries. With rounding in play, the voucher may become unbalanced. Here is an example:

Functional currency = USD

Transaction currency = CAD

Exchange rate = 117.5 USD = 100 CAD





Journal lines entered as follows:

Transaction

Amount CAD

Amount USD

Rounded amount (USD)

Debit

55.00

64.625

64.63

Debit

45.00

52.875

52.88

Debit

55.00

64.625

64.63

Debit

45.00

52.875

52.88

Credit

200.00

235.00

235.00

TOTAL debits after rounding: 235.02

TOTAL credits after rounding: 235.00

DIFFERENCE: 0.02



Before AX will actually post this 2 cents to the ‘Penny Difference’ account, we do a check against the GL Parameter setting for ‘maximum penny difference’.

For my first test on this journal, I set the maximum penny difference to 0.01. When I attempt to post the journal, I will receive an error:

'The transactions on voucher 00044_DAY do not balance as per 4/4/2011. (Company currency: -0.02 - secondary currency : 0.00)'

If I change the maximum penny difference to 0.02, the journal posts since it is now within the maximum allowable penny difference:





References:

https://mbs.microsoft.com/knowledgeb...b;EN-US;923022






Источник: http://blogs.msdn.com/b/axinthefield...ifference.aspx