DoLineItemTableTotalTaxableAmountValidation
Found in
Section
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.
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