Support for SAP United Kingdom – Ireland company localization

The Avatax add-on, the Avatax webUI and the Avatax EventService are now compatible with SAP B1 database companies using the United Kingdom/Ireland localization.

This localization uses Sales VatGroups instead of Sales TaxCodes. The solution is able to identify this and switch the behavior based on the company localization.

Taxes can be set to the document as a Line Item or as an Additional Expense.

The Avatax configuration settings looks identical for the user.

Minor fixes

Minor fixes included for some HANA filtering in Bulk Address Validation.

Fix for Return Request ShipTo selection error.

Fix for validating draft calculated taxes for return documents.

Support document lines with negative total

Document lines with negative total are now supported for tax calculation.

SAP let use some sales documents with negative totals, by setting the quantity to a negative value, the unit price as a positive value, and the total as negative.

Avatax now calculates taxes over that lines, and returns the tax calculated as negative.

You can mix negative and positive document lines in a single document without issues:

Clear previous tax calculations

Previously, when you had a document with tax calculated by Avatax, you change the calculation mode (Line Item, Additional Expense, External Tax), you could get a document with incorrect tax if don’t manually clear the previous calculation.

Now this feature has been included in the solution logic, and the calculation process takes cares of reviewing the full document, and clearing previous existing calculations before completing the new calculation and setting the tax with the configured mode.

The Avatax solution has been “Qualified” for integration with SAP Business One Cloud hosted by SAP successfully.

If you run SAP with this mode, you can follow this steps to get Avatax available in your SAP Cloud Instance:

Starting 2020 we have released a new SAP B1 Avatax add-on version including some very important changes, improvements and features.

All versions starting from 20xxxxxx are compatible with SAP 9.3 PL12 or later.

Main features released in this new add-on are:

This version is compatible with SAP 9.3PL 12

Added log entry for SAP document type

The SAP document type is logged now in the Avatax Log table, to record on what SAP document the calculation took place.

Fields are @ARGNS_ATX_LOG.U_SAPDoc and ARGNS_ATX_LOG.U_SAPDocStr

U_SAPDoc will have the SAP document object code, and U_SAPDocStr the SAP document object
description.

This version is compatible with SAP 9.3PL 12

Fix for empty freight lines

The SAP client adds an empty line on the freights window in some situations. The Avatax add-on now handle this without errors.

This version is compatible with SAP 9.3PL 12

Fix for DGW. Document discount

Document total discount was not copied from base documents in some scenarios.

Fixes were applied to copy the base document discount as expected.

This version is compatible from SAP 9.2 to SAP 9.3PL 11.

Fix for AR-DownPayment Reconcile

AR-DownPayment lines in SAP are always not liable.

Lines will be send to Avalara also as not-liable (exempt) to keep a clear logic and maintain same document information in SAP and Avatax.