When the Automatic Receipt master program is planned to execute on “28-FEB-20” and when there are a couple of invoices that were created with Due date as “24-FEB-20” and “29-FEB-20” below would be the calculation for deriving the Settlement Due Date / Receipt Maturity Date.
Invoice Number | Invoice Due Date | Automatic Receipt Batch Date | Settlement Due Date / Receipt Maturity Date |
INV1 | 29-Feb-20 | 28-Feb-20 | 29-Feb-20 |
INV2 | 24-Feb-20 | 28-Feb-20 | 28-Feb-20 |
Automatic Receipt master Program would compare the given batch date with Invoice due date and Consider whichever is having a greater value as Receipt Maturity date and the Same would be reflected as Settlement due date / Required collection date in CSB payment file.
To avoid such issues regarding Settlement Due Date / Receipt Maturity Date “Automatic Receipt master Program” should be run on the maximum date of invoice due date in the above case on or after “29th Feb” so that all the receipts would have the same maturity date or we need to define the Lead days according to over business need which would be defined when a Receipt class creation.
Automatic Receipts take the invoice’s due date and apply to it the Lead Days setting to evaluate what transactions are eligible for processing.
The Automatic Receipt Batch Date is used as the Receipt’s creation date. This date can never be later/greater than the Receipt’s maturity date.
If the Number of Receipt Rules is One per Invoice, then the logic simply compares the batch date versus the transaction’s due date and uses whichever value is later/greater.
If the Number of Receipt Rules is not One per Invoice, then the logic does a group evaluation of the invoices eligible and picks the Earliest or Latest (depending on the setting of Receipt Maturity date), then it compares this value to the batch date and uses whichever value is later/greater.