Tax Zone vs Tax Code Mismatch

Question

When attempting to run Prepare Tax Report for one of our Canadian tax agencies, the system generates the following error:

Error: Warning Error: : Error: There are transactions for tax(es) GST000,PST000 that could not be included into report. Please check tax configuration.

I have identified that the issue stems from Header Tax Zone vs. Line Tax ID mismatches on multi-jurisdiction documents.

For example, An AP Bill is created with a Tax Zone “ON”. Specific line items on the bill carry tax categories/codes for other provincial/federal jurisdictions (“QC” or “BC”). Because the Tax Zone stamped on the document header does not match the allowed Tax Zone mappings defined in the Tax Agency / Tax ID reporting groups, the tax reporting engine doesn’t include these transactions when a tax report is prepared/released.

Has anyone else run into this issue and do you have a solution?

Rachel Merritt · Answer

The warning you’re seeing appears when taxes were calculated during the reporting period but those taxes are not included in any reporting group used by the tax report. Even though the warning appears, the system still allows the tax report to be released.

What to check

Go to Taxes (TX205000) and open the tax IDs mentioned in the warning (e.g., GST000, PST000).
On the Tax Schedule tab, review which reporting groups are assigned to those taxes.
Open Reporting Groups (TX205200) and confirm that the reporting group used by the tax agency actually contains the required report lines.
If needed, adjust the reporting lines in Reporting Settings (TX205100) so the taxes are included in the correct reporting group.

Important:

If a tax report has already been prepared, it must be voided first before changing reporting group assignments. After updating the configuration, prepare the tax report again.

Also note that report lines accumulate amounts based on the taxes included in the selected tax zone, so mismatches between the document’s tax zone and the taxes used on lines can affect how those amounts are accumulated in reporting.

Here are a few links that may also help:

https://beacon.acumatica.com/r/Form-Reference-Guide/Taxes-Forms/Reporting-Settings

Sign up

Social Login

Login to the community

Social Login