Skip to main content

AP R12 EBS PPR: R12:IBY:How to set "Number of Pay From Days" and "Additional Pay Through Days" on the Payment Process Request Template and how to effect on PPR (Doc ID 1535205.1)

 

To BottomTo Bottom

In this Document

Purpose
Scope
Details

APPLIES TO:

Oracle Payments - Version 12 and later
Information in this document applies to any platform.

PURPOSE

 

The purpose of this document is to explain how the two fields of "Number of Pay From Days" and "Additional Pay Through Days" work. These fields are setted when defining Payment Process Request Template and effect on "Pay From Date" and "Pay Though Date" fields when submitting Payment Process Request PPR. Its a simple five sections:

Section 1: Where is the two fields "Number of Pay From Days" and "Additional Pay Through Days"?

Section 2: Where is the two fields "Pay From Date" and "Pay Through Date"?

Section 3: Understanding meaning of the the two fields "Number of Pay From Days" and "Additional Pay Through Days"

Section 4: Example to understand the meaning of the the two fields "Number of Pay From Days" and "Additional Pay Through Days"

Section 5: How these fields effect on the Payment Process Request "PPR".

SCOPE

 

DETAILS

Section 1: Where is the two fields "Number of Pay From Days" and "Additional Pay Through Days"?

    1. Responsibility: Payables Manager
    2. Navigation: Payments > Entry > Payments Manager
    3. Navigate to Templates Tab
    4. Click Create Button
    5. Under the Schedule Payment Selection Criteria Tab, you can see the two fields "Number of Pay From Days" and "Additional Pay Through Days".

PPR Standard Template_2

Section 2: Where is the two fields "Pay From Date" and "Pay Through Date"?

    1. Responsibility: Payables Manager
    2. Navigation: Payments > Entry > Payments Manager
    3. Navigate to Payment Process Requests Tab
    4. Click Submit Single Request Button
    5. Under the Schedule Payment Selection Criteria Tab, you can see the two fields "Pay From Date" and "Pay Through Date".

PPR Standard2

Section 3: Understanding meaning of the the two fields "Number of Pay From Days" and "Additional Pay Through Days"

Number of Pay From Days:

This optional value determines the Pay From Date on a Payment Process Request that will created from Template. It represent the number of days added to today's pay run date. This Number added to the Pay Run Date to determine the Start Date for which schedule payments of invoices will be selected.

Additional Pay Through Days:

This mandatory value determines the Pay Through Date "To Date" on a Payment Process Request that will created from Template. It represent the number of days added to today's pay run date. This Number added to the Pay Run Date to determine the Pay Through Date "To Date" for which schedule payments of invoices will be selected.

 Meaning of two fields 2

After determining the Start Date and To Date "Pay Through Date", Scheduled Payment Selection Report will select any Schedule Payments of Invoices which has a Due Date between the Start Date and the Pay Through Date.

Note: The Schedule Payments will be selected are exist on the "Schedule Payments" tab on the Invoice Workbench and the Due Date will be compared is the Due Date of these Schedule Payments.

 

Section 4: Example to understand the meaning of the the two fields "Number of Pay From Days" and "Additional Pay Through Days" 

 Let us take an example to strongly understand the meaning of the two fields "Number of Pay From Days" and "Additional Pay Through Days"

    1. Create two AP Invoices in the Invoice Workbench.
    2. The first Invoice #700101. Invoice Amount = 100,000 USD and it have two Schedule Payments. First Schedule Payment Due Date = 11-MAR-2013 with amount 20,000 USD and the second Schedule Payment Due Date = 06-APR-2013 with amount 80,000 USD. 

       

      Schedule Payments of Inv 1

       

    3. The second invoice #700102. Invoice Amount = 100,000 USD and it have two Schedule Payments. First Schedule Payment Due Date = 13-MAR-2013 with amount 10,000 USD and the second Schedule Payment Due Date = 06-APR-2013 with amount 90,000 USD.

       

      Schedule Payments of Inv 2

       

    4. Create Payment Process Request Template have the Number of Pay From Days = 3 and Additional Pay Through Days = 8 

       

      PPR Template in Example

       

    5. Supposed the Run Date is 7-MAR-2013, the date when you submit the PPR.
    6. Pay From Date "Start Date" = Run Date + Number of Pay From Days = 7-MAR-2013 + 3 = 10-MAR-2013, so the Pay From Date will be 10-MAR-2013 when running the PPR.
    7. Pay Through Date "To Date" = Run Date + Additional Pay Through Days = 7-MAR-2013 + 8 = 15-MAR-2013, so the Pay Through Date will be 15-MAR-2013 when running the PPR.

       

      Meaning of two fields in example Final

       

    8. Scheduled Payment Selection Report will select any schedule payment has a Due Date between Start Date "10-MAR-2013" and Pay Through Date "15-MAR-2013"
    9. So we expect the Schedule Payment of amount 20,000 USD of Invoice #700101 and the Schedule Payment of amount 10,000 USD of Invoice #700102 only will be selected for any PPR that will be submitted depending on this PPR Template. Because the Due Date of these Schedule Payments between the Pay From Date and Pay Through Date.

Section 5: How these fields effect on the Payment Process Request "PPR".

    1. Responsibility: Payables Manager
    2. Navigation: Payments > Entry > Payments Manager
    3. Navigate to Payment Process Requests Tab
    4. Click Submit Single Request Button
    5. Enter Payment Process Request Name
    6. Choose your PPR Template in the Use Template field and Tab from the field
    7. Now you can see the "Pay From Date" and "Pay Through Date" fields are populated with expected values

       

      PPR populated with expected values

       

    8. Click Submit
    9. Payment Process Request Program will be submitted and you can view the progress from View > Request.
    10. Scheduled Payment Selection Report also will be submitted and you can view the progress from View > Request.
    11. Navigate to Payment Process Requests Tab.
    12. Query the PPR submitted in step 8 and Click Go Button.
    13. Click on the PPR Name link.
    14. Now you can see the result as we expect in Section 4 - Step 9.

       

      PPR After Selection of SPs

       

      We expect the Schedule Payment of amount 20,000 USD of Invoice #700101 with Due Date 11-MAR-2013 and the Schedule Payment of amount 10,000 USD of Invoice #700102 with Due Date 13-MAR-20134 only will be selected for the PPR that submitted depending on the created PPR Template. Because the Due Dates of these Schedule Payments between the Pay From Date and Pay Through Date of the Template.

Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more