VAT validator

Validation rules of this type can be used to check imported price data whether the difference between gross prices and net prices is plausible.

Note
In the process of a transformation, the validation rule is applied to the transformed iPIM Supply attributes.

In order to set up a validation rule of this type, proceed as follows:

  1. Select the rule type “VAT validator” from the menu.
  2. Click on the Add button to call up the corresponding dialog box.
  1. Enter a name for the validation rule in the input field “Title”.
  2. Possibly enter a short description in the input field “Description”.
  3. Possibly tick the “Activate rule” checkbox to activate the rule.
  4. Possibly tick the “External rule” checkbox to define the rule as an external rule so that the validation result is also visible in iPIM SSP.
  5. Possibly tick the “Internal rule” checkbox to define the rule as an internal rule. An internal rule can be used as a subordinate rule of validation rules of particular ruletypes (since version 5.4.2).
  1. From the “Gross price” menu, select the iPIM Supply attribute that represents the gross price.
  2. From the “Net price” menu, select the iPIM Supply attribute that represents the net price.
  3. From the “VAT rate” menu, select the iPIM Supply attribute that represents the VAT rate (e.g. 19%, 7% etc.).
  4. In the input field “Deviation”, enter a value for the permitted deviation. This value specifies by how much the imported net price may deviate from the net price that was calculated on the basis of the imported gross price and the imported VAT rate.
  5. Determine the behaviour in case of an unsuccessful validation. In order to do so, select the appropriate option from the “Result of validation rule hits” menu:
    • Error: The corresponding items are marked as invalid.
    • Warning: The corresponding items are flagged with a warning.
    • Rule: A subordinate rule is carried out. Select the subordinate rule from the menu (since version 5.4.2).
  6. Possibly configure a test run and carry it out in order to check if the configuration of the rule is valid.
  • In order to finish the configuration, click on the Save button. If the process was successful, a corresponding message will appear. The validation rule of is now set up.
  • In order to cancel the process, click on the Cancel button.