20 Accounts Payable Voucher

This chapter includes these topics:

20.1 Accounts Payable Voucher Overview

This chapter provides detailed information about the business interfaces that are available for the Accounts Payable Voucher business object.

This table lists all of the available interface components:

Interface Type Available Interfaces
Business Services The AccountsPayableManager published business service (JP040000) manages these web service operations:
  • J0400001 (processVoucher)

  • J0400002 (getVoucher)

Batch Import Programs This list includes the batch import programs for the Accounts Payable Voucher business object:
  • Batch Voucher Processor Report (R04110ZA)

  • Store and Forward Voucher Batch Processor Report (R04110Z2)

  • Edit/Create Voucher (R47041)

  • Voucher Batch Processor program (R04110Z)

  • Inbound AP Claim program (R04110ZB)

  • Store and Forward Upload (R0411Z1)

Additional Interfaces The Accounts Payable Voucher business object also uses the following business interfaces:
  • F0411 Interoperability Processing Options program (P0400048)

    Use this program to enable outbound processing of payments. This is an interoperability progam.

See Understanding Outbound Interoperability Setup for Accounts Payable.



Note:

You can find additional technical information about each type of business interface component. For additional descriptions of the information available, and instructions for finding this information, see Chapter 5, "Accessing Additional Information for Business Interface Components."

20.2 Accounts Payable Voucher Business Services - AccountsPayableManager

This section describes the available business services associated with the AccountsPayableManager published business service (JP040000), which is part of the Accounts Payable Voucher business object. The business services include:

Operation Description
getVoucher Use this operation to retrieve and review accounts payable vouchers from the JD Edwards EnterpriseOne Accounts Payable system.
processVoucher Use this operation to add, delete or void accounts payable vouchers in the JD Edwards EnterpriseOne Accounts Payable system.

20.2.1 Accessing Javadoc for the AccountsPayableManager Web Service

To access Javadoc for the AccountsPayableManager web service and its related operations, review these Javadoc packages:

  • JP040000 (AccountsPayableManager)

  • J0400001 (processVoucher)

  • J0400002 (getVoucher)

20.2.2 Prerequisites

Before you can use any of the accounts payable web service operations, you must install and configure the JD Edwards EnterpriseOne Accounts Payable system.

See "Setting Up the Accounts Payable System" in the JD Edwards EnterpriseOne Applications Accounts Payable Implementation Guide.

20.2.3 getVoucher

The getVoucher web service operation is a database query operation that enables consumers to retrieve accounts payable vouchers from the JD Edwards EnterpriseOne Accounts Payable system.

The operation retrieves records based on the selection criteria that is passed in. If no selection criteria is passed in, the operation attempts to retrieve all records from the EnterpriseOne database, using the business service property to limit the number of records returned. If the operation encounters errors, processing stops and the errors are returned to the consumer.

20.2.3.1 Setup Considerations

Before you use this operation, you can set business service properties to specify how the system retrieves data. This table includes information about the business service properties that the getVoucher operation uses:

Group Key Description Default Value
J0400002 J0400002_MAX_ROWS Use this business service property to specify the maximum number of records the operation returns for the query. 0: Return All Records


Note:

It is recommended that this business service property is configured and used. Also, it is strongly recommended that the consumer pass in selection criteria when performing a query. If these two recommendations are not followed, the operation attempts to fetch all the records from the database, which can significantly impact performance.

Also be aware that this operation performs multiple data retrievals from the EnterpriseOne database. Initially, records are selected from the Accounts Payable Ledger table (F0411) based on the selection criteria that is passed in by the consumer. After the operation retrieves records from the F0411, processing continues, and additional records are retrieved from the Account Ledger table (F0911), based on the data in the F0411 records. This business service property limits the number of records initially retrieved from the F0411. Therefore, the total number of records that are returned to the consumer might be greater than the value that you enter in this property.


See JD Edwards EnterpriseOne Tools Business Services Development Methodology Guide.

20.2.3.2 Implementation Details

This table includes information that can help determine whether the getVoucher operation is functioning correctly:

Question Answer
How can I tell if the operation completes successfully? If the operation completes successfully, zero to many records are returned to the consumer based on the selection criteria.

The records that are returned to the consumer include all of the fields that are listed in the response interface for this operation. However, some of those fields can contain blank or zero values, depending on the data that exists in the JD Edwards EnterpriseOne system.

At a minimum, the system returns non-zero values for these fields:

  • documentNumber

  • documentTypeCode

  • documentCompany

If I encounter errors while processing a transaction, do I need to reverse the transaction? This is a database query operation that does not perform transactions. If you encounter errors during processing, review your search criteria and business service property settings and try your query again. If the operation does not return any records, verify that records matching your query exist in the JD Edwards EnterpriseOne database.
Does this operation use record reservation? No. The operation does not reserve records within the JD Edwards EnterpriseOne system during processing.

20.2.4 processVoucher

The processVoucher web service operation is an inbound transaction operation that enables consumers to add, delete or void vouchers in the JD Edwards EnterpriseOne Accounts Payable system.

If the operation completes successfully, the consumer receives a success message. If the operation encounters errors, processing stops and the errors are returned to the consumer.

20.2.4.1 Setup Considerations

Before you use this operation, you can set business service properties to specify how the system processes vouchers. This table includes information about the business service properties that the processVoucher operation uses:

Group Key Description Default Value
J0400001 J0400001_GL_VERSION Use this business service property to specify the version of the P0400074 that the operation uses to process voucher information. ZJDE0001
J0400001 J0400001_ GL_VCHR_MBF_VERSION Use this business service property to specify the version of the P0900049 that the operation uses to process voucher information. ZJDE0001


Note:

The published value object includes a field in the general ledger array that enables the user to enter a version of the P0900049 program for the F0911FSEditLine function. Though the user can enter a different version for each general ledger record, the operation uses only the first version. The operation first tries to retrieve the processing version from the value object. If no value is entered in the value object, the operation tries to retrieve a version from the business service properties. If no version is found, the operation uses version ZJDE0001.

The header class of the published value object also enables the user to specify a version of theP0400047 program, which is used for the F0411FSBeginDoc and F0411FSEditLine functions. Again, the operation first tries to retrieve the version from the value object. If no version is found, the operation then tries to retrieve a version from the business service properties. If no value is found, the operation uses version ZJDE0001.


See JD Edwards EnterpriseOne Tools Business Services Development Methodology Guide.

20.2.4.2 Implementation Details

This table includes information that can help determine whether the processVoucher operation is functioning correctly:

Question Answer
How can I tell if the operation completes successfully? If the operation completes successfully, a success message is returned to the consumer.

The records that are returned to the consumer include all of the fields that are listed in the response interface for this operation. However, some of those fields can contain blank or zero values, depending on the data that exists in the JD Edwards EnterpriseOne system.

At a minimum, the system returns non-zero values for these fields:

  • documentNumber

  • documentTypeCode

  • documentCompany

Additionally, if you are adding a voucher, the operation returns two arrays; one for the voucher records added and one for the general ledger records. In addition to the fields listed, the voucher array returns non-zero values for the DocumentPayItem field. It also returns a value for the DocumentPayItemExtension field, but that value can be 0.

The general ledger array returns a value in the DocumentLineNumber field.

If I encounter errors while process a transaction, do I need to reverse the transaction? This operation uses standard transaction processing. If the system encounters errors during processing, no data in the JD Edwards EnterpriseOne system is updated. No manual updates are required.
Does this operation use record reservation? No. The operation does not reserve records within the JD Edwards EnterpriseOne system during processing.

20.3 Accounts Payable Voucher Batch Import Programs

You use batch import programs to import data from an external software system into the JD Edwards EnterpriseOne system, where it can then be processed by EnterpriseOne programs.

This table lists and describes the available batch import programs that are associated with the Accounts Payable Voucher business object:

Program and Program Type Description Available Documentation
Batch Voucher Processor Report (R04110ZA)

This is a temporary table batch program.

After your custom program loads the transaction information into the Voucher Transaction - Batch Upload (F0411Z1) and Journal Entry Transactions - Batch File (F0911Z1) tables, run this program to process the information in the F0411Z1 and F0911Z1 tables and load it into the Accounts Payable Ledger (F0411) and Account Ledger (F0911) tables. See this topic:
Store and Forward Voucher Batch Processor Report (R04110Z2)

This is a temporary table batch program.

Use this program to move the uploaded vouchers from the Voucher Transactions - Batch Upload table (F0411Z1) and the Journal Entry Transactions - Batch File (F0911Z1) tables to the Accounts Payable Ledger (F0411) and the Account Ledger (F0911) tables. See this topic:
Edit/Create Voucher (R47041) Run the Edit/Create Voucher program to transfer inbound EDI vouchers to the Voucher Transactions - Batch Upload and the Journal Entry Transactions - Batch File tables (F0411Z1 and F0911Z1) without matching the voucher to a purchase order. See this topic:
Voucher Batch Processor program (R04110Z)

This is an EDI program.

Run the Voucher Batch Processor program (R04110Z) to process invoice information. You can run the Voucher Batch Processor program in either proof or final mode. In proof mode, the program edits the transaction and sends any errors to the Employee Work Center. In final mode, the program updates the records in the F0411Z1 table and F0911Z1 table as processed. This action prevents further processing. See this topic:
Inbound AP Claim program (R04110ZB) The Inbound AP Claim program (R04110ZB) also creates records in the Voucher Transactions - Batch Upload table (F0411Z1) and the Journal Entries Transactions - Batch table (F0911Z1). You run the Inbound AP Claim program if your JD Edwards EnterpriseOne system is integrated with the Oracle Demantra Predictive Trade Planning software. See this topic:
Store and Forward Upload (R0411Z1) When you enter vouchers, the system updates the values from the pay item, tax rate area, tax explanation code, and tax item number fields from the F0411 or F0411Z1 tables to the F0911 or F0911Z1 tables. See this topic: