Countries and Languages
| Countries | Languages |
|---|---|
| Austria, Belgium, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Hungary, India, Ireland, Italy, Latvia, Lithuania, Moldova, Netherlands, Norway, Poland, Portugal, Romania, Slovakia, Slovenia, Sweden, Switzerland, Turkey, United Kingdom | Bulgarian, Croatian, Czech, Danish, Dutch, English, Estonian, Finnish, French, German, Italian, Hungarian, Latvian, Lithuanian, Norwegian (Bokmal), Polish, Portuguese (Standard), Romanian, Slovak, Swedish, Turkish, Ukrainian |
Extracted Fields
Asterisk (*) indicates a required field or field group. Values cannot be empty.
Basic Invoice Information
| Field | Description |
|---|---|
| Invoice Number | The number of the invoice. |
| Invoice Date* | The date when the invoice was issued. |
| Total* | The total cost of goods or services. |
| Currency | The currency of the invoice. Note: The Currency field is required when the country is Denmark. |
Business Unit (BU)
| Field | Description |
|---|---|
| Name | The name of the business unit (invoice recipient). |
| Tax ID | The tax payer registration number. |
| Address | The address of the business unit (invoice recipient). The address will be extracted into this field, if no BusinessUnits data catalog is used or if the business unit has not been found in a data catalog. |
| Country | The country of the business unit (invoice recipient). |
| City | The address of the business unit (invoice recipient). This address format will be used if the BusinessUnits data catalog is used and the business unit has been found in the data catalog. For US invoices, these fields can also be obtained by parsing the Business Unit/Address field value. |
| Street | The address of the business unit (invoice recipient). This address format will be used if the BusinessUnits data catalog is used and the business unit has been found in the data catalog. For US invoices, these fields can also be obtained by parsing the Business Unit/Address field value. |
| Postal Code | The address of the business unit (invoice recipient). This address format will be used if the BusinessUnits data catalog is used and the business unit has been found in the data catalog. For US invoices, these fields can also be obtained by parsing the Business Unit/Address field value. |
| ID | The unique identifier of the business unit in an external system. Note: This field can only be obtained from the BusinessUnits data catalog. |
Vendor
| Field | Description |
|---|---|
| Name | The vendor’s name. |
| Tax ID | International tax payer registration number. |
| National Tax ID | The tax payer registration number inside the country of origin. |
| IBAN | The vendor’s international bank account number. |
| Bank Account | The vendor’s bank account. |
| Bank Code | The vendor’s bank code. |
| SWIFT Code | The SWIFT code of the vendor. |
| Address | The vendor’s address. The address will be extracted into this field, if no Vendors data catalog is used or if the vendor has not been found in a data catalog. |
| Country | The vendor’s country. |
| City | The vendor’s address. This address format will be used if the Vendors data catalog is used and if the vendor has been found in the data catalog. For US invoices, these fields can also be obtained by parsing the Vendor/Address field value. |
| Street | The vendor’s address. This address format will be used if the Vendors data catalog is used and if the vendor has been found in the data catalog. For US invoices, these fields can also be obtained by parsing the Vendor/Address field value. |
| Postal Code | The vendor’s address. This address format will be used if the Vendors data catalog is used and if the vendor has been found in the data catalog. For US invoices, these fields can also be obtained by parsing the Vendor/Address field value. |
| ID | The vendor’s unique identifier in an external system. Note: This field can only be obtained from the Vendors data catalog. |
Date Information
| Field | Description |
|---|---|
| Delivery Date | The date the goods were delivered or services performed. |
| Due Date | The date by which the invoice should be paid. |
Tax Information
| Field | Description |
|---|---|
| Reversed Charge | Indicates that a reverse charge is applied. |
| Total Net Amount | The total cost of goods and services without tax. |
| Total Taxes | The total tax amount. |
| Non Taxable Amount | The amount on which no tax is payable. |
Tax Rates (Repeating Group)
| Field | Description |
|---|---|
| Net Amount | Cost of goods or services without tax |
| Tax Amount | Tax charged |
| Tax Rate | Tax rate |
Invoice Type
| Field | Description |
|---|---|
| Invoice | Specifies the Invoice type of the invoice. |
| Credit Note | Specifies the Credit Note type of the invoice. |
Purchase Order
| Field | Description |
|---|---|
| Order Number | The number of the purchase order. |
| Total | The cost of the goods or services listed in the purchase order. Note: This field can only be obtained from the PurchaseOrders data catalog. |
| Order Checked | Indicates whether the order number is verified. The value of the field can be True or False. |
Line Items (Repeating Group)
| Field | Description |
|---|---|
| Order Number | The number of the purchase order. |
| Order Date | The date when the purchase order was created. |
| Position | The number of the line item in the list. |
| Article Number Vendor | The article number or code in the vendors’s database. |
| Article Number BU | The article number or code in the business unit’s database. |
| Description | A description of the line item. |
| Quantity | The number of units purchased. |
| Unit of Measurement | The unit of measurement used for the goods. |
| Unit Price | The price of one item of goods. |
| Discount Percentage | The discount percentage on the initial line item price. |
| Discount | Discount applicable to the line item. |
| Net Price | The price of the line item without tax. |
| Tax Rate | The tax rate for the line item. |
| Tax Amount | The amount of tax payable on the line item. |
| Tax Code | The code of the tax. |
| Total Price | The price of the line item including tax. |
| Currency | The currency of the line item. |
| Is Valid | Indicates whether the order number in the Line Item group matches any checked order number in the Purchase Order group. The value of the field can be True or False. |
| Order Item ID | The unique line item identifier. Note: This field can only be obtained from the PurchaseOrderItems data catalog. |
Ship To
| Field | Description |
|---|---|
| Name | The name of the recipient receiving the goods. |
| Address | The address of the recipient receiving the goods. |
Note: Older versions of this skill extracted the tax information into fields named Tax Rate X, Tax Amount X, and Net Amount X. In Vantage 2.4 and later, these fields are grouped into a repeating group called Tax Rates. If you are updating a copy of a built-in skill, check that the new Tax Rates group works for you. If you are satisfied with the results, remove the individual fields used in the older version. If not, create new fields to suit your processing scenario.
Key Fields
- Vendor/Name
- Invoice Date
- Invoice Number
- Total
- Currency
Validation Rules
When you update a copy of this skill to a derived skill, the rules will also be updated. Some rules will get new versions with numbered postfixes. Review these rules and remove any unnecessary versions from the derived skill.| Rule | Description |
|---|---|
| Currency is required | Checks whether the Currency field has been detected on the document. If not, displays a message saying that it is a required field. Note: The Currency field is required when the country is Denmark. |
| Total is required | Checks whether the Total field is filled in. If it is not, displays a message saying that it is a required field. |
| Invoice date is required | Checks whether the Invoice Date field is filled in. If it is not, displays a message saying that it is a required field. |
| Vendor Tax ID is required | Checks whether the vendor Tax ID field is filled in. If it is not, displays a message saying that it is a required field. |
| Separate currency from amount in LI money fields | Splits the amount and the currency in Line Items fields (Unit Price, Net Price, Total Price) and copies the currency into the Line Items/Currency field if it is not filled in. |
| Check invoice and line items currency | Checks that the value of the Currency and Line Items/Currency fields is a supported currency. If the currency is not supported or has not been extracted, suggests currency values from the appropriate invoice region. Currency descriptions are replaced with ISO codes. |
| Check item amount | Checks that the calculations for line items are correct (quantity × unit price = net price minus discount, net price × tax rate = tax amount, net price + tax amount = total price). Suggests values for the following fields where calculating them is possible: Quantity, Unit Price, Discount, Net Price, Tax Rate, Tax Amount, and Total Price. |
| Check LI Total Prices against Total Amount | Checks the value of the Total Amount field. If it is not equal to the sum of the Line Items/Total Price fields, suggests filling in the fields with their calculated values. |
| Check LI Net Prices against Total Net Amount | Checks the value of the Total Net Amount field. If it is not equal to the sum of the Line Items/Net Price fields, suggests filling in the fields with their calculated values. |
| Business unit must be found in database | Checks that the business unit details detected on the document image are the same as those in the BusinessUnits data catalog. If some entries are different, replaces the field values with values from the data catalog. |
| Check vendor details against database | Checks whether the appropriate entry in the Vendors data catalog has been found for the vendor bank details detected on the image. If the values in the data catalog are different, replaces the field values with entries from the data catalog. |
| Check purchase order number and amount | Checks that the order number and amount detected on the document image are the same as those in the PurchaseOrders data catalog. |
| Match invoice line item with order item | Checks invoice line item information against records in the PurchaseOrderItems data catalog. If the catalog contains an entry for a particular line item, fills in the corresponding Order Item ID field using the value from the data catalog. |
| Copy order number | If there is only one value in the Order Number field in the Purchase Order group and the values in the Line Items Order Number fields are empty, copies the value to all line items. |
| Check purchase order total amount | Checks if the value in the Total field equals the value or sum of values in the Purchase Order group Total fields. |
| Check matching of line items to unique order items | For all line items whose purchase order number is equal to the one extracted in the Purchase Order group, checks that the value in the Order item ID field is unique for every purchase order number if Order Checked is True. |
| If order is checked make line items valid | For each item in Purchase Order group that has the Order Checked field set to True, compares the order number to the order number in all line items. If they match, sets the Is Valid field to True. |
| Detect invoice type | Sets the type in the Invoice Type checkmark group. If the document is marked as credit note or if the value of the Total field is negative, sets the type to Credit Note. Otherwise, sets the type to Invoice. |
| Separate currency from amount in money fields | Splits the amount and the currency in fields containing currency amounts and copies the currency into the Currency field if it is empty. |
| Check Total Tax | Checks that the sum of the Tax Amount fields across the Tax Rates repeating group is equal to the value of the Total Taxes field. For each instance of the Tax Rates group, checks calculations and suggests values where needed. |
| Check Total field | Checks that the sum of the Total Net Amount and Tax Amount fields is equal to the total invoiced amount (Total). If the values are not equal or if the Total field is not filled in, suggests filling in the fields with their calculated values. |
| Reversed Charge field is empty or completed | If the document contains references to reversed charges, checks the values of the taxes fields. If they are empty, marks the Reversed Charge checkmark. Note: Does not apply to AU-NZ, CA, US, and JP regions. |
| Check Net Total | Checks that the sum of the Net Amount fields across the Tax Rates repeating group is equal to the total amount charged for the goods or services before tax (Total Net Amount). If the values are not equal, suggests filling in the fields with their calculated values. |
Parameters
The Invoice skills have default skill parameters that refer to data catalogs used for Vendor, Business Unit, and Purchase Order lookup. You can change the values of these parameters in Vantage or Advanced Designer to modify the field extraction process. For more information, see Skill parameters.| Parameter | Description |
|---|---|
| Vendors | The predefined data catalog used for Vendor lookup. The default value of this parameter is Vendors. You can change this value by choosing another available data catalog of the same type (Document Issuer Companies). |
| BusinessUnits | The predefined data catalog used for Business Unit lookup. The default value of the parameter is BusinessUnits. You can change this value by choosing another available data catalog of the same type (Document Receiver Companies). Note: This parameter is not available for the Invoice JP skill. |
| PurchaseOrders | The predefined data catalog used for Purchase Order lookup. The default value of this parameter is PurchaseOrders. You can change this value by choosing another available data catalog having the same structure. |
| PurchaseOrderDetails | The predefined data catalog used to check if the Purchase Order details match. The default value of this parameter is PurchaseOrderItems. You can change this value by choosing another available data catalog having the same structure. |