Equisys technical notes

Technical guidance, explanations and fixes for our products

PRB: InvalidDataVatMismatch when trying to export a Zetadocs Expenses report

Print

ZTN6014

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: 5th May 2021 (EG) 

Keywords: VAT, Tax

Equisys Logo, Document Management and Expense Management for Business Central
 

Replaced by script
Recent news

Understanding the profitability of projects is often a difficult and cumbersome process, especially if there is a lack of visibility around all the project costs. Getting that visibility of all ...

This article describes the new features and other improvements in the September 2021 update of the Zetadocs Expenses service. Zetadocs Expenses Release ...

North America
 
Equisys Inc
30000 Mill Creek Avenue
Suite 335
Alpharetta, GA 30022
USA
(770) 772 7201
Europe
 
Equisys Ltd
91 Southwark Bridge Road
London
SE1 0AX
United Kingdom
+44 (0)20 7203 4000
 

© Equisys Ltd
All rights reserved

© Equisys Ltd    All rights reserved    Contact    Privacy policy    Cookies