ERP Connection: PeopleSoft
This page enables you to add a new ERP connection by entering 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) |
URL |
The URL that points to the PeopleSoft web service. (Mandatory) |
Username |
Enter the username that is used to connect to the PeopleSoft web service. (Mandatory) |
Password |
Enter the password that is used to connect the PeopleSoft web service. |
Page Size |
Enter a positive integer that indicates the number of master data records that are returned by the web service for each call. (Mandatory) |
Export Destination |
Define the destination for export. Choose from one of the following values.
|
Export To Staging Operation |
Select a value for exporting to the staging operation. (Mandatory) Choose from one of the following values.
This setting is available only when the Export Destination value is set to VoucherStagingTable. |
Use Empty GL Code Value |
Select this setting to allow an empty or null values for a GL code. (Default: Cleared) |
Empty GL Code Name |
Enables you to provide the text that is displayed in the AP Workflow activities for selecting a GL Code when there is an empty value. (Mandatory) This setting is available only when the Use Empty GL Code Value setting is selected. (Mandatory) |
Start Data Load From |
Set the date for when you want to start loading information from the ERP system. (Mandatory) Each time the AP Data Import process runs, the Start Data Load From date and time stamp is updated with the current date and time. This ensures that the entire ERP is not loaded each time, only the changes since the last import. |
Start Data Load To |
Set the date for when you want to stop loading information to the ERP system. The interval between this and the Start Data Load From value indicate what is considered old and new data. |
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) |
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. |