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

Announcements

No record found.

News and Announcements icon
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:
I have the same question (0)
  • RSM_RCarrillo Profile Picture
    341 on at

    Any help is appreciated.

  • Verified answer
    Angela Eckman Ebensteiner Profile Picture
    1,218 on at

    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

    Hi Angela,

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

    Much 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 797

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 589 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans