My Oracle Support Banner

E1: FIN: Overview and Frequently Asked Questions Customer/Supplier Balance Report (R7404003, R7403B001, R7404002) (Doc ID 1484327.1)

Last updated on JANUARY 17, 2023

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
JD Edwards EnterpriseOne Accounts Payable - Version XE and later
Information in this document applies to any platform.


 This document details the set up and use of the Customer/Supplier Balance report in JD Edwards EnterpriseOne Accounts Receivable and Accounts Payable.


 This document is intended for users who are setting up and using the Customer/Supplier Balance report.


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Overview of the Customer/Supplier Balance Report
 Generate Supplier Balance (R7404003) and Generate Customer Balance (R7403B001)
 Setting Processing Options for Generate Supplier Balance (R7404003)
 Setting Processing Options for Generate Customer Balance (R7403B001)
 Understanding Customer and Supplier Balance Reports (R7404002)
 Setting Processing Options for Customer/Supplier Balance Report (R7404002)
 How to compare the A/R trade account to G/L
 Frequently Asked Questions
 Question 1: Is it possible to capture a customer's historical data (all open and closed invoices and related receipts) for a given period?
 Question 2: How can the invoice records in the F74412 table be linked with corresponding F03B11 records?
 Question 3:Why are AP Prepayment Vouchers not printing on the Supplier Balance Report (R7404002)?
 Question 4: When running the Customer/Supplier Balance Report (R7404002) should the initial balance from this year be equal to the total amount from the previous year?
 Question 5: How can a receipt that was matched to an incorrect customer and subsequently voided be eliminated from the customer balance report (R7404002)?
 Question 6: How to exclude A/P Drafts from Supplier Balance Report (R7404002)?
 Question 7: Is there a project for the redesign of the R7403B001 A/R Generate Customer Balance A/R and/or R7404003 A/P Generate Supplier Balance?
 Support Resource

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.