12/26/13 Document 1136143.
R12: How is a Payables Invoice Due Date Calculated? (Doc ID 1136143.1)
Modified: 23-Feb-2011 Type: HOWTO
In this Document
Goal
Solution
References
APPLIES TO:
Oracle Payables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.
APXINWKB - Invoice Workbench
GOAL
How is the due date calculated on Payables Invoices?
Example:
Somehow the scheduled payment date does not calculate correctly given the invoice date and payment terms. For an
invoice date of 17-May-2010, the payment date should be 16-Jun-2010 with net 30 payment terms, but it shows a
payment date of 19-Jun-2010.
SOLUTION
Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique
issues in AP.
From the APLIST, the calculated Due Date is correct. The Invoice was created on
17-May-2010 and a Receipt was created on 20-May-2010. Later when invoice was
validated, the system recalculated the Payment Schedules as 'Recalculate Payment
Schedules' was enabled. The system generated the Due date as 19-Jun-2010 for Terms
-Net30.
Here is how the Due date calculation works:
---------------------------------------------------------------
-> Generally, Due date get calculated based on the most recent of the available start dates. Most recent available start
date is derived based on the following formula.
Greatest( Goods_Received_Date + Receipt_Acceptance_Days, Invoice_Date, Terms_Date ).
->In the algorithm above, Goods_Received_Date is a date that gets populated on the invoice based on
terms_date_basis at supplier/site level.
a. If terms_date_basis = 'Goods Received' then, Goods_Received_Date get populated.
b. If terms_date_basis = 'Invoice Received' or anything else then, Goods_Received_Date is null.
-> Receipt_Acceptance_Days is the number of days defined for 'Receipt Acceptance Days' under the Invoice tab in
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=7guscm5pd_156&id=1136143.1 1/2
12/26/13 Document 1136143.1
Payables Options.
->So, the due date basis is the most recent of INVOICE DATE, TERMS DATE, GOODS RECEIVED DATE+RECEIPT
ACCEPTANCE DAYS.
->In case of a matched invoice, the system considers the Receipt Transaction date from the
Receipt for the calculation of a recent start date, because sometimes the GOODS RECEIVED DATE is null. This
functionality exists from 11i beginning only. Check bug#1655225 for details.
a.So first system determines recent date of GOODS RECEIVED DATE+RECEIPT ACCEPTANCE DAYS and RECEIPT
TRANSACTION DATE.
b.After that again checks most recent date again from the formula defined.
-----------------------------------------------------------------------------
If the customer doesn't want the system to use 'Receipt dates' then disable 'Recalculate Payment Schedules'.
If the customer wants recalculation, then the system considers 'Receipt date' for a matched invoice.
REFERENCES
BUG:9664648 - 12.1.1 DUE DATES ON AP INVOICES ARE CALCULATED INCORRECTLY.
BUG:9741040 - R12.1.1 AP INVOICES NOT CALCULATING THE CORRECT DUE DATE
BUG:9836556 - 12.1.2 INCORRECT DUE DATE CALCULATED FROM TERMS
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=7guscm5pd_156&id=1136143.1 2/2
