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