Equisys technical notes

Technical guidance, explanations and fixes for our products

FIX: Export fails with Sales VAT percentage mismatch error on expenses with zero rate VAT applied

Print

ZTN6012

This Zetadocs technical note applies to:

  • Zetadocs Expenses Connector version 3.4.19344 and earlier
  • Zetadocs Expenses May 2020 update (version 3.4.20160)

Symptom

When exporting a report with expenses that reference a zero rate VAT/Sales tax, there may be instances where the export does not complete successfully, with an error similar to:

- Export of expenses for payment method Cash failed. Invalid data for Export Filter (StandardNonReimbursable). The VAT Posting Group with keys (ZERO) (ZERO) does not have a percentage of zero as expected.

Cause

A change was made to the software that caused an incompatibility for older versions of the connector, when using newly set up or modified zero VAT rates. Previously set up zero rate taxes had the ability to set the 'Standard Rate Export Code' to a value. Updated UI in the administration site has meant this is no longer the case and the 'standard rate' remains empty. This caused an issue when exporting to older versions of the connector as they expected this field to be populated.

Resolution

Later versions of the Zetadocs Expenses connector were compatible with this scenario. The August 2020 update of Zetadocs Expenses (version 3.4.20209.1004) restored compatibility with the older versions of the connector.

Status

This behaviour was corrected in the August 2020 update of Zetadocs Expenses (version 3.4.20209.1004) and is compatible with all supported versions of the connector

Last updated: 27th August 2020 (NT) 

Keywords: NAV Business Central

Equisys Logo, Document Management and Expense Management for Business Central
 

Replaced by script