Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / GL Revaluation for AX2012
Microsoft Dynamics AX (Archived)

GL Revaluation for AX2012

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Dear All,

I would like to about the GL revaluation in AX 2012.

I am having the scenario below

1/2/19 - Issue a Free Text Invoice to bill client an Deposit  of USD 1,000 at rate of 2.00

Debit AR 1,000 (USD), 2,000 (Home)

Credit Deposit 1,000 (USD), 2,000 (Home)

on the 28/2/19, exchange rate revised to 2.00 and no payment receive from customer

i ran the GL revaluation on the advance payment ledger,

i am getting a voucher below :

Debit un-realize gain 100.00

Credit Deposit 100.00

1513.GL.png

Un-realize gain suppose to be a credit amount right?

Can anyone help to explain on this?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Revaluation for AX2012

    Hi Ludwig,

    Thank you so much for your sharing.

    Its really help.

    Appreciate so much

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GL Revaluation for AX2012

    Good Morning Jie De Xin,

    You are right. The un-realized gain account won't change to a realized gain or loss account because there is usually no settlement that will be done for GL accounts.

    This is different from what you might used to from the foreign currency revaluation in AR or AP.

    A possible workaround is described on the following site:

    dynamicsax-fico.com/.../gl-foreign-currency-revaluation-types

    Probably have a look at the example presented there and the solution identified to verify whether this is an option for you to get this issue resolved.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Revaluation for AX2012

    My concern with the below statement

    When run my GL revalulation for Deposit account, i am getting the result below

    28/2 Credit Deposit 100.00 (SGD)

    28/2/ Debit  un-realize gain 100.00 (SGD}

    What is it debit the un-realize gain? It will not reverse to realize gain when i do settlement

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GL Revaluation for AX2012

    Hello Jie,

    If the invoice is in USD and your accounting currency is in SGD then i would expect an unrealized exchange rate gain posted by the exchange rate revaluation process.

    That is becasue - as mentioned above - the USD appreciated, i.e. became more valuable.

    As you have a kind of investment in USD - your open invoice amount - you get richer by the currency change.

    That's what I would expect.

    AX seems to behave like that.

    So, for me this looks fine.

    Do you have any concerns?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Revaluation for AX2012

    My accounting currency is SGD,

    Initial i billed via Free Text invoice

    1/2/19 Debit AR 1000,00 (USD) , 2000.00 (SGD)

    1/2/19 Credit Deposit 1000.00 (USD) , 2000.00(SGD)

    I run my AR un-realize revaluation i am getting the below:

    28/2 Debit AR control 100.00 (SGD)

    28/2 Credit un-realize gain 100.00 (SGD)

    I also run my GL revalulation for Deposit account, i am getting the result below

    28/2 Credit Deposit 100.00 (SGD)

    28/2/ Debit  un-realize gain 100.00 (SGD)

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GL Revaluation for AX2012

    Hi,

    Thanks for this information.

    Based on that the USD has appreciated against the SGD.

    Previously you got 2.00 SGD/1.00 USD and later you got 2.10 SGD/1.00 USD.

    Expressed differently, holding the USD is better in this case as you get 'more'.

    Is your accounting currency the USD or the SGD?

    Can you explain about the AR line and the deposit line? Are these two transactions that got revalued or is it one? Maybe you can share the original voucher with the DR and CR.

    Many thanks and best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Revaluation for AX2012

    My assumption is based on USD to SGD

    Sorry my rate on 1/2/19 is 2.00 and my month end revaluation rate is 2.1.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GL Revaluation for AX2012

    Hi,

    Can you let us know the exchange rates between the USD and your 'home' currency as of 01/02/2019 and 28/02/2019?

    In your text you always mention 2.00.

    What is your 'home' currency?

    Many thanks,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans