ERP Connection: ERP Agnostic
This page enables you to add a new Agnostic ERP connection by configuring the following settings.
Setting |
Description |
---|---|
ERP Connection Name |
Enter a unique name for the ERP connection. (Mandatory) |
Description (Optional) |
Provide any important details about this ERP connection. (Optional, but recommended) |
Page Size |
An integer greater or equal to 100 that indicates the number of master data records that are returned by the web service for each call. (Mandatory) |
Use Default Null Values For Data Import |
Converts any values that are equal to "NULL," "Null," or "null" into actual null values when the data is imported. (Default: Selected) |
Input Path |
The path of the folder where the master data CSV files are stored. (Mandatory) For more information on this, refer to the Kofax AP Agility Installation Guide. |
Output Path |
The path of the folder where exported invoice data is stored. For example, invoice images or invoice xml files. (Mandatory) |
Export File Pattern |
Configure the file name by entering a pattern using the keywords below. (Default: [InvoiceId]_[InvoiceNumber]_[CurrentDateTime]) The following keywords are supported if they are enclosed in square brackets []:
During configuration, this form has built-in validation so it is not possible to add invalid characters. During export, it is possible for one of the keywords to include invalid characters. The keywords are replaced with their corresponding value and any invalid characters such as <, >, :, ", /,\, |, or ?, are removed when the document is exported. For example, [InvoiceNumber]_[VendorId]_[CurrentDateTime] where the [InvoiceNumber] value is DECD:D204NP is exported as DECD204NP_50045334_2021-07-07-02-59-02. This is because the colon (:) in the [InvoiceNumber] is an invalid character and is excluded from the output. |
Apply XSLT |
Select this setting if you want to apply an XSLT transformation to the exported XML files so that they are converted to CSV format. (Optional) (Default: Cleared) If the final result of the XSLT file is an XML file then the generated XML file is well-formatted XML. |
XSLT File Name |
This setting is available when Apply XSLT is selected only. The path and name of the XSLT file used to transform your XML output. (Mandatory) |
File Extension |
This setting is available when Apply XSLT is selected only. Enter a value to define the file extension of the generated file. (Optional) (Default: Cleared) If no value is provided for this new setting then the files will be generated without an extension. |
Use the following buttons to manage your ERP connection:
Button |
Description |
---|---|
Save |
Save the ERP connection and adds it to the table on the ERP Connections page. |
Close |
Closes the current page and returns to you to the ERP Connections page. If you click Close before saving your values, they are lost when you return to the ERP Connections page. |