This document explains how you can create a unique lookup table to automate both the retrieval of VAT exemption texts and the replacements of VAT codes.
Lookup tables with definition of VAT exemption texts per language and replacement VAT codes are created for the scenarios VAT exceptions are needed, based on the triggering factors selected by the company. The four types of tables consists of up to ten priority levels, each level with up to four control objects that create the matching conditions for the lookup. The most complex exception conditions for each type of VAT exceptions have the highest priority.
Select Control Objects
Start 'Available Object Control Parameters. Open' (CMS016).
For object 'Tax exemption texts', select option 11='Object table – detail lines' to display 'Generic Object Control Table. Open' (CMS017/B).
In the Program field, enter 'TXS020' and click Create.
On the E panel, enter the division and one of the following numbers in the 'Transaction type' field:
In the table, enter up to four control objects to apply for the line - such as Customer and VAT code - with the lowest sequence number and then continue with the other lines, if needed. End by pressing Enter.
Start 'VAT Exception. Open' (TXS020) in one of the following ways:
If you start (TXS020) from (CMS017) and the control object table selected had start value 1, (TXS020/B) is displayed with the view for VAT exemption texts by default. If the table had start value 2, the view for defining replacement of VAT codes on external sales is displayed by default.
In (TXS020/B), select the category for which to define VAT exceptions in the 'Text/VAT code' field if you started the program from the menu.
Select one of priorities 1 to 10 and click Apply.
The priority refers to internal order of a line in the control object table. For example, if the three first lines in the table have sequence numbers 10, 15 and 20 respectively, they correspond to priorities 1, 2 and 3 respectively in (TXS020).
When clicking Apply, fields are displayed in (TXS020/B) based on the control objects in the selected line in the control object table such as Customer and VAT code.
Select one of the following alternatives:
Define VAT Exemption Texts
In (TXS020/B), enter the control object-based values displayed.
If you want the rule to be limited in time, enter a valid date range. Click Create.
Important: You cannot change the date range once it is set. If you later want to adjust the date range, you copy the rule if the date ranges do not overlap, adjust the date range in the new rule and then delete the old rule. If the date ranges for the old and new VAT exceptions overlap, first delete the old one and then create a new one. Note that if you do not enter a date range for the VAT exception, it will be used as a general VAT exception unlimited in time, and no other VAT exceptions can be entered.
On the E panel, press Enter to confirm the selection.
On the text panel displayed (function program CRS980), enter text block ID TAXEXEMPT and the language for which the VAT exemption text is applicable. Click Create.
In the text box displayed, enter the VAT exemption text. Click Next to return to the previous text panel, where you can add new texts for other languages, always with the same text block ID TAXEXEMPT.
Press F3 to finish.
Define Replacement of VAT Codes
In (TXS020/B), enter the original VAT code and any other control object-based values displayed.
If you want the rule to be limited in time, enter a valid date range. Otherwise, leave the From and To date fields blank. Click Create.
The date range, once set, cannot be changed. If you later want to adjust the date range, you must copy the rule, adjust the date range in the new rule and then delete the old rule.
On the E panel, enter the replacement VAT code. Press Enter.