Mechanism of tax calculation at POS in iVend

Mechanism of tax calculation at POS in iVend

Introduction

The tax of the product is displayed at the POS when it is being transacted. The system will follow a sequence of methods as detailed below, when attempting to select a tax code for a product on the transaction line.


It will stop its search when it finds the applicable tax code at any of these steps in the sequence of order documented here:


1. Overridden Tax code for the Line Item - 

The system first checks if the user at the POS has overridden the selected tax code for the product being transacted through an Item Edit option. If they have, then that tax code is selected.


2. Exempt Tax codes - 

In case that the “Exempt Tax code” is defined in any of the following places, then no tax will be calculated:

a. If the Store Sales Tax code is marked as Exempt Tax Code (Rate = 0.00%)

b. If the customer sales tax code is marked as Exempt Tax Code (Rate = 0.00%)

c. If the product sales tax code is marked as Exempt Tax Code (Rate = 0.00%)

d. If the warehouse sales tax code is marked as Exempt Tax Code (Rate = 0.00%)


3. Overridden tax code for the Transaction -

If the tax is overridden at the transaction header level, then it is applied for all the items in the transaction except where the tax codes are applied out of the above two steps. The user at the POS can override the tax code for the transaction through the Sale Edit option.


4. Tax Event -

The System will check if any matching Tax Event Conditions are set up which can be applied on the transaction. If the system finds a matching Tax Event for the current business date, then that tax code would be applied on the scanned item(s). 


In case of conflict between multiple Tax Events, the system calculates tax in following order:

a. If the Tax Event is defined for “Customer”, then the tax is calculated accordingly for the defined customer.

b. If the Tax Event is defined for “Customer Group”, then the tax for all the customers under the defined group are calculated as per the defined customer.

c. If the Tax Event is defined for “Product”, then the tax is calculated accordingly for the defined product.

d. If the Tax Event is defined for “Product Group”, then tax for all the products under the defined group are calculated as per the defined product.


5. Tax Condition Setup -

The system will check if any matching Tax Conditions are set up which can be applied on the transaction. In case there are multiple Tax Conditions defined, then the tax condition which satisfies the maximum number of conditions shall be selected. In the event of a conflict, the system will resolve it by selecting the Tax Condition in the following order:

a. Customer

b. Customer Group

c. Product

d. Product Group


6. Customer Sales Tax Code -

Next the Sales Tax Code specified for the customer is checked and if found is selected. The Sales Tax Code for the customer is defined in the customer master screen in the Management Console under Operations, Business Partners.


7. Warehouse Wise Product Tax Code - 

Next, if the Sales Tax Code specified for the product under individual store locations is found then this is selected. The Sales Tax Code for this level can be defined on the product master screen under the product’s Inventory View.


8. Product Sales tax Code -

If none of the above Sales Tax Codes are found, the Sales Tax Code specified for the product itself is selected. The Sales Tax Code for the product is defined in the product master screen. You access the Product master in the Management Console under Operations, Inventory.


9. Store Sales Tax Code – 

The Sales Tax Code specified for the Store is selected if the other tax codes above have not been specified. The Sales Tax Code for the Store is defined in the Store screen in the Management Console under Administration, Retail Configuration.


10. Warehouse Sales Tax Code -

The Sales Tax Code specified for the Warehouse is selected if the other tax codes above have not been specified. The Sales Tax Code for the Warehouse is defined in the Warehouse screen in the Management Console under Administration, Retail Configuration.


11. Enterprise Sales Tax Code -

 If none of the above tax codes are found, then the system will look at the Sales Tax Code defined at the Enterprise. The Sales Tax Code for the Enterprise is defined in the Enterprise Settings in the Management Console at the Enterprise (Head Office) server under Administration, System Initialization.


    • Related Articles

    • Tax number field locked

      Environment: iVend 6.6 Patch: 7989 Problem Description: Tax number field locked Scenario: Unable to edit the Tax number field in customer Master, even though validation rule in not set for the particular field. Solution: 1) Go to Retail Profile >> ...
    • General Settings in SAP Business One

      Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...
    • iVend Patch not getting updated at POS

      Environment: iVend 6.6 Patch 7915 Problem Description: Patches in HO and the POS indicates that it has already been updated but in POS it stays in a cycle asking for an update and does not allow it to be done. Scenario: None Solution: 1) At POS the ...
    • Scan Sequence Resolution

      iVend POS – Barcode Scan Sequence Resolution Order The user at the POS scans either the barcode of the product when it is being transacted or swipes the loyalty card for the customer or the security user card. The system follows a sequence of methods ...
    • Tax not calculating for random sale transaction

      iVend version : 6.6 Problem statement : Tax is not calculating for random transaction. Automatic tax calculation is already configured for sale transaction. Symptoms: It is noticed that "Tax Free for Tax Inclusive Item Pricing" is enabled for that ...