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 GP (Archived) / Zeroing out Historical...
Microsoft Dynamics GP (Archived)

Zeroing out Historical Currency accounts in reporting currency in MR

(0) ShareShare
ReportReport
Posted on by Community Member

From another thread this was pointed out.

  • MR can return a translated amount even when there is a $0 balance in the functional currency. A simple example to explain this:
  1. An account is set to use Historical for the translation type.
  2. Debit Amount of 1,000 posted to the account on 1/15/2016. Exchange rate on that date of 1.1, so the translated amount is 1,100.
  3. Credit amount of 1,000 posted to account on 1/22/2016. Exchange rate on that date of 1.2, so the translated amount is 1,200.
  4. report generated on 1/31/2016.  The amount in the functional currency is $0. The translated amount will be a credit of -100 (1,100-1,200).
  5. This situation can occur with accounts set to Historical or Average translation types.

This is the exact situation we are running into.  How do we fix this problem.  The account is zero in functional currency and needs to be zero in reporting currency as well.  I tried revaluing the account and that didn't work.

*This post is locked for comments

I have the same question (0)

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 GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans