Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

A/P Currency Revaluation Issue

(1) ShareShare
ReportReport
Posted on by 341

Hello,

I have a question regarding the Revaluation Routine for the A/P Subledger.  A client of mine runs the routine at month-end for the Unrealized Gain/Loss option.  However, they run it as a Reverse Transaction (meaning they recognize the Unrealized G/L at the last day of the period, and reverse the first day of the following month).  What we have noticed is that doing this just updates de G/L accounts but does nothing to the revaluation of the open A/P transactions, which means that while a Unrealized Gain/Loss was recorded at the G/L level, the A/P Aged TB does not consider the revaluation, causing discrepancies between the A/P module and the General Ledger. What the client expects is to run the A/P Aged Historical TB as of the last day of the period and have it balance with the A/P G/L account, even if that balance was reversed the next period.  

Not sure if this is supposed to happen this way, but it begs the question, what's the point of running the A/P Revaluation routine with Unrealized G/L and a reverse transaction if it does nothing to the actual A/P module itself??

Is what my client doing make sense or should they just run the routine without reversing the Unrealized G/L?

Any help in understanding this would be greatly appreciated!!

Categories:
  • RSM_RCarrillo Profile Picture
    341 on at
    RE: A/P Currency Revaluation Issue

    Hi Angela,

    Thank you very much!! This clears up my question.

    Much appreciated.

  • Verified answer
    Angela Eckman Ebensteiner Profile Picture
    1,216 on at
    RE: A/P Currency Revaluation Issue

    Hi Ricardo,

    Thanks for your post.   I'll do my best to provide you the jist of what GP does with the options.

    Doing the Unrealized gain or loss, with reversing marked, GP will not update the AP transaction amount, but you will see j/e in GL for the difference.  (as well as in the distributions in Payables), but it won't affect the current transaction amount of the document in Payables.  

    Affected tables are:

    NO affect to the MC20105 or PM20000 (PM open table).

    PM10100 distribution table.

    Unrealized without marking reversing (OR a realized revalue) will update both GL and payables.

    Affected tables are:

    PM20000, PM10100

    MC20105 will be populated.

    In a nutshell reversing is more a what if scenario so if you want to affect GL and Payables, then chose second option.

    Hope this helps.

    Warmest Regards,

    Angela Ebensteiner

    Microsoft Support

  • RSM_RCarrillo Profile Picture
    341 on at
    RE: A/P Currency Revaluation Issue

    Any help is appreciated.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans