web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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 on at

    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

    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 on at

    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

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thank you so much for your sharing.

    Its really help.

    Appreciate so much

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans