WS: 04: How to Create an AP Detail Report with Corresponding GL Account Information (Doc ID 848260.1)

Last updated on APRIL 27, 2016

Applies to:

JD Edwards World Accounts Payable - Version A7.3 cume 4 and later
Information in this document applies to any platform.

Goal

If the Supplier Totals by G/L Account (P09450) does not provide all of the information that you want, such as transaction originator, gross or open amount, discount, and so forth, you can create a custom report using World Writer report.

If, however, the voucher has multiple pay items, when the system retrieves the corresponding G/L information for the voucher, it does so for each voucher pay item, which creates duplicate lines on the report; each F0911 record prints for each voucher pay item. 

Therefore, before the report can be generated using World Writer you must create a summarized F0411 record to use, which you can do by creating a Query. The summarized voucher information is written to a user defined file in a specified library, which can then be used in a World Writer report to extract the corresponding G/L detail from the Account Ledger table (F0911).

This solution assumes that the user has experience running Query and World Writer.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms