Set Third-Party AP Interface Options
PowerShift includes a number of customer-specific solutions to automate transferring data to and from PowerShift; the third-party AP interface is one example.
Select Third-Party AP Interface Options in System Options Maintenance (XM) to set parameters for using a third-party system for processing AP invoices and payments. See also Processing ACH Payments through Concur.
The *SECURE password must have access to the work, file and archive directories you specify.
Work, drop and archive directories must be unique; a file prefix must be used to identify file type (e.g., api for invoices, apc for payments).
All directories specified need to be same type (i.e. if your drop file directory is a native directory, the work and archive directories must also be native directories).
When the interface is first activated or if you change the configuration, you will need to restart the interface or shutdown and restart PowerShift.
Set these options for your enterprise:
Field Name |
Type / Max Length |
Action / Description |
AP invoice drop files active? |
Optional |
Select if you want to activate drop files for AP invoices or leave blank if you do not. If you do not activate the drop file interface, you can specify the files to import and control when they are processed. |
Administrator email address |
Conditional / Required |
Enter the email address of the person who should receive the log files and error reports when AP invoices are processed. |
Default user ID |
Required |
Select the user ID that you want to use as default user ID for AP invoice transactions. |
User ID for notification |
Required |
Select the user ID that you want to use as default user ID for email notifications of incoming invoices and payments. |
Notification device |
Optional |
Select the output device for the processed payments report. If an email device is selected (HTML output recommended), the email address associated with the User ID for notification is used. If left blank, no report is issued. |
Demo/live mode |
Required |
Select DEMO mode if using test/demo data; select LIVE if live data is used |
Drop directory |
Conditional |
Enter the directory for drop files. This directory can be a native directory with files created as text files or it can be a standard Qantel directory for sequential files. |
Work directory for processing |
Optional |
Enter the directory to be used to copy files temporarily when they are received in the drop directory. |
Archive directory |
Optional |
Enter the directory in which drop files are to be archived. This directory can be a Qantel or a native directory. If specified, you will need to establish a method for periodic purging of archive files. Archive files are named with the prefix APV followed by a sequentially-assigned number. |
Polling interval |
Optional |
Enter the number of "system" seconds for the interval between checks for drop files. An entry of 0 defaults to an interval of 10. |
| Outbound files | ||
AP Package/TAPMB format |
Optional |
The third-party AP package being interfaced or the format specified in Format Mapping Maintenance (XMAP) for outgoing AP invoice files. This format must be set up in Payment Method Batch Maintenance (TAPMB) for processing payments to this third party. |
Delimited or Fixed length |
Optional |
Select D (delimited) if data in the outgoing invoice file is delimited; select F (fixed length) if the data is in fixed length fields. |
AP invoice report output device |
Optional |
Select the output device for producing a report of the invoices sent out to a third party for payment. This report is produced during the Check Print (NCP) process when invoices are selected. |
PS base path |
Optional 64 alphanumeric |
Enter the base path name for the outgoing invoice files. The directory specified in Format Mapping Maintenance (XMAP) for your corresponding format is concatenated to this base path to provide the location for outgoing files. |
Archive view |
Optional 64 alphanumeric |
Enter the viewing path of the archive folder. |
External user ID to send |
Conditional 20 alphanumeric |
Some third party packages may require a specific user ID to be sent in the outgoing invoice records. That user ID may be entered here. |
| Inbound files | ||
Invoice file prefix |
Required |
Enter the prefix for incoming invoice files. |
Payment/PO file prefix |
Required |
Enter the prefix for incoming payment files. |
Field delimiter - invoices |
Conditional |
If data in the invoice drop files is delimited, enter the field delimiter such as T for tab or a ; (semicolon). |
Field delimiter - payments |
Conditional |
If data in the payment drop files is delimited, enter the field delimiter such as T for tab or a ; (semicolon). |
Tax org/account |
Conditional |
Enter the organization and account to be used to post taxes on incoming invoices. |
Freight org/account |
Conditional |
Enter the organization/account to be used for posting freight charges on incoming invoices. |
Default AP org |
Conditional |
Select the default accounts payable organization |
Click Other info if you will be using ftp for file transfer:
Field Name |
Type / Max Length |
Action / Description |
| Ftp active? | Optional | Select if you will be using ftp for file transfer. |
| Ftp path/host name | Conditional | |
| Ftp user name | Conditional | |
| Ftp password | Conditional | |
| Ftp inbound path/dir: Live | Conditional | |
| Ftp inbound path/dir: Test | Conditional | |
| Inbound file prefix 1 | Conditional | |
| PowerShift file name 1 | Conditional | |
| Inbound file prefix 2 | Conditional | |
| PowerShift file name 2 | Conditional | |
| Inbound file prefix 3 | Conditional | |
| PowerShift file name 3 | Conditional | |
| Outbound base path: test | Conditional | |
| Outbound base path: live | Conditional | |
| Check file destination: test | Conditional | |
| Check file destination: live | Conditional |
Choose the appropriate options:
To |
Do This |
Change an option |
Move the cursor to the appropriate field and make the required change. |
Switch from/to the main configuration screen from/to ftp-specific options |
Click Other info. |
Exit without changing these options |
Click Cancel. |
Print these options |
Click Print. See Print an Inquiry. |
Accept these options and exit |
Click OK. |
Exit from the detail screen |
Click Exit. If you have made any changes that have not been saved, you will be prompted to save them. |
Choose the appropriate options when you return to the System Options Maintenance screen:
To |
Do This |
Display a category of options |
Highlight the line and click Select or double-click the line. |
Exit the program |
Click Cancel or Exit. |