DoLineItemTableTotalTaxableAmountValidation

Description

Validates the total taxable amount (InvoiceTotalVatExcludedAmount) to ensure that it equals the total taxable value (LIT_VatExcludedAmount) that is calculated by adding up all of the net values from the line items. For example, in the below example it would check whether 14.97 + 26.00 + 20.99 = 61.96.

The validation takes place:

  • In Interpret, during invoice validation.
  • In Verify, when all invoice fields are Complete.
Note The status of the InvoiceTotalVatExcludedAmount field is set to Validation error if there is a difference between InvoiceTotalVatExcludedAmount and LIT_VatExcludedAmount.

The status of the InvoiceTotalVatExcludedAmount field is set to Validation error if there is a difference between InvoiceTotalVatExcludedAmount and LIT_VatExcludedAmount.

Article no. Quantity Unit price Total price
165273 3 4.99 14.97
123222 4 6.50 26.00
219725 1 20.99 20.99
Total net amount 61.96
Tax 14%   8.67
Total invoice amount 70.63

In connection with this functionality, the DoLineItemTableTotalTaxableAmountValidation setting activates the use of these settings:

You can use BlockInvoicesNotPassingLineItemTableTotalTaxableAmountValidation to specify whether Verify operators are allowed to approve invoices where the line item table validation does not comply with specified tolerance values. And if that setting is enabled, it does not matter if InvoiceTotalVatExcludedAmount is entered manually in Verify; invoices are blocked from approval if there is a difference between InvoiceTotalVatExcludedAmount and LIT_VatExcludedAmount.

Valid values

0 – disabled

1 – enabled