Countries and Languages
| Countries | Languages |
|---|---|
| Australia | English |
| New Zealand |
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. |
| Delivery Date | The date the goods were delivered or services performed. |
| Due Date | The date by which the invoice should be paid. |
Business Unit (Invoice Recipient)
| 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). |
| State or Province | 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. |
| 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. |
| 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. |
| 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. |
| 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 Information
| Field | Description |
|---|---|
| Name | The vendor’s name. |
| Tax ID | The tax payer registration number. |
| 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. |
| State or Province | 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. |
| 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. |
| 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. |
| 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. |
| ID | The vendor’s unique identifier in an external system. Note: This field can only be obtained from the Vendors data catalog. |
Tax Information
| Field | Description |
|---|---|
| Total Net Amount | The total cost of goods and services without tax. |
| Total Taxes | The total tax amount. |
| Tax Rates (repeating group) | For each tax group: Net Amount. Cost of goods or services without tax. Tax Amount. Tax charged. Tax Rate. Tax rate. |
| Non Taxable Amount | The amount on which no tax is payable. |
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 vendor’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 applicable to 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 Items 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. |
Key Fields
- Vendor/Name
- Invoice Date
- Invoice Number
- Total
- Currency
Validation Rules
| Rule | Description |
|---|---|
| Total is required field | Checks whether the Total field is filled in. If it is not, displays a message saying that it is a required field |
| 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 |
| 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 |
| 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 |
| 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 |
| Check item amount | Checks that: 1. The number of units of each type (Quantity) multiplied by the unit price (Unit Price) is equal to the total amount charged before tax (Net Price) minus the applicable discount (Discount). 2. The total amount charged before tax (Net Price) multiplied by the tax rate (Tax Rate) is equal to the value of the Tax Amount field. 3. The sum of the values of the Net Price and Tax Amount fields is equal to the value of the Total Price field. For each invoice line item, suggests values for the following fields (wherever calculating them is possible): Quantity, Unit Price, Discount, Net Price, Tax Rate, Tax Amount, and Total Price |
| Separate currency from amount in LI money fields | Splits the amount and the currency in the corresponding field and copies the currency into the Line Items/Currency field if it is not filled in. Applies to: Line Items/Unit Price Line Items/Net Price Line Items/Total Price |
| 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 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 |
| 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. If the values are not equal, suggests filling in the fields with the calculated values. If the Total Taxes field is not filled in, fills it in with its calculated value. For each instance of the Tax Rates group: 1. Checks that (Tax Rate / 100) * Net Amount is equal to Tax Amount. 2. If Tax Rate, Net Amount, or Tax Amount is not filled in, suggests filling in these fields with their calculated values. 3. Removes the percent sign (%) from the value in the Tax Rate field |
| 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 |
| 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. If the Total Net Amount is not filled in, fills it in with its calculated value |
| Set default country | If a country has not been detected on the image, specifies the default country for the invoice. For Invoice AU-NZ, the default country is AU. |
| 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. If the vendor was not detected correctly, the operator may select a different vendor from the data catalog manually during manual review. The Vendor Id, Name, Street, Country, and Business Unit ID fields should be filled in in the Vendors data catalog |
| 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. If the business unit was not detected correctly, the operator may select a different business unit from the data catalog manually during manual review. The Business Unit Id, Name, Street, and Country fields should be filled in in the BusinessUnits 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. If several order numbers are detected, checks all of them and their amounts against the values in the data catalog. The Order Number field should be filled in 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. The Order Item ID and Order Number fields should be filled in in the PurchaseOrderItems data catalog |
| Check purchase order total amount | Checks if the value in the Total field equals the value of the Total field in the Purchase Order group when one purchase order is found. Checks if the value in the Total field equals the sum of values in Total fields in the Purchase Order group when several purchase orders are found |
| 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 in the Line Items group is unique for every purchase order number if the value of the Order Checked field 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 of the Line Items group. If they match in the Line Items group row, the value of the Is Valid field in the Line Items group value in that row is set to True |
| Copy order number | If there is only one value in the Order Number field in the Purchase Order group and the values in the Order Number field in the Line Items group are empty, copies the value of the Order Number field in the Purchase Order group to the values of the Order Number field in the Line Items group |
| 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 |
| 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 |
- Some of the rules will get new versions. The outdated versions will receive numbered postfixes (for example, Check item amount 1). Review these rules and remove any unnecessary versions from the derived skill.
- If you remove outdated Tax Rate X, Tax Amount X, and Net Amount X fields, the rules that checked them will become unnecessary. Remove those rules from the derived skill.
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.| 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 |
| PurchaseOrderItems | 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 |