These settings relate to tax extraction as well as automatic tax code determination for invoice creation.

The list of settings here can differ depending on what options are selected. If selecting an option displays additional settings, that information is included below.

Primary Rates

A comma-separated list of expected tax rates.

This list is optional, but does assist Kofax AP Agility to find the correct tax value on the document. Values matching the primary rate are prioritized over values entered as secondary rates.

Secondary Rates

A comma-separated list of expected tax rates.

This list is optional, but does assist Kofax AP Agility to find the correct tax value on the document.

Activate VAT Compliance Check

If selected, the system activates the VAT registration number compliance check. This means that if value added tax is charged on an invoice, the vendor and bill-to company VAT registration numbers are mandatory.

If VAT is charged in a currency that differs from the local currency of the addressed company code, then the exchange rate and/or local VAT amount fields are also mandatory.

This option is cleared by default.

VAT Check Company Code Exceptions

A comma-separated list of company codes that are excepted from the VAT registration number compliance rule.

Vendor VAT Check Only

If selected, the system requires the VAT registration number of the vendor, and not the registration numbers of the vendor and the bill-to party.

This option is cleared by default.

Vendor VAT Check Company Code Exceptions

A comma-separated list of vendor company codes that are excepted from the VAT registration number compliance rule. The behavior of this field depends on whether the Activate VAT Compliance Check option is selected above.

If Activate VAT Compliance Check is cleared, then any company codes listed here are excluded from the VAT check. If Activate VAT Compliance Check is not selected, then only company codes specified here are checked.

Check VAT Cross Border

If Vendor VAT Check Only is selected, then for the company codes listed, both the vendor and bill-to VAT registration numbers are mandatory.

Alternatively, if Vendor VAT Check Only is cleared, then only the vendor VAT registration number is mandatory for invoices belonging to the company codes listed here.

The cross-border VAT registration number check operates independently of the vendor-only VAT check.

This option is cleared by default.

Cross Border Company Code Exceptions

A comma-separated list of company codes that are excepted from the EU cross border VAT registration number check.

If Check VAT Cross Border is selected, then, for the company codes listed against this parameter, the cross-border VAT registration number check is not carried out. If Check VAT Cross Border is cleared, then the cross-border VAT registration number check is only carried out for invoices belonging to company code specified in this list.

Activate Tax Determination

If selected, the system activates the tax determination and validation feature. Otherwise, no tax code allocations or validations are carried out.

This option is cleared by default.

Validate Tax Amount

This applies to SAP implementations only.

If selected, the system validates the calculated tax amount using the tax codes found in the total tax amount from the invoice. If this amount is outside the Tax Tolerance set in the Settings > IP Configuration > Global Settings > Tolerance Settings, the document is parked in SAP.

This option is available only when Activate Tax Determination is selected above.

This option is cleared by default.

Always Use PO Tax Code

If selected, the system uses the tax code extracted from the purchase order.

This option is available only when Activate Tax Determination is selected above.

This option is cleared by default.

Always Use Calculate Tax Flag

If selected, the system requires the ERP system to calculate the tax amount rather than using the tax amount extracted from the invoice.

This option is available only when Activate Tax Determination is selected above.

This option is cleared by default.

Tax Flag Exception Company Codes

A comma-separated list of company codes that are excepted from the calculate tax flag rule.

This option is available only when Activate Tax Determination is selected above.

Validate From DB

If selected, tax codes are derived and/or validated against a database table. Do not use this table for countries where tax jurisdictions apply. For example, the US, Brazil, and Canada.

This option is available only when Activate Tax Determination is selected above.

Important This option and all of its dependent settings are not available in the Azure cloud environment.

This option is cleared by default.

Database Connection Name

The database connection that specifies the tax code database connection string.

This setting is available only when Validate From DB is selected above.

This option is available only when Activate Tax Determination and Validate From DB are selected above.

DB Schema

Enter the name of a schema to filter the list of database tables available for the selected Database Connection Name.

If this field is left blank, all database tables that you have permission to access, are displayed.

This setting is available only when Validate From DB is selected above.

DB Table Name

The name of the tax code database table. The list is populated based on the selected Database Connection Name and if used, the specified schema. If the selected table has columns that match the settings below, they are populated automatically.

This option is available only when Activate Tax Determination and Validate From DB are selected above.

Use Tax Partition

If selected, the tax partition ID is used when searching for the tax code in the database table. This value is specified in the DB Table Name option above.

Tax partitions allow tax code data relating to all organizations to co-exist in the same database table. This alleviates administrative burden of maintaining multiple tax code tables if multiple organizations are used.

The tax partition ID is set in the Tax Partition option in the Settings > Organizations for the relevant organization. Therefore, when the system reads the tax table to retrieve the tax codes for the invoice company code country, the organization tax partition ID is also used to ensure that the correct set of records for that organization is selected.

Export fails if no Tax Partition value is specified. Also, the system fails to retrieve any tax codes, and invoice line tax coding is not successful.

This option is available only when Activate Tax Determination and Validate From DB are selected above.

This option is cleared by default.

Check For ICMS Tax

ICMS is a form of sales tax used on Brazilian Nota fiscal documents.

If selected, the system attempts to identify this tax amount on incoming documents and applies validations to this field.

If cleared, it is assumed that the organization is not processing Brazilian Nota fiscal documents.

This option is available only when Activate Tax Determination is selected above.

This option is cleared by default.

Derive Ship To From Company Code

If selected, the ship-to country is set to the same value as the company code country.

This option is available only when Activate Tax Determination is selected above.

This option is cleared by default.

Read Plant From SAP

If selected, the system reads plant information from SAP to determine the ship-to location of the goods, for tax calculation purposes.

This option is available only when Activate Tax Determination is selected above.

Important This option is not available in the Azure cloud environment.

This option is cleared by default.

Read Plant From DB

If selected, the system reads plant information from a database to determine the ship-to location of the goods, for tax calculation purposes.

This option is available only when Activate Tax Determination is selected above.

Important This option and all of its dependent settings are not available in the Azure cloud environment.

This option is cleared by default.

Plant Database Connection Name

The database connection that specifies the plant database connection string.

This setting is available only when Validate From DB is selected above.

This option is available only when Read Plant From DB is selected above.

DB Plant Schema

Enter the name of a plant schema to filter the list of database tables available for the selected Database Connection Name.

If this field is left blank, all database tables that you have permission to access, are displayed.

This option is available only when Read Plant From DB is selected above.

DB Plant Table

The name of the plant database table. The list is populated based on the selected Database Connection Name and if used, the specified schema. If the selected table has columns that match the settings below, they are populated automatically.

This option is available only when Read Plant From DB is selected above.

Use Tax Partition

If selected, the tax partition ID is used when accessing the plant table. Entries are loaded if they have a tax partition that matches the tax partition for the current organization.

The tax partition ID is set in the Tax Partition option in the Settings > Organizations for the relevant organization.

This option is available only when Read Plant From DB is selected above.

This option is cleared by default.

DB Tax Partition

Enter the Tax Partition database column name that holds the Tax Partition ID. The Tax Partition ID is specified in the Settings > IP Configuration > Global Settings > Partition Settings > Tax Partition tab.

This option is available only when Read Plant From DB and Use Tax Partition are selected above.

DB Plant

The name of the column in the plant database table that contains the plant ID.

This option is available only when Activate Tax Determination and Read Plant From DB are selected above.

DB Plant Country

The column name in the plant database table that contains the plant country.

This option is available only when Activate Tax Determination and Read Plant From DB are selected above.

DB Plant State

The column name in the plant database table that contains the plant state location.

This option is available only when Activate Tax Determination and Read Plant From DB are selected above.

DB Plant Tax Jur Code

The column name in the plant database table that contains the tax jurisdiction code associated with the plant location.

This option is available only when Activate Tax Determination and Read Plant From DB are selected above.

Activate VAT Based Tax Processing

If selected, the Provincial Sales Tax,, Harmonised Sales Tax, and ICMS fields are deactivated and fields NetAmounts 0-4, TaxAmounts1-4, and TaxRate 1-4 are used instead.

If you are using this option, ensure that these fields are set to Active in the Settings > IP Configuration > Capture Profiles > Field Settings

This option is cleared by default.

Extract HST Separately

If selected, Harmonised Sales Tax is captured in the Harmonised Sales Tax field as opposed to the TaxAmount1 field.

This option is cleared by default.

CN Password Specials

A list of special characters that are permitted in the password block for domestic VAT invoices used in mainland China. The password should only consist of the digits 0-9, and the six special characters listed within this field. By default, the +<>-*/ characters are specified.

This field is configurable so additional special characters can be added if the government standards change in the future.

The system rejects the password field if it contains characters that are not included here.

CN Password Valid Length

A comma-separated list of the valid lengths for a password block that appears on a domestic VAT invoice used in mainland China.

By default, the values are 84,108. This means that a captured password must be either 84 or 108 characters in length. This reflects the current government standard, but the field is configurable in case this changes in the future.

The following buttons are available at the bottom of the window.

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.