E1: 03B: How To Use Open A/R Detail and As Of Reports In EnterpriseOne Accounts Receivable (R03B413A, R03B4201A, R03B4201B)
(Doc ID 1484040.1)
Last updated on MAY 27, 2024
Applies to:
JD Edwards EnterpriseOne Accounts Receivable - Version XE and later Information in this document applies to any platform.
Purpose
Overview of Open A/R Detail Reports
The JD Edwards EnterpriseOne Accounts Receivable module provides three standard Open A/R Detail reports, which can be used to provide information on customer accounts. Aging information can be provided on the Open A/R Detail - Summarized Report (R03B413A) and A/R Open Detail with Aging (R03B4201B) to categorize the open amounts on the customer accounts.
Additionally, ‘as of’ processing can be used with the A/R Open Detail With Remarks (R03B4201A) and A/R Open Detail with Aging (R03B4201B) reports to provide a snapshot of open invoices "as of" a specific day. This is useful if a customer requests a report for a specific date or for a date other than the date that the report was originally processed.
The Open A/R Detail – Summarized Report (R03B413A) does not use ‘as of’ processing. However, a workaround is provided below to create a summary ‘as of’ report using the A/R Open Detail With Remarks (R03B4201A) or A/R Open Detail with Aging (R03B4201B).
Report
Report Name
Use
As Of Functionality
R03B413A
Open A/R Detail - Summarized Report
Prints current summary information about customer accounts.
Cannot be used for 'as of' reporting – see workaround section below.
R03B4201A
Open A/R Detail with Remarks Report
Prints a list of open items such as invoices, credit memos, and unapplied receipts for every customer.
Can be used for ‘as of’ reporting
R03B4201B
Open A/R Detail with Aging Report
Prints open A/R items for specific aging categories. This report lists totals for each company and a grand total for all companies.
Can be used for ‘as of’ reporting
There are a further 3 sets of reports, used mainly for foreign currency reporting purposes:
Open A/R Foreign Amounts - A/R Currency Detail Reports (R03B429A/R03B429R03B429C)
Open A/R Detail - Summarized w/Currency (R03B413B
Open A/R - Summary Analysis (R03B155).
Further information on these reports can be found in <Document 657603.1> and in the Accounts Receivable Implementation Guide, available here.
Scope
This document is intended for users setting up and using Open A/R Detail reports in EnterpriseOne Accounts Receivable.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
