My Oracle Support Banner

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 FEBRUARY 15, 2018

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:

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!


In this Document
Purpose
 Overview of Open A/R Detail Reports
Scope
Details
 Processing Options for Open A/R Detail – Summarized Report (R03B413A)
 R03B4201A - Open A/R Detail with Remarks Report
 Processing Options for A/R Invoice Detail (R03B4201A)
 R03B4201B - Open A/R Detail with Aging Report
 Processing Options for Open A/R Detail with Aging (R03B4201B)
 Preactivity Processing Option (from release 8.11 SP1)
 As Of Reporting Overview
 As Of Functionality
 Workaround to Produce Summary As Of Report
References

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