Extract data from Chinese VAT invoices issued by manufacturers — vendor, buyer, VAT details, goods, quantities, prices, currency, and totals.
The Invoice CN skill extracts data from VAT invoices posted by manufacturers from China. A VAT invoice is a document issued by a seller to a buyer that lists the goods or services supplied. A VAT invoice typically contains the following information:
The list of goods or services supplied and their quantity and price
The total amount payable for the goods or services
The currency to be used for payment
A description of the goods or services
Details about the seller and the buyer
The number and date of the invoice
Applicable taxes
The Invoice CN skill is a production skill. It has been fully trained on a large document set and provides high accuracy of data identification and extraction. The skill is ready to be used in production and does not require further training on your specific documents. Accuracy and straight-through processing (STP) rates can be further optimized in production through continuous learning from human-in-the-loop feedback.This skill is designed for processing VAT invoices from China, which have a specific structure that does not change from document to document. Other types of invoices from China may not be processed correctly using this skill.The Invoice CN skill does not use the Vendors, BusinessUnits, PurchaseOrders and PurchaseOrderItems data catalogs.
Countries and Languages
Countries
Languages
China
Chinese (Simplified)
English
Extracted Fields
Asterisk (*) indicates a required field or field group. Values cannot be empty.
Business Unit (BU)
Field
Description
Name
The invoice recipient’s name.
Tax ID
The invoice recipient’s taxpayer identifier.
Address
The address of the invoice recipient.
Country
The address of the invoice recipient.
Phone
The invoice recipient’s phone number.
Bank Name
The invoice recipient’s bank name and branch (if specified).
Bank Account
The invoice recipient’s bank account number.
Vendor
Field
Description
Name
The vendor’s name.
Tax ID
The vendor’s taxpayer identifier.
Address
The vendor’s address.
Country
The vendor’s address.
Phone
The vendor’s phone number.
Bank Name
The vendor’s bank name.
Bank Account
The vendor’s bank account number.
Header Fields
Field
Description
Invoice Number
The number of the invoice.
Invoice Date*
The date when the invoice was issued.
Invoice ID
The invoice identifier.
Total*
The total cost of goods or services.
Currency
The currency of the invoice.
Purchase Order
Field
Description
Order Number
The purchase order number.
Line Items (repeating group)
Field
Description
Description
A description of the line item.
Article
The article number or code of the line item.
UoM
The unit of measurement used for the goods.
Quantity
The number of line item units purchased.
Unit Price
The price of one unit of the line item goods.
Net Price
The price of the line item before tax.
Tax Rate
The tax rate applicable to the line item.
Tax Amount
The amount of tax payable on the line item.
Taxes
Field
Description
Total Net Amount
The total cost of goods and services without tax.
Total Taxes
The total amount of tax charged.
Tax Rate
The tax rate.
Key Fields
Vendor/Name
Invoice Date
Invoice Number
Total
Currency
Validation Rules
Rule
Description
Invoice Date is required
Checks that the Invoice Date field is filled in. If the field is empty, displays a message that it is a required field.
Total is required
Checks that the Total field is filled in. If the field is empty, displays a message that it is a required field.
Set Default Country
If the values for the Business Unit (BU)/Country and Vendor/Country fields are either missing from the document or have not been extracted, fills them in using the following value: “中国”.
Process money fields and currency
Checks that the value Currency field is a supported currency. If not, sets the value to “CNY”. Currency descriptions are replaced with ISO codes.
Check Total Net Amount
Checks if the value of the Total Net Amount field equals the sum of the Line Items/Net Price fields. If not, displays a warning message and suggests filling in the fields with their calculated values.
Check Total Taxes
Checks if the value of the Total Taxes field equals the sum of the Line Items/Tax Amount fields. If not, displays an appropriate message and suggests filling in the fields with their calculated values.
Check Sum
Checks if the value of the Total field equals the sum of all line items (Total Net Amount) after taxes (Total Taxes). If not, displays an appropriate message and suggests filling in the fields with their calculated values.
Check item amount
Checks the following: 1. That the number of units for each line item (Quantity) multiplied by the price of a unit (Unit Price) equals the price of the goods or service before taxes (Net Price). 2. That the price of the goods or service before taxes (Net Price) multiplied by the tax rate (Tax Rate) equals the value in the Tax Amount field. Removes the percent sign (%) from the value in the Tax Rate field. For each invoice line item, suggests values for the following fields (wherever calculating them is possible): Quantity, Unit Price, Net Price, Tax Rate, and Tax Amount.
Complete Tax Rate
Checks that the value of the Tax Rate field equals the following: Total Taxes*100/Total Net. If the values are different or Tax Rate is empty, suggests filling it with its calculated value.
To fill in a field with its calculated value, click the suggested value button in the value region of the field and select one of the suggestions from the drop-down list.
Was this page helpful?
Assistant
Responses are generated using AI and may contain mistakes.