Views:

Applies to Product - Dynamics 365 Business Central


What’s happening?
Customers are experiencing issues where reports in Business Central, such as Sales Orders, Purchase Orders, and Sales Tax reports, are either blank or not generating any data.
 

Reason:
This are related to the configuration of the environment, specifically the Tax Posting Setup, which may be incorrectly configured. For US customers, the Sales Tax option should be used instead of Normal VAT.
 

Resolution:
For Blank Reports:

  1. Verify the configuration of the environment, particularly the Tax Posting Setup. Ensure that for US customers, the Sales Tax option is selected instead of Normal VAT.
  2. Check if there are any third-party extensions installed that may be affecting report generation. If so, consider removing these extensions and testing the reports again.
  3. Create a copy of the environment and remove all third-party extensions with their data, or alternatively, create a fresh sandbox without extensions and retest the report generation.
For Sales Tax Reports Not Generating Data:
  1. Ensure that the Tax jurisdictions and report filters are correctly set up. Validate that there are posted transactions in the tax ledger.
  2. If the report still generates no data, consider testing in a different environment to isolate the issue.
  3. If necessary, use the configuration package to update records from "Normal VAT" to "Sales Tax" entries in the system.
General Steps:
  1. If the issue persists after following the above steps, gather additional information such as tenant ID, environment name, and any relevant screenshots of the report generation process to assist in further troubleshooting.