Available rules

Invoice validation rules

Any pre-configured rules can be disabled by the user in the properties of the Document Definition. It is also possible to create user-defined rules.

Field groups Rule Description Enabled by default (Invoice Processing (Au-NZ)) Enabled by default (Invoice Processing (CA)) Enabled by default (Invoice Processing (ES)) Enabled by default (Invoice Processing (EU)) Enabled by default (Invoice Processing (US)) Enabled by default (Invoice Processing (JP))
Business Unit Information about business units must be added to database

This rule checks if a new business unit that was found on the image and was saved to the BU data set has been added to the database.

* This rule must be enabled when business unit databases are used.

No No Yes Yes No No
Business Unit's address is required This rule checks to make sure that the BU\Street field is not empty. No No Yes Yes No No
Business Unit's name is required This rule checks to make sure that the BU\Name field is not empty. No No Yes Yes No No
Business Unit's VATID is required

This rule checks to make sure that the BU\VATID field is not empty.

* The rule is applied to invoices from all supported countries except Switzerland.

No No Yes Yes No No
Check ABN This rule checks if the BU\VATID field for AU invoices is filled in. Yes
Business Unit must be found in database

This rule checks if the business unit found on the invoice image is found in the BU data set.

* This rule must be enabled when business unit databases are used.

Yes Yes Yes Yes Yes Yes
Business Unit's Country is required This rule checks to make sure that the BU\Country field is not empty. No No No No No No
Check tax rates on national invoices This rule checks that the applied tax rates are correct for invoices from the same country. The possible tax rates and their validity periods are known for each country. No No Yes Yes No No
Check Tax Rate JP This rule checks that the applied tax rates are correct. Yes
Check tax rates field on international invoices This rule checks that the applied tax rates are correct for international invoices. The possible tax rates and their validity periods are known for each country. No No Yes Yes No No
Vendor Vendor address is required This rule checks to make sure that the Vendor\Street field is not empty. No No Yes Yes No No
Vendor name is required This rule checks to make sure that the Vendor\Name field is not empty. No No Yes Yes No No
Vendor VATID is required

This rule checks to make sure that the Vendor\VATID field is not empty.

* The rule is applied to invoices from all supported countries except Switzerland.

No No Yes Yes No No
Vendor must be found in database

This rule checks if the vendor that was found on the invoice image is also present in the vendor data set.

* This rule must be enabled when vendor databases are used.

Yes Yes Yes Yes Yes Yes
Vendor details must be added to database

This rule checks if a new vendor that was found on the image and was saved to the vendor data set has been added to the database.

* This rule must be enabled when vendor databases are used.

No No Yes Yes No Yes
Vendor's bank details are required This rule checks if IBAN, Bank code, and Bank Account correspond to values in the vendor data set. No No Yes Yes No No
Check vendor's bank details against database This rule checks that the vendor's bank details detected on the invoice image are the same as the bank details in the Vendor data set. No No Yes Yes No Yes
Invoice Header Data Invoice number is required This rule checks to make sure that the Invoice Number field is not empty.

Yes

* This rule is applied to invoices from Canada, Australia, and New Zealand

Yes

* This rule is applied to invoices from all supported countries except Switzerland.

Yes

* This rule is applied to invoices from all supported countries except Switzerland.

Yes

* This rule is applied to invoices from all supported countries except Switzerland.

Yes

*This rule is applied to invoices from Canada

Yes

* This rule is applied to invoices from all supported countries except Switzerland.

Invoice date is required This rule checks to make sure that the Invoice Date field is not empty.

Yes

* This rule is applied to invoices from Canada, Australia, and New Zealand

Yes Yes Yes Yes Yes
Delivery date is required This rule checks to make sure that the Delivery Date field is not empty. The rule has no effect if Delivery Date Indicator is set. No No No No No No
Delivery date must be earlier than Invoice date The following check is performed: delivery date is within the interval Delivery Date <= Invoice Date. No No No No No No
Delivery date must not be earlier than a year ago The following check is performed: delivery date is within the interval Today - 365(366) days <= Delivery Date No No No No No No
Check currency value This rule checks to make sure that the currency is the same as one of the currencies specified for the project. Yes Yes Yes Yes Yes Yes
Amounts Total is a required field This rule checks to make sure that the Total field is not empty. Yes Yes Yes Yes Yes Yes
Amount check This rule checks if Net Amount + Tax Amount = Total. If additional costs or discounts are detected, then the rules checks if Net Amount + Tax Amount + Additional Costs = Total. No No Yes Yes
Tax Rate field must not be empty If either Net Amount or Tax Amount is not empty, then the respective Tax Rate should not be empty. No No Yes Yes No No
If tax rate is detected, pre-tax amount is required

This rule checks to make sure that for each detected tax rate, the corresponding Net Amount field is not empty.

* This rule is applied only to invoices from Germany.

No Yes Yes Yes Yes Yes
If tax rate is found, tax amount is required This rule checks to make sure that for each detected tax rate, the respective Tax Amount is not empty No Yes Yes Yes Yes Yes
Total Tax is required field

This rule checks to make sure that the Amounts\Total Tax Amount field is not empty.

* This rule is applied to invoices from all supported countries except Germany.

No No Yes Yes No No
Check Tax field This rule checks to make sure that for each detected tax rate, the respective Tax Amount is correct for the respective NetAmount and TaxRate (i.e. that the arithmetic equality TaxAmount = (TaxRate / 100) * NetAmount is true). No Yes Yes Yes Yes Yes
Check Total Tax field

The following check is performed:

Total Tax Amount = Tax Amount 1 + Tax Amount 2.

* This rule is applied to invoices from all supported countries except Germany.

No Yes Yes Yes Yes Yes
Check Net Total field

The following check is performed:

Total Net Amount = Net Amount 0 + Net Amount 1 + Net Amount 2.

If the Total Net Amount field is empty, this rule enters data into the field according to the calculations.

No Depending on the field group to which this rule is applied. Yes Yes No No
Check Total field if total tax amount is required

This rule checks to make sure that the sum of the detected net amount, tax amount, and additional costs is equal to Total.

* This rule is applied to invoices from all countries except Germany.

No No Yes Yes Yes No
Check Total field if total tax amount is optional

This rule checks to make sure that the sum of each found net amounts, tax amounts, and additional costs is equal to Total

* This rule is applied to invoices from Germany.

No Yes Yes Yes Yes Yes
Verify net total against order items This rule checks the sum total of the values in the TotalPriceNetto column of the LineItems table against the invoice amount prior to taxes (TotalNetAmount). No No No No No No
Purchase Order Check invoice line items count against order items count This rule checks if the number of line items in an invoice is the same as the number of line items in the corresponding purchase order. No No No No No No
Check purchase order number and amount This rule checks if the order number and amount captured from an invoice correspond to the orders in the PurchaseOrders data set.

Yes

if the Purchase order matching feature is enabled (See Additional fields)

Yes

if the Purchase order matching feature is enabled (See Additional fields)

Yes

if the Purchase order matching feature is enabled (See Additional fields)

Yes

if the Purchase order matching feature is enabled (See Additional fields)

Yes

if the Purchase order matching feature is enabled (See Additional fields)

Yes

if the Purchase order matching feature is enabled (See Additional fields)

Copy PO data to TrainablePO This rule copies the  PurchaseOrders group fields whose regions have been found on the invoice  to the group being trained. Yes Yes Yes Yes Yes Yes
Check if invoice line items are matched with unique order items This rule checks if there are multiple line items in an invoice associated with one and the same line item in the purchase order. No No No No No No
Line Items Check item amount For each invoice item, this rule checks to make sure that the following is true: Quantity * UnitPrice is the same as TotalPriceNetto for the item after DiscountPercentage is applied.

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Match invoice line item with order item This rule checks to make sure that each line item from an invoice has corresponding item in the PurchaseOrderItems data set.

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Check LineItems currency value This rule checks to make sure that the currency of the line item is the same as one of the currencies specified for the project.

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Yes

if the Line items extraction feature is enabled (See Additional fields)

Price per unit is required This rule checks to make sure that the Unit Price column is not empty.

No

*This rule is applied to invoices from Canada, Australia, and New Zealand

No

*This rule is applied to invoices from Canada

No

*This rule is applied to invoices from Canada

No
Line level Total is required This rule checks to make sure that the Total Price Netto field is not empty.

No

*This rule is applied to invoices from Canada, Australia, and New Zealand

No

*This rule is applied to invoices from Canada

No

*This rule is applied to invoices from Canada

No
Quantity is required This rule checks to make sure that the Quantity column is not empty.

No

*This rule is applied to invoices from Canada, Australia, and New Zealand

No

*This rule is applied to invoices from Canada

No

*This rule is applied to invoices from Canada

No
Check GL Code This rule checks if the value of the field is in the GLCodes data set. It is also used for making a list of suggestions for stations.

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Check cost center This rule checks if the VendorId, the associated BUId and the associated LineItems/CostCenter field are present in the CostCenters data set. It is also used for making a list of suggestions for stations.

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Service rules

These rules do not affect the status of a document and do not issue any messages to Operators. They are required for the correct operation of the ABBYY FlexiCapture for Invoices Document Definition.

Any pre-configured rules can be disabled by the user in the Document Definition properties. It is also possible to create user-defined rules.

Field groups Rule Description Enabled by default (Invoice Processing (Au-NZ)) Enabled by default (Invoice Processing (US)) Enabled by default (Invoice Processing (EU)) Enabled by default (Invoice Processing (EU)) Enabled by default (Invoice Processing (US)) Enabled by default (Invoice Processing (Au-NZ))
Invoice Header Data Detect invoice type If Invoice Amount is negative or the words "Credit note" are found, the invoice type will be changed to Credit note. Yes Yes Yes Yes Yes Yes
Delivery Date field is empty or completed This rule sets/clears the value of Delivery Date Indicator field depending on whether the Delivery Date field is filled or not (if Delivery Date is empty, then Delivery Date Indicator is not set). This rule has no effect if Delivery Date Indicator has been verified. No No No No No No
Amounts Reversed Charge field is empty or completed If the only found VAT rate is equal to 0, or the words "Reverse Charge" are found, the value of the Reversed Charge field will be set to Yes. No No Yes Yes No No
Set currency to CAD or USD If no currency indicator is detected or if the $ is detected, sets the currency to Canadian dollars (CAD) if the vendor's country is Canada; or to US dollars (USD) if the vendor's country is the USA or any other country except Canada.

Yes

* This rule is applied to invoices from Canada and the USA

Yes

* This rule is applied to invoices from Canada and the USA

Yes
Set currency to AUD or NZD If no currency indicator is detected or if the $ is detected, sets the currency to Australian dollars (AUD), if the business unit's country is Australia, or to New Zealand dollars (NZD) if the business unit's country is New Zealand.

Yes

*This rule is applied to invoices from Australia and New Zealand

Detect national currency This rule automatically enters data into the Currency field (if it is empty) in invoices from France, Great Britain, and Spain. No Yes Yes Yes Yes Yes
Complete Total Additional Cost field Computers the total amount of additional costs. No No Yes No
Complete Tax Rate field if it is empty Computes the value of the tax rate, if it is not found on the invoice image and provided that the other tax fields have been found. No Yes Yes Yes Yes Yes
Complete Total Tax field if it is optional

This rule automatically enters data into the Amounts\Total Tax Amount field for countries where this field is not obligatory.

* This rule is applied only to invoices from Germany.

No No Yes Yes No No
Complete Total Tax field if only one tax rate is found This rule automatically enters data into the Amounts\Total Tax Amount if there is only one tax on the invoice. No No Yes Yes No No
Get summary information for Amounts group

This rule enters data into the Amounts\Summary field based on the following values:

Net0, Net1, Net2, Tax Amount 1, Tax Amount 2, Tax Rate 1, Tax Rate 2. Format: Sum (= Net0 + Net1 + Net2 + Tax Amount 1 + Tax Amount 2)+ AdditionalTaxGroups\ NetAmount + AdditionalTaxGroups\TaxAmount); and VAT rates which are found on the invoice. Example: 256; 0%

No Yes Yes Yes No No
Copy currency from LineItems If the Currency field (for the Total Tax Amount) is not found, the value is copied over from the LineItems table. No Yes Yes Yes Yes Yes
Collect matched order items (necessary for proper work of PO Matching at items level) Compiles a list of PO line items that are already associated with their corresponding invoice line items. In the case of manual comparison, the Operator will see only those invoice line items for which no matches has yet been found in the purchase order. Yes Yes Yes Yes Yes Yes
Line Items If Order is checked make all corresponding line items valid If the Is Valid option is selected for one of the line items when comparing invoice line items against the purchase order, all the other line items will be marked as valid. Yes Yes Yes Yes Yes Yes
Copy order number from PurchaseOrders group If the Order Number field of the LineItems table is not matched, the order number value will be copied into this table from the Order Number field (the order number from the PurchaseOrder group of fields) Yes Yes Yes Yes Yes Yes
Separate currency from amount in field This rule splits amount and currency and copies the currency to the Currency field if it is empty. No Depending on the field group to which this rule is applied Depending on the field group to which this rule is applied Depending on the field group to which this rule is applied Yes Depending on the field group to which this rule is applied
Add GL Code to Vendor This rule checks if the GLCode column in the Vendors data set contains the necessary value for a specific vendor. Performs the same check for both vendor and business unit if the BusinessUnitId column in the data set is mapped. If the GLCode column does not contain the necessary value, it will be copied from the LineItems/GLCode field.

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Set suggests list for GL Code This rule creates a list of suggestions for the GLCode field out of data from the GLCodes data set

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Fill in GL code This rule checks if the GLCode column in the Vendors data set contains the necessary value for a specific vendor. Performs the same check for both vendor and business unit if the BusinessUnitId column in the data set is mapped. If the GLCode column contains the necessary value, it will be copied from the data set to the LineItems/GLCode field.

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Set suggest list for cost centers This rule creates a list of suggestions for the GLCode field out of data from the CostCenters data set. The suggestions are filtered by their BUId values.

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

Yes

if the Line items extraction and GL Coding features are enabled (See Additional fields)

01.12.2020 7:03:59


Please leave your feedback about this article