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.


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.


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