Dynamics AX in the Field

Microsoft Dynamics AX from the Premier Field Engineering team at Microsoft.

Currency Round-off and Maximum Penny Difference

Currency Round-off and Maximum Penny Difference

  • Comments 2

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/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;923022

  • Hi Cody.

    I was reviewing the GL voucher transactions related to an Item Price Activation. I noticed that there are transactions with "Inventory cost revaluation" posting type besause of the price activation. However, what I'm confused of is that there are some transactions with the "Rounding variance" posting type, though they are completely settled.

    What might be the cause?

    Thanks in advance.

  • Thank you it helped

Page 1 of 1 (2 items)