Integrating with Accounts Payables Applications

This topic discusses how to export approved PeopleSoft Services Procurement transactions to PeopleSoft Payables or to a third-party accounts payable application to create invoices.

Here are the steps to export services transactions:

  1. If you are using PeopleSoft Payables, use the Voucher Batch Req page to run the Voucher Build Application Engine process to generate the voucher.

  2. If you are not using PeopleSoft Payables, use the Export To Payables Application Engine process to export invoice data to a flat file.

Note: You specify the accounts payable application interface using the Accounts Payable Interface page.

If the currency on the invoice is different from the currency defined for the supplier, the system uses the rate type on the Services Procurement Business Unit Options page to convert the invoice amount into the supplier's currency.

Page Name

Definition Name

Usage

Export To Payables Page

SPA_GEN_INV_EXPORT

Export invoicing data to a PeopleSoft Payables staging table or to a flat file.

Use the Export To Payables page (SPA_GEN_INV_EXPORT) to export invoicing data to a PeopleSoft Payables staging table or to a flat file.

Navigation:

Services Procurement > Services Settlement > Export to Payables

This example illustrates the fields and controls on the Export To Payables page.

Export To Payables page

Enter the run control parameters for exporting invoicing data.

Process Results

The Export To Payables process writes to PeopleSoft Payables staging tables or a flat file based on the PeopleSoft Accounts Payable interface defined for the SetID.

If you selected PeopleSoft AP as the accounts payable application interface using the Accounts Payable Interface page, the PeopleSoft Application Engine (SPF_IEXPMAIN) exports invoicing data approved in PeopleSoft Services Procurement to staging tables (VCHR_HDR_STG, VCHR_LINE_STG, and VCHR_DIST_STG) in PeopleSoft Payables.

Note: For individual service work orders associated to a multi-resource parent, the systems sends the parent work order ID and sequence number to Accounts Payable to aid in matching to the related purchase order.

Note: After running the Export to Payables process, use the Voucher Build process in PeopleSoft Payables to generate vouchers for the approved invoices posted to PeopleSoft Payables.

If you selected Other as the accounts payable application interface using the Accounts Payable Interface page, the process exports invoicing data approved in PeopleSoft Services Procurement to a fixed format, comma-separated values (CSV) flat file, which you can use to import data into an accounts payable application and generate invoices.