R12 – How Due date is Calculated in Payable Invoices
-> 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 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.
Leave a ReplyWant to join the discussion?
Feel free to contribute!