English (English)

Validation rules

The Order Document Definition includes the following preconfigured validation rules (you can disable any of these rules in the settings of the Order Document Definition or create your own validation rules):

Field		Rule	Description
Total		Separate currency from amount in Total field	Separates the currency symbol from the amount if OCR fails to differentiate it from the digits.
Total		Amount check	Adds up the line item prices and additional costs and compares the result against the number in the Total field.
LineItems		Check item amount	Checks that the amount in each line item equals the quantity multiplied by the price minus the discount.
	UnitPrice	Separate currency from amount in LI_UnitPrice field	Separates the currency symbol from the amount if OCR fails to differentiate it from the digits.
	TotalPriceNetto	Separate currency from amount in LI_TotalPriceNetto field
	TotalPriceBrutto	Separate currency from amount in LI_TotalPriceBrutto field
	Quantity	Quantity is required	Makes sure that the quantity of goods has been detected.
	Currency	Hide currency if total empty	Removes the value from the Currency field if no Total field has been detected.
	Currency	Check LineItems currency value	Checks the value in the Currency field.
	ArticleNumberBU	Article Number must be found in database	Indicate whether only the article number or both the article number and the business unit must be present in the database.
	ArticleNumberBU	Article Number and BU must be found in database
Issuer		Buyer must be found in database	Indicate whether buyer details must be present in the database or added into the database.
Issuer		Buyer details must be added to database
DeliveryDate		Delivery date must be later than order date	Checks that the detected delivery date is later than the detected order date.
Currency		Set currency to CAD or USD	Sets the currency depending on the country of the business unit (CAD for Canada and USD for the USA).
		Detect national currency	Determines the currency based on the country of the business unit.
		Copy currency from LineItems	Copies the currency from LineItems (if available).
		Check currency value	Checks the value of the Currency field if the Total is not empty.
BU		Information about business unit must be added to database	Indicates whether business unit details must be present in the database or added into the database.
BU		Business unit must be found in database

The tax rules are identical to those used in invoice projects but are disabled by default. To enable the tax rule for your Orders project, enable the Taxes option:

In the Document Definition Editor, click Document Definition → Document Definition Properties....
In the dialog box that opens, click the Document Definition Settings tab and then click the Edit... button in the Additional Fields and Features group.

Tax validation rules for the Order Document Definition

Field		Rule	Description
Amounts		Check Total field if total tax amount is optional	Checks that the sum of all the pre-tax amounts (NetAmount0, NetAmount1, and NetAmount2), tax amounts (TaxAmount1 and TaxAmount2), and additional costs (AdditionalCosts) equals the amount indicated in the Total field. This rule can only be used for German purchase orders.
		Check Total field if total tax amount is required	Checks that the sum of all the pre-tax amounts (NetAmount0, NetAmount1 and NetAmount2), tax amount (TotalTaxAmount), and additional costs (AdditionalCosts) equals the amount indicated in the Total field. This rule can only be used for non-German purchase orders.
	TotalTaxAmount	Check Total Tax field	The following check is performed: TotalTaxAmount = TaxAmount1 + TaxAmount2 + Additional Tax Groups / TaxAmount. This rule can only be used for non-UK purchase orders.
		Total Tax is a required field	Checks that the Amounts\TotalTaxAmount field is filled in. This rule can only be used for non-German purchase orders.
		Separate currency from amount in TotalTaxAmount field	Separates the currency symbol from the amount if OCR fails to differentiate it from the digits.
		Complete Total Tax field if only one tax rate is found	Automatically completes the Amounts\TotalTaxAmount field for documents that contain only one tax rate.
		Complete Total Tax field if it is optional	Automatically completes the Amounts\TotalTaxAmount field for countries where this field is optional. This rule can only be used for German purchase orders.
	TotalNetAmount	Verify net total against order items	Adds up the values in the TotalPriceNetto column in the LineItems table and checks the result against the amount in TotalNetAmount.
		Separate currency from amount in TotalNetAmount field	Separates the currency symbol from the amount if OCR fails to differentiate it from the digits.
		Check Net Total field	The following check is performed: TotalNetAmount = NetAmount0 + NetAmount1 + NetAmount2. If the TotalNetAmount field is empty, this rule will complete his field with the calculated amount.
	Additional Tax Groups
	TaxRate, TaxAmount	If tax rate is detected, pre-tax amount is required	Checks that each detected tax rate has a corresponding non-empty NetAmount field.
	TaxRate	Complete Tax Rate field if it is empty	Calculates the amount for the TaxRate field and completes this field if no tax rate has been found on the image but other tax fields have been found.
	TaxRate	Tax Rate field must not be empty	Checks that each detected net amount or tax amount has a corresponding non-empty TaxRate field.
	TaxAmount	Check Tax field	The following check is performed: TaxAmount = NetAmount * (TaxRate/100).
	TaxAmount, NetAmount	Separate currency from amount in TaxAmount field	Separates the currency symbol from the amount if OCR fails to differentiate it from the digits.

Note: When using an external database, the country of a document is the country of the vendor's business unit. If no external database is used, the country will be determined by an automatic country detector.

12.04.2024 18:16:02

Please leave your feedback about this article

Name

E-mail

Comment

Your use of this site is conditioned on Your continued compliance with the Terms of Use.

Terms of Use

Disclaimer of Warranty

Limitation of Liability

Transmission and Submission of Information

Downloads

Use of Content

Trademarks

Links to Third-Party Sites

Foreign Legislation

Subscription Terms

Partner Subscription Terms

Validation rules

Tax validation rules for the Order Document Definition

Please leave your feedback about this article