Welcome > Configure Kofax AP Agility > Manage Invoice Processing > Project and field configurations > Configure the Vendor ID field > Configure a Vendor and Site ID field

Configure a Vendor and Site ID field

Use the instructions in this section if you have a single vendor at a single address that is represented in the downstream ERP system by a combination of a vendor ID and a site ID. Kofax AP Agility permits the use of a composite key within the vendor file extract, so the two values need to be within a single column.

The formula for combining the Vendor ID and the Site ID is as follows. 

Unique Identifier = VendorID + [Separator] + Site ID

For example, if the vendor ID is A12345, the Site ID is 1000D, and the designated separator is a hyphen (-), then the Vendor Extract file must have the following in the unique identifier column. 

A12345-1000D

The nominated separator is specified within the Alph Num Site Separator setting in the Settings > Invoice Processing > Capture Profiles > Vendor Settings. An error is displayed if this configuration is not followed, or more than one separator is found as part of a single unique identifier.

Therefore, in the BRWVendorMaster table, the following columns are required.

  • A column representing the combined unique identifier.

  • A column representing the site ID.