How Payables Payment Request Import Data is Processed
Use the Import Payables Payment Requests process to create payment requests from data in the Payment Request interface table. After the import is complete, you can search for the payment requests in Payables to pay the invoices.
Create the payment requests by completing the following steps:
-
Prepare the data using the predefined XLSM template.
-
Generate the CSV file.
-
Transfer the data.
-
Load and import the data.
-
Reload the corrected data as necessary.
Settings That Affect the Import Payment Requests
This table describes the parameters for submitting the Payables Payment Requests Import process.
Parameter |
*Required |
Description |
---|---|---|
*Ledger |
Yes |
Enter the name of a ledger. |
Business Unit |
Optional |
Enter the name of the business unit for the payment request. |
*Source |
Yes Note: The Source used for importing payment requests must
be created in the Payables Lookups and in the Trading Community Architecture.
Configuring the source for Payables can be found in the FSM task:
Manage Payables Lookup with the lookup type as: SOURCE. Configuring
the Source for TCA can be found in the FSM task Manage Trading Community
Source Systems.
|
Enter the source of payment request. Note: The Party Original System Reference is a unique identifier
for the party in the source application. It should be unique for each
party. If the same value is used for multiple transactions, the application
creates just one party and uses the name from the first row. If an
existing Party Original System Reference is used in a subsequent batch,
then a transaction is created for the existing party and the party
name is updated.
|
Import Set |
Optional |
Enter the name of an import set to limit the import to payment request with a particular import set in the Payment Request Interface table. You can import data for the same source by specifying a unique import set for each request. This reduces the processing time of your import. The Import Payables Payment Request process imports data with the source and group combination that you specify. |
Invoice Group |
Optional |
Enter the name of an invoice group. |
Accounting Date |
Optional |
Enter an accounting date. If you don't enter a date, the Accounting Date is assigned based on the Accounting Date Basis option. |
Summarize Report |
Optional |
Enter whether to summarize the audit portion of the Payables Payment Request Interface Import Report. If you don't summarize, and you're importing a large number of payment requests records, the report could be very long. |
Purge |
Optional |
Enter Yes, for Payables to delete records that match the Source and Group ID of this import. Enter No, to keep all the records except the rejected records |
How Import Payment Requests is Processed
Submit the Import Payables Payment Requests process from the Manage Scheduled Processes page. Successfully imported payment requests are in the status validated, have distributions and installments, and can be queried in Manage Invoices page. The import process rejects payment requests records with insufficient or invalid data. The process produces a report so you can review the payment requests that weren't imported. Correct the payment request information and resubmit this template with the corrected data. Only data which was incorrect is required to be submitted again.