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: Only interpreted values are validated. If you enter InvoiceTotalVatExcludedAmount manually in Verify, this validation is turned off to prevent endless loops of changes and validation errors. However, you still get the validation if you manually change the line item totals that are included in 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 |
|
|
4 |
6.50 |
26.00 |
|
|
1 |
20.99 |
20.99 |
|
|
61.96 |
||
|
|
8.67 |
||
|
|
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.
0 – disabled
1 – enabled