Applies to Product - Dynamics 365 for Finance and Operations (on-premises)
What’s happening?
Customers are experiencing missing data in financial reports, which may be related to issues with the financial reporting database. This can manifest as discrepancies between the standard trial balance and the financial report, or as an empty database after recreating the financial reporting database.
Reason:
The underlying causes for the missing data may include: - A need for a datamart reset after database recreation. - Issues with database memory cache or integration errors. - The financial reporting database being empty due to improper setup or configuration.
Resolution:
- For Missing Data in Financial Reports:
- Verify if the issue is present in all reports or specific ones. Gather specific report names.
- Check if the same results are generated from the report designer.
- Confirm the first occurrence of the issue and whether a repro report has been created.
- If the issue persists, consider performing a datamart reset, but be aware that this may take time to process.
- For Database Recreation Issues:
- Ensure that the financial reporting add-in is installed from the Lifecycle Services (LCS).
- Follow the documentation for setting up and deploying on-premises environments, ensuring all steps are correctly executed.
- After recreating the database, perform a datamart reset as per the guidelines provided in the relevant documentation.
- If the database remains empty, check for any integration errors in the event viewer logs and resolve any collation conflicts that may arise.
- General Steps:
- Review the financial reporting FAQ and troubleshooting guides provided by Microsoft for additional insights.
- If issues persist after following the above steps, consider reaching out to technical support for further assistance.