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

Community site session details

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

Need Help - currency error in in F&O Report

(3) ShareShare
ReportReport
Posted on by 12

I have a problem with D365 F&O reporting. When I run a report to show debit transactions balance and Credit transactions balance in sperate columns for specific balance sheet account in entity currency, it shows the correct result but when I change the currency it shows wrong value for debit transactions balance.

Note:

- The account has no debit transactions in report period ( Current fiscal year )

- This error only happened with this account

- I can’t drill down this wrong number to the source transaction

- This Error happened only with current fiscal year, but the report works correctly with pervious fiscal year

- When I tracked the wrong value shown in the report, I found it match to all debit transactions in pervious fiscal year

-Pervious fiscal year-end closing entries are posted correctly and trial balance have no issues with opening balances or closing balances

Would any one help me to fix this

Categories:
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    297,231 Super User 2025 Season 2 on at
    Need Help - currency error in in F&O Report
    Hi,
     
    Can you elaborate on your question? Which exact report are you running and how or where do you change the currency?

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans