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
Sohaib Cheema
665
User Group Leader
Martin Dráb
595
Most Valuable Professional
Yng Lih
558