VAT Taxes

VAT taxes are calculated by your SAP system at the time of posting. VAT taxes are calculated by SAP configuration that is not available to GLSU. While GLSU cannot calculate European VAT taxes inside the spreadsheet, it can allow transactions which contain VAT taxes to be successfully posted.

Header Field XMWST is the "Calculate Tax" field. This field can be added to your spreadsheet using the GLSU Ribbon > Choose Fields button.

A user can add the field XMWST to their spreadsheet and populate it with an "X" (see below). Once populated, the Calculate Tax field will disengage the standard GLSU balancing functionality that prevents GLSU from posting entries where debits do not equal credits. Once populated the balancing formula in the line item header will be changed to " – tax calc –" (see below).

The user is given the responsibility of sending GLSU and SAP an entry which will be properly balanced after VAT taxes are calculated and added to the posting.