PRB: InvalidDataVatMismatch when trying to export a Zetadocs Expenses report

This Zetadocs technical note applies to:

• Zetadocs Expenses
• Extension for Business Central (versions 1.2020049 to 1.2.20099)
• Connector for NAV (version 3.4.20071 and later)
• UK systems

Symptom

When exporting a report including two or more expenses with reclaimable VAT from Zetadocs Expenses to Business Central or NAV as a journal, the export fails and the report history shows an error similar to the following:

Sales Tax / VAT entry with keys UK STD percentage does not match the export data percentage. Check the sales tax rate configuration. [ERR_InvalidDataVatMismatch]"

Checking the Tax Details screen in Business Central for that company shows that the percentage rates match the configuration settings in the Zetadocs Expenses system.

Cause

When the Journal is created, the VAT Business and Product Posting Groups are not populated and the VAT amount is 0, but the Export Tax amount coming from Zetadocs Expenses has a value. This is caused because the Copy VAT Setup to Jnl. Lines option is not enabled in the General journal for Batch GENERAL settings.

Resolution

To solve the issue, you need to tick the box called "Copy VAT Setup to Jnl. Lines" in the setting on the General Journal for Batch GENERAL. If this isn't enabled, BC won't automatically calculate the Tax amount, which causes the export to fail. Enabling it will fix the export error.

Status

Equisys is aware of this issue and this behaviour is handled by the resolutions detailed above

Last updated: 5^th May 2021 (EG) 

Keywords: VAT, Tax