15 Processing Interoperability for Accounts Payable

This chapter contains the following topics:

15.1 Understanding Interoperability for Accounts Payable

Accounts Payable provides interoperability functions to facilitate the exchange of data with systems that are external to JD Edwards EnterpriseOne Accounts Payable.

15.1.1 Outbound Transactions

In JD Edwards EnterpriseOne Accounts Payable, these programs use the Voucher Entry MBF Processing Options program (P0400047), which enables you to specify a version of the F0411 Interoperability Processing Options program (P0400048), to write outbound transactions:

  • A/P Standard Voucher Entry (P0411).

  • A/P Speed Voucher Entry (P0411SV).

  • Prepayment Vouchers (P0411).

  • Logged Vouchers (P0411).

  • Multi Company - Single Supplier (P041016).

  • Multi-Voucher Entry (P041017).

  • Store and Forward Batch Voucher Processor (R04110Z2).

  • Voucher Batch Processor (R04110Z).

These Accounts Payable programs do not use the Voucher Entry MBF Processing Options program, so you cannot designate a version of the Interoperability Processing Options program. These programs always use version ZJDE0001 of the F0411 Interoperability Processing Options program to write outbound voucher transactions:

  • Speed Status Change (P0411S).

  • A/P Voucher Journal Entry Redistribution (P042002).

  • Recycle Recurring Vouchers (R048101).

  • Batch Update for Multitiered A/P (R005141).

  • General Ledger Post Report (R09801).

The system copies and stores outbound voucher transactions in the F0411 Interoperability Table (F0411Z3). The system copies and stores corresponding journal entries for outbound voucher transactions in the F0911 Interoperability Table (F0911Z4).

These payment programs also create outbound interoperability transactions:

  • A/P Manual Payments (P0413M).

  • A/P Void Payment (P0413V).

  • A/P Auto Payments - Update Driver (R04575).

  • Version ZJDE0003 Automated Payments Post (R09801).

  • Version ZJDE0004 Manual Payment with Match Post (R09801).

  • Version ZJDE0005 Manual Payment without Match Post (R09801).

These programs always use version ZJDE0001 of the F0413Z1 Retrieve Interoperability Processing Options program (P0400297) to create outbound payment transactions.

The system copies and stores outbound payment transactions in the F0413 Interoperability Table (F0413Z1) and the F0414 Interoperability Table (F0414Z1). The system copies and stores corresponding journal entries for outbound payment transactions in the F0911Z4 table.

Note:

Payment programs that update voucher records also update the F0411Z3 table if the processing option is set appropriately.

15.1.2 Outbound Interoperability

This diagram illustrates the outbound interoperability process for a voucher transaction:

Figure 15-1 Accounts Payable Outbound Interoperability process

Description of Figure 15-1 follows
Description of "Figure 15-1 Accounts Payable Outbound Interoperability process"

In this diagram, transactions are created in the Standard Voucher Entry program (P0411) and sent through the outbound interoperability process to a third-party software package.

Note:

An outbound payment transaction complies to this same interoperability process except that payment transactions do not use a master business function. Outbound payments use Interoperability Business Function B0400297 and interoperability tables F0413Z1 and F0414Z1.

15.2 Setting Up Outbound Interoperability for Accounts Payable

This section provides an overview of outbound interoperability setup for Accounts Payable, lists prerequisites, and discusses how to:

  • Set processing options for F0411 Interoperability Processing Options (P0400048).

  • Set processing options for F0413Z1 Retrieve Interoperability Processing Options (P0400297).

15.2.1 Understanding Outbound Interoperability Setup for Accounts Payable

To enable outbound processing for vouchers and payments, you specify the transaction type in the corresponding processing options. For vouchers, use the F0411 Interoperability Processing Options program (P0400048). For payments, use the F0413Z1 Retrieve Interoperability Processing Options program (P0400297).

To send corresponding accounts payable journal entry transactions, set the processing option in the F0911 Interoperability Processing Options program (P0900160). You are not required to specify the same transaction type for journal entries that you specify for vouchers or payments, but the transaction type processing option must be completed for journal entries to be processed to the F0911Z4 table.

When you send outbound accounts payable voucher or payment transactions, you should also include the matching accounts payable journal entry transactions.

If you create additional versions of the F0411 Interoperability Processing Options program for additional transaction types (for either vouchers or journal entries), you must specify the version that you create in the corresponding Voucher Entry MBF Processing Options (P0400047) or Journal Entry MBF Processing Options (P0900049) programs.

If you create additional versions of the Voucher or Journal Entry MBF Processing Options program, you must specify the version that you create in the processing option of the voucher entry program that uses the master business function processing options.

The system places a copy of each of these transaction in the interface table that corresponds to the type of transaction that you specify in the processing option:

  • Voucher transactions are placed in the F0411Z3 table.

  • Payment transactions are placed in the F0413Z1 and F0414Z1 tables.

  • Corresponding journal entry transactions are placed in the F0911Z4 table.

15.2.2 Prerequisites

Before you complete the tasks in this section:

  • Set up the automatic accounting instruction (AAI) items GLOBxx to define ranges of accounts.

    See Understanding Interoperability for General Accounting.

  • Define the data export controls for the type of outbound transaction.

    The system uses data export controls to identify the batch programs or business processes that third parties provide for use in processing transactions.

    See Setting Up Data Export Controls.

  • Define the flat file cross-reference if you need to write the data to a flat file because the interface table does not conform to the format that is required by the external system.

    See Setting Up the Flat File Cross-Reference.

15.2.3 Setting Processing Options for F0411 Interoperability Processing Options (P0400048)

Processing options enable you to specify the default processing for programs and reports.

15.2.3.1 Interop

Transaction Type

Specify the transaction type for the interoperability transaction. If you leave this processing option blank, the outbound interoperability is not performed.

Note:

The system provides transaction type JDEVOUCH for vouchers.
Before Image

Specify whether the system creates a record of the voucher before it was changed, in addition to a record of the voucher after the change. The system creates these records in the F0411 Interoperability Table (F0411Z3) when outbound interoperability processing is enabled. Values are:

Blank: Write the voucher record only after it has been changed; do not write a before image record.

1: Write two voucher records: one before the voucher was changed and one after the voucher was changed.

15.2.4 Setting Processing Options for F0413Z1 Retrieve Interoperability Processing Options (P0400297)

Processing options enable you to specify the default processing for programs and reports.

15.2.4.1 Interop

Transaction Type

Specify the transaction type for the interoperability transaction. If you leave this processing option blank, the outbound interoperability is not performed.

Note:

The system provides transaction type JDEPYMNT for payments.
Before Image

Specify whether the system creates a record of the payment before it was changed in addition to a record of the payment after the change. The system creates these records in the F0413 and F0414 Interoperability Tables (F0413Z1 and F0414Z1) when outbound interoperability processing is enabled. Values are:

Blank: Write the payment record only after it has been changed; do not write a before image record.

1: Write two payment records: one before the payment was changed and one after the payment was changed.

15.3 Reviewing Interoperability Transactions for Accounts Payable

This section provides an overview of reviewing interoperability transactions for JD Edwards EnterpriseOne Accounts Payable and lists the form used to review interoperability transactions for Accounts Payable.

15.3.1 Understanding Reviewing Interoperability Transactions for Accounts Payable

You can use on the Outbound Payments Revision program (P0413Z1) to review outbound payment transactions.

15.3.2 Form Used to Review Outbound Interoperability Transactions for Accounts Payable

Form Name FormID Navigation Usage
Payment Interoperability Revisions W0413Z1B Financials Interoperability Processing (G00313), Outbound Payments Revision

Select a record on the Work with Payment Interoperability form and click Select.

Review outbound interoperability transactions for Accounts Payable.

15.4 Purging Interoperability Transactions for Accounts Payable

This section provides an overview of purging interoperability transactions and discusses how to purge interoperability transactions.

15.4.1 Understanding Purging Interoperability Transactions

When data becomes obsolete or when you need more disk space, you can use the Purge Interoperability Table programs to remove data from the interoperability tables.

For records in the Processing Log table (F0046) that are marked as processed, the program purges the associated transactions in the F0411Z3, F0413Z1, and F0414Z1 interoperability tables, as well as the records in the F0046 table. If the records in the F0046 table are not marked as processed, the program does not purge any records.

See JD Edwards EnterpriseOne Tools Interoperability Guide

15.4.2 Purging Interoperability Transactions

To purge interoperability transactions for vouchers, select Financials Interoperability Processing (G00313), Purge F0411 Interoperability Table.

To purge interoperability transactions for payments, select Financials Interoperability Processing (G00313), Purge F0413/F0414 Interoperability Table.