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 laterInformation 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 |