E1: 03B: Statistical History Refresh (R03B16A) Incorrectly Includes Paid Late Negative Amount Invoices and Paid Late Chargebacks, and Any Standalone Chargebacks in the Amount Paid Late (AIPL) Calculation
(Doc ID 2893954.1)
Last updated on FEBRUARY 28, 2023
Applies to:
JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When Statistical History Refresh (R03B16A) is run, it incorrectly includes standalone chargebacks and negative amount invoices and negative amount chargebacks in the calculation of the Paid Late Amount (AIPL) field.
Credit memos should not be included in the Paid Late Amount calculation, as per Chapter 32/Appendix C in the Accounts Receivable Implementation Guide for release 9.2, section ‘Mapping Fields in the A/R Statistical History Table (F03B16)’:
Field Name |
Alias |
Definition |
Paid Late Amount |
AIPL |
Sum of receipt pay item payment amounts where the G/L date of the receipt pay item is greater than the due date of the invoice it is paying. Invoice credit memos are not included in these calculations. |
Standalone chargebacks are not specifically mentioned but it does state that it is about invoices being paid. Standalone chargebacks are not invoices at the time when they are created, so they should not be included. See also the final dispositions of the following bugs:
- Bug 11021363: NO.OF INVOICES PAID LATE IS MO - SAR: 8940017
- Bug 10945609: NIPL AND AIPL WRONG CALC IN R0 - SAR: 8323630
See also the following in KM article E1: 03B: How To Calculate Statistical History Update Fields (P03B16, R03B16, R03B16A) (Doc ID 656325.1):
Paid Late Amount (AIPL)
A/R Statistical History table (F03B16) - This is the sum of the F03B14 Payment Amount (PAAP) field for records where:
- the F03B14 Payment Amount (PAAP) is less than zero
- the F03B14 G/L Date (DGJ) is greater than the F03B14 Invoice Due Date (DDJ) and the F03B14 Posted Code (POST) equals D
- the F03B14 Address Number (AN8) equals the F03B16 Address Number (AN8)
- the F03B14 Company (CO) equals the F03B16 Company (CO)
- the F03B14 G/L Date (DGJ) is greater than or equal to the begin date of the F03B16 Period Number (PN)
- the F03B14 G/L Date (DGJ) is less than or equal to the end date of the F03B16 Period Number (PN)
- A/R Statistical Summary table (F03B16S) - This is the sum of the F03B16 Paid Late Amount (AIPL) field for records where:
- the F03B16 Address Number (AN8) equals the F03B16S Address Number (AN8)
- the F03B16 Company (CO) equals the F03B16S Company (CO)
STEPS TO REPRODUCE
- P03B11: create invoices and credit memo as follows:
- 1st invoice (RI) for 1,000,00 with date in March.
- 2nd invoice (RI) for 500.00 with date in April.
- 3rd invoice (RI) for 500.00 with date in June.
- 4th invoice (RI) for 250.00 with date in May.
- 5th invoice (RI) for 100.00 with date in June.
- 6th invoice (RI) for 300.00 with a date in June.
- create a credit memo (doc type RM) for -250 with a date in March.
- create a negative invoice (doc type RI) for -125.00 with a date in February.
- R09801: post the invoices and credit memo.
- P03B102: create a receipt in March for the March invoice for 1200, create negative 200 chargeback for the overpayment.
- R09801: post the receipt.
- P03B102:
- create a receipt in June for 400 and match it to the two June invoices (3 and 5). Create a standalone positive 200 chargeback for the difference.
- create another receipt in June for 300 and match it to the April invoice to it as well as the neg. 200.00 chargeback.
- create a zero-amount receipt with a date in June and match the May invoice to the credit memo.
- Create a receipt in June for 175.00 and match the negative RI from February and the 3rd June invoice (no. 6) to the receipt.
- R09801: post the receipts.
- P03B08: make sure that C&C patterns are set up for at least company 00000
- BV: set up a version of R03B16A with following PO settings:
- DSO tab:
- 1
- 3
- Calculations tab:
- 1
- 1
- Summary Record tab:
- 0/blank
- 0/blank
- DSO tab:
- Run the new R03B16A version
- Databrowser: get the records for the customer from the following tables:
- F03012
- F03B11
- F03B13
- F03B14
- F03B08
- F03B16
- F03B16S
- Note that the F03B16 value for June for AIPL is 225.00- which means it includes the negative RI from February, the negative RB from March, and the standalone RB created in June.
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 |