Understanding the Interface with Payables

This topic discusses:

  • Processing overview.

  • Voucher records.

  • Integration points.

Payroll for North America enables you to send taxes, benefits, garnishments, and voluntary deductions withheld from employee paychecks directly to Payables for payment. Payables issues payments in the form of checks or electronic funds transfers, as required by the third-party, and makes the appropriate general ledger entries.

This diagram illustrates the Payables interface processing for sending deductions to PeopleSoft Payables:

Image: Illustration showing the process for selecting and sending deductions to PeopleSoft Payables

This diagram illustrates the Payables interface processing for sending deductions to PeopleSoft Payables.

Illustration showing the process for selecting and sending deductions to PeopleSoft Payables

Note: The pay run must be confirmed before extracting deductions. In addition, the Non-Commitment Accounting GL Interface process (PAYGL01 or PAYGL01A), the Commitment Accounting Actuals GL interface process (PAYGL02 or PAYGL02A), or the Distribute Payroll Data for AP process (PAYGL01 or PAYGL01A) must be processed successfully before extracting deductions.

To extract and send deduction vouchers to Payables:

  1. Run one or more extract processes to move selected deductions into temporary tables for viewing.

    You can extract nontax deductions; U.S. federal, state, or local taxes; or Canadian taxes.

    The system updates the AP Status field on the Review Paycheck component (PAY_CHECK) with an X to indicate that the deduction has been extracted for payment through Payables.

  2. Review and validate proposed payments.

    • The Review AP Extract-Headers - Review AP Extract-Lines page displays summary data by vendor.

    • The Review AP Extract-Lines - Review AP Extract-Lines page displays details of deductions.

    • The AP Extract Audit report (PAYXTRCT) lists details of extracted nontax deductions.

  3. Send vouchers to Payables.

    Run the Send Vouchers to AP process (PYAP_VCHPOST), which creates and sends the vouchers to Payables.

    The system updates the AP Status field on the Review Paycheck component (PAY_CHECK) with an S to indicate that the deduction has been sent and clears deductions from the temporary tables.

  4. Review the PeopleSoft Integration Broker Service Operations Monitor to confirm that the voucher records were successfully sent.

The vouchers that are sent to Payables contain three records: VOUCHER, VOUCHER_LINE, and DISTRIB_LINE. Fields of interest in each of these records are listed in the following table. The table lists only a subset of the fields in each record:

VOUCHER

VOUCHER_LINE

DISTRIB_LINE

BUSINESS_UNIT

BUSINESS_UNIT

BUSINESS_UNIT

VOUCHER_ID

VOUCHER_ID

VOUCHER_ID

INVOICE_ID

VOUCHER_LINE_NUM

VOUCHER_LINE_NUM

INVOICE_DT

TOTAL_DISTRIBS

DISTRIB_LINE_NUM

VENDOR_SETID

MERCHANDISE_AMT

BUSINESS_UNIT_GL

VENDOR_ID

 

ACCOUNT

VNDR_LOC

 

MERCHANDISE_AMT

ADDRESS_SEQ_NUM

 

 

ORIGIN

 

 

VCHR_TTL_LINES

 

 

GROSS_AMT

 

 

DUE_DT

 

 

REMIT_ADDR_SEQ_NUM

 

 

EIN_FEDERAL

 

 

EIN_STATE_LOCAL

 

 

Before using the integration between Payroll for North America and Enterprise Payables, configure the Integration Broker local node and activate the queues, handlers, and routings for these service operations:

Service Operation

Description

VENDOR_FULLSYNC

Payables publishes complete data from the VENDOR and related tables and Payroll for North America subscribes.

VENDOR_SYNC

Payables publishes incremental update data from the VENDOR and related tables and Payroll for North America subscribes.

VOUCHER_BUILD

Payroll for North America publishes data to the VOUCHER, VOUCHER_LINE, and DISTRIB_LINE tables and Payables subscribes.

Note: To research the technical details of any integration point used by PeopleSoft applications, refer to the Interactive Services Repository on My Oracle Support.

See:

  • PeopleTools: Integration Broker

  • PeopleSoft Enterprise Components