My Oracle Support Banner

E1: 03B: F03012 Invoiced This Year Column Is Incorrect When Run A/R Statistical History (R03B16A) (Doc ID 3063019.1)

Last updated on DECEMBER 10, 2024

Applies to:

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

Symptoms

When refreshing the Statistical Data for FY24 and running the R03B163/R03B16A, the F03012 have Invoiced This Year column updated only for the customers that have no activity on F03B13/F03B14 for the year refreshed.
As soon as there are any cash receipts the customer gets ignored. It seems it only updated the customers with open amounts in FY24 when it should have updated all customers with invoiced in 2024.

Steps:


1. Activate Line of Business in AR Constants. Check the P03B08 Credit / Collection Date Pattern to have the current FY for the involved companies.
2. Create two customers.
3. Enter one invoice for customer 1 using Customer Ledger Inquiry (P03B2002). Save it
4. Post it Using GL Posting (R09801).
5. Enter an invoice for customer 2 using Customer Ledger Inquiry (P03B2002).
6. Post it Using GL Posting (R09801).
7. Enter a receipt in P03B108 for the first invoice (customer 1). Post the receipt batch in P0011
8. Run R03B163
9. Run A/R Statistical History Refresh(R03B16A).
10. See that F03012 shows no value in Invoiced This Year column for the first customer (having a cash receipt), but for the second customer (without receipt) the Invoiced This Year column is populated.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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