AP And PO Accrual Reconciliation Report Aging Days Calculation For Two Rows Uses 'Latest Receipt Date' Instead of 'Actual Receipt Date' (Doc ID 1465129.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

Accounts Payable (AP) Purchasing (PO) Accrual Reconciliation Report AGING_DAYS_CALCULATION is using the "latest receipt date",  The customer requirement is to calculate the aging in days based on the "Actual Receipt date".

For example:

Create a PO having Line 1 -> Distribution 1 - 10 quantity

Receipt 1 = 5 quantity ( 01-May-2012)

Receipt 2 = 5 quantity ( 07-May-2012)

The Report will consider the latest receipt date (07-May-2012) and calculate based on that.

If the report is executed on 07-June-2012 and no invoice is created:

The report shows two lines with Aging in days will show 30.

                                                             Aging in Days

PO Number -> Distributions -> Receipt 1     30

PO Number -> Distributions -> Receipt 2     30

The customer wants the Aging to calculate based on the Actual Receipt date.

For example Receipt 1 calcuation based on (01-May-2012) and Receipt 2 based on (07-May-2012).

Expected report should show two lines with Aging in days will show 30.

                                                             Aging in Days

PO Number -> Distributions -> Receipt 1     36

PO Number -> Distributions -> Receipt 2     30

From the Oracle® PurchasingUser's Guide
Release 12
Part No. B28669-01
December 2006
Section: Accrual Write Off
Page 9-113
=======================
"You can also see the age of the distribution on this report. Age of the distribution is
calculated based on the value of a system profile "CST: Age in Days". If this profile is set
to "Last Receipt Date", then age is calculated based on the date of the latest receipt
transaction corresponding to this distribution. If the profile is set to "Last Activity Date"
then age is calculated based on date of the latest invoice or receipt transaction
corresponding to this distribution."
 

Solution

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