WS: 04: How to Create an AP Detail Report with Corresponding GL Account Information
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