15 Processing Interoperability for Accounts Payable
This chapter contains the following topics:
-
Section 15.1, "Understanding Interoperability for Accounts Payable"
-
Section 15.2, "Setting Up Outbound Interoperability for Accounts Payable"
-
Section 15.3, "Reviewing Interoperability Transactions for Accounts Payable"
-
Section 15.4, "Purging Interoperability Transactions for Accounts Payable"
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 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.
-
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.
-
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.
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
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.
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.