This section provides an overview of prepayment processing, lists prerequisites, and discusses how to:
Enter prepaid vouchers online.
Apply final invoices to prepayments.
Generate final payments.
Review prepayments.
This section discusses:
Prepayment overview.
Prepayment application and payment.
Prepayment posting.
Prepaid and regular voucher cross-reference record.
Discounts and prepayment application.
Prepayment cancellation.
Prepaid and applied voucher closure.
Manual prepayment application example.
Accounting entry example 1: prepayment without value-added tax (VAT) or withholding.
Accounting entry example 2: prepayment with 100% VAT on regular voucher.
Accounting entry example 3: prepayment with 100% VAT on payment.
Accounting entry example 4: prepayment with 5% prorated, nonrecoverable VAT.
Accounting entry example 5: prepayment with withholding.
Recurring prepayment vouchers.
Down payments and prepayments are common practice worldwide. Most organizations, at one time or another, must pay for goods or services before an invoice is received. For example, when a company sets up a new customer account with a vendor, the vendor may require prepayment on the first one or two orders before extending credit to the buyer. The prepayment functionality in PeopleSoft Payables:
Allows a payment to be made to a vendor without an invoice.
Creates accounting entries for the prepayment.
Applies VAT and withholdings to the prepayment.
Facilitates the application of the final voucher to the prepayment.
Use prepayments to create payments for vendors before receiving an invoice:
Enter and pay a prepaid voucher immediately.
Enter it as a regular voucher when the invoice is received.
Apply or link the regular voucher and prepaid voucher prior to payment of the regular voucher.
The system deducts the payment made on the prepaid voucher from the regular voucher's scheduled payment and remits the balance to the vendor.
Post both the prepayment voucher and the prepayment to create the appropriate accounting entries once the prepayment has been made.
The voucher and payment posting processes reverse the prepayment entries and charge the final accounts when the regular voucher is posted.
The prepayment voucher has all the attributes of a regular voucher, including document sequencing, VAT, and withholding. The actual prepayment has all the attributes of a regular payment with the exception of discounts and split payments.
Prepayment application can be performed in batch processing (part of voucher posting) or manually using the Apply Vouchers to Prepayment page. You can apply multiple vouchers to one prepayment, as well as one voucher to multiple prepayments.
The order in which you process prepayment application is flexible. You can enter and post a regular voucher before you enter the prepaid voucher. When you run voucher posting, the two transactions are applied (assuming they meet the application criteria). Or, you can manually apply the regular voucher to the prepaid voucher immediately after the prepaid voucher has been paid.
Note. For automatic application, either the prepaid voucher or the regular voucher must be picked up by the Voucher Posting Application Engine process (AP_PSTVCHR) to be applied. If both vouchers are already posted, voucher posting does not process them, and no application occurs. In this scenario, you can manually apply the regular voucher to the prepaid voucher using the Apply Vouchers to Prepayment page. Voucher posting creates the apply accounting entries the next time it is run for that business unit.
See Also
Applying Final Invoices to Prepayments
Complete the following steps to apply and pay regular and prepaid vouchers:
Create the prepaid voucher.
Pay the prepaid voucher.
Note. Prepaid vouchers must be paid before a regular voucher can be applied to them. They do not need to be payment-posted.
The accounting entries that are created for prepaid voucher during voucher posting include
Prepaid expense account (122000): 1000.00 Debit.
Accounts payable account (200000): 1000.00 Credit.
Create a regular voucher.
Note. Regular vouchers must be approved before they can be applied to prepaid vouchers using either the batch or manual application processes.
(Optional) Manually apply the regular voucher to the prepaid voucher.
Run the Voucher Posting process for the regular voucher.
The Voucher Posting process calls the AP Prepayment Application Application Engine process (AP_PPAY_APPL), which applies regular vouchers to prepayments.
Run the Pay Cycle Application Engine process (AP_APY2015) to pay the regular voucher payment.
The Pay Cycle process pays the regular voucher payment schedule, which was reduced in prepayment application.
An advice routine selects invoice information from applied prepaid vouchers, so they appear on the payment advice. This advice lists regular vouchers that are applied to prepayments.
Note. If you run the Pay Cycle process before running the Voucher Posting process for the regular voucher, the regular voucher is paid in full, because the AP Prepayment Application process will not have been run. Use the manual application process to run the Pay Cycle process before the Voucher Posting process.
When you run the Voucher Posting process for the regular voucher:
The Voucher Posting process calls the AP Prepayment Application process, which processes the vouchers in the following order:
Auto-apply prepayments with matching references.
Auto-apply prepayments with the Auto-Apply check box selected.
The AP Prepayment Application process loops through the available prepaid vouchers by invoice date (oldest first).
For each prepaid voucher, the process loops through the regular vouchers that are being processed in the current run or were previously posted but are not fully paid or applied.
It searches for vouchers that match the invoicing vendor and transaction currency of the prepaid voucher and processes regular vouchers by scheduled payment date (oldest first).
Note. The AP Prepayment Application process does not update application links that have been made manually. For example, if you have partially applied a prepayment to a regular voucher, the system does not apply the rest of the prepayment when you run the AP Prepayment Application process.
When a match is found, rows are created in the PS_VCHR_PPAY_XREF table that link to prepaid and regular vouchers.
Note. Vouchers with payment schedules on hold are not applied.
The scheduled payment (PS_PYMNT_VCHR_XREF) on the regular voucher is reduced by the amount of the applied prepaid voucher.
To balance the payment amounts on PS_PYMNT_VCHR_XREF to the voucher gross amount, a row is inserted into PS_PYMNT_VCHR_XREF with PREPAID_STATUS of A (applied), and the amount is applied against the prepaid voucher.
If voucher posting encounters regular vouchers which are applied to prepaid vouchers, reversal accounting entries are created for the prepaid vouchers.
A posting status field (REV_POST_STATUS) on PS_VCHR_PPAY_XREF tracks whether the reversing accounting entries have been created.
Note. In the case where the regular voucher is smaller than the prepaid voucher, voucher posting prorates the prepayment reversals so that only the portion of the prepaid voucher, which is applied to the regular payment, is reversed.
Note. The prepaid voucher must be posted before the regular voucher for the Voucher Posting process to create the prepaid reversal entries.
The accounting entries created for the posted, applied regular vouchers during voucher posting are:
Description |
Account |
Debit |
Credit |
Expense |
631000 |
5000.00 |
|
Accounts Payable |
200000 |
|
5000.00 |
Prepaid Account |
122000 |
|
1000.00 |
Accounts Payable |
200000 |
1000.00 |
|
Unposting Prepaid and Applied Vouchers
When a regular voucher that is applied to a prepaid voucher is unposted, the prepayment application is reversed. The system updates PS_VCHR_PPAY_XREF to show that no vouchers are applied.
There are no additional restrictions on voucher unpost for prepayments.
The PS_VCHR_PPAY_XREF record stores the linkage between prepaid vouchers and regular vouchers which have been applied to one another. This is how information is processed:
A row is inserted into PS_VCHR_PPAY_XREF when a new prepaid voucher is entered.
This row is updated with the relevant linkage data when a regular voucher is applied to the prepaid voucher.
Additional rows are added to PS_VCHR_PPAY_XREF, if and when the prepaid voucher is applied to additional regular vouchers.
When application occurs, PS_PYMNT_VCHR_XREF (for the regular voucher) is also updated.
The existing scheduled payment is updated to reflect the reduced payment that is remitted to the vendor. For each prepaid voucher that is applied, a row is inserted with prepaid_status A (applied). This row keeps PS_PYMNT_VCHR_XREF in balance with the voucher gross; the row is not used to generate a payment.
When payments are created, the scheduled payment generates a payment that has already been reduced by the applied prepaid vouchers.
When a regular voucher is posted, unposted rows in PS_VCHR_PPAY_XREF generate a set of reversal accounting entries for the prepaid voucher.
When a scheduled payment is fully applied (there is nothing left to pay the vendor), the prepaid_status is set to F (fully applied), and the pymnt_selct_status is set to S (settled). No additional row is inserted into PS_PYMNT_VCHR_XREF.
Prepayment application evaluates regular vouchers that are fully applied by prepayments to determine whether they are eligible for a payment discount. If the regular voucher is fully applied by a prepayment and is eligible for a payment discount, the application is performed at the discounted amount. The appropriate discount accounting entries are created when the apply accounting entries are created in voucher posting.
You can perform payment cancellation on prepaid vouchers and unposted regular vouchers that are applied to prepaid vouchers.
During payment cancellation, the system processes PS_PYMNT_VCHR_XREF prepaid application rows, as well as the regular payment schedule rows.
The original payment schedule is identified as canceled (PYMNT_SELCT_STATUS = X) and a new payment schedule is inserted. The prepaid application rows (PREPAID_STATUS = A) are also canceled. New application rows are inserted into PS_PYMNT_VCHR_XREF, and are identical to the canceled rows except that the ORIG_PYMNT_CNT on the new applied rows is the PYMNT_CNT of the new payment schedule.
For prepayments, the payment can be canceled as long as it is not applied. PYMNT_VCHR_XREF is updated normally. If the option to reissue the payment is selected, PS_VCHR_PPAY_XREF is updated to point to the payment count of the newly scheduled payment rather than the canceled one.
If you cancel a payment for a regular voucher that has prepaid vouchers applied to it, and you decide to close the voucher, only the unapplied portion of the regular voucher is closed. When you save, a warning message advises you that if you want to close the entire voucher, you should not proceed.
Note. Applied prepayments cannot be canceled. The prepaid voucher must be unapplied before its associated payment can be canceled. Applied prepayments do not appear in the Payment Cancellation search view.
If you attempt to close a regular voucher that is applied to one or more prepaid vouchers, a warning message advises you of the following: Prepaid vouchers (or portions of prepaid vouchers) that have been applied to regular voucher payment schedules cannot be closed.
Unpaid regular payment schedules that are applied to prepaid vouchers can be closed, but only the unpaid and unapplied portion of the payment schedule (the amount remaining to be paid) is closed.
If a regular voucher is applied to one or more prepaid vouchers and you want to close out the entire regular voucher, you must unapply it first.
Example: Closing Prepaid and Regular Vouchers
This example assumes the following:
A prepaid voucher for 1000.00 USD is posted and paid.
A regular voucher for 5000.00 USD is created.
The prepaid and regular vouchers are applied to each other (manually or using batch).
The regular voucher's payment schedule is reduced to 4000.00 USD.
In this example, you can close the regular voucher, but only 4000.00 USD is closed. However, if you unapply the vouchers and then close the regular voucher, the entire 5000.00 USD is closed.
Note. Prepaid vouchers that are applied to regular vouchers must also be unapplied prior to closure. Applied prepaid vouchers do not appear in the Voucher Closure search view.
Let's say you have scheduled payments for two regular vouchers (REG-A and REG-B) and you want to apply some of each of them to the scheduled payment for a prepaid voucher (PP-1).
Voucher ID |
Scheduled Payment Amount |
PP-1 |
2000.00 USD |
REG-A |
1000.00 USD |
REG-B |
3000.00 USD |
If you apply 300.00 USD of REG-A to PP-1, the remaining balance of PP-1 is 1700.00 USD. You could then apply 1700.00 USD of REG-B to PP-1, and PP-1 is fully applied. The resulting final payments would be 700.00 USD for voucher REG-A and 1300.00 USD for voucher REG-B.
This scenario assumes:
Prepayment: 1000.00 USD.
Regular voucher: 5000.00 USD.
Prepaid Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Prepaid Expense |
122000 |
1000.00 USD |
N/A |
Accounts Payable |
200000 |
N/A |
1000.00 USD |
Payment (payment posting):
Description |
Account |
Debit |
Credit |
Accounts Payable |
200000 |
1000.00 USD |
N/A |
Cash |
100001 |
N/A |
1000.00 USD |
Applied Regular Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Expense |
631000 |
5000.00 USD |
N/A |
Accounts Payable |
200000 |
N/A |
5000.00 USD |
Prepaid Expense |
122000 |
|
1000.00 USD |
Accounts Payable |
200000 |
1000.00 USD |
N/A |
Payment (payment posting):
Description |
Account |
Debit |
Credit |
Accounts Payable |
200000 |
4000.00 USD |
N/A |
Cash |
100001 |
N/A |
4000.00 USD |
This scenario assumes:
Prepayment for 1196.00 EUR.
Applied regular voucher for 3588.00 EUR.
VAT declaration point is invoice.
Note. The Voucher Posting process creates similar accounting entries when the VAT declaration point is invoice, delivery, or accounting date.
Prepaid Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Prepaid Expense |
122000 |
1000.00 EUR |
N/A |
VAT Input Recoverable |
206103 |
196.00 EUR |
N/A |
Accounts Payable |
200000 |
N/A |
1196.00 EUR |
Payment (payment posting):
Description |
Account |
Debit |
Credit |
Accounts Payable |
200000 |
1196.00 EUR |
N/A |
Cash Distribution |
100001 |
N/A |
1196.00 EUR |
Applied Regular Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Expense Account |
631000 |
3000.00 EUR |
N/A |
VAT Input Recoverable |
206103 |
588.00 EUR |
N/A |
Accounts Payable |
200000 |
N/A |
3588.00 EUR |
Prepaid Expense |
122000 |
N/A |
1000.00 EUR |
VAT Input Recoverable |
206103 |
N/A |
196.00 EUR |
Accounts Payable |
200000 |
1196.00 EUR |
N/A |
Payment to vendor for 2392.00 EUR.
Payment (payment posting):
Description |
Account |
Debit |
Credit |
Accounts Payable |
200000 |
2392.00 EUR |
N/A |
Cash Distribution |
100001 |
N/A |
2392.00 EUR |
This scenario assumes:
Prepayment for 1000.00 EUR.
Applied regular voucher for 11960.00 EUR.
VAT declaration point is payment.
Prepaid Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Prepaid Expense |
122000 |
1000.00 EUR |
N/A |
VAT Intermediate Recoverable |
206300 |
196.00 EUR |
N/A |
Accounts Payable |
200000 |
N/A |
1196.00 EUR |
Payment (payment posting):
Description |
Account |
Debit |
Credit |
VAT Intermediate Recoverable |
206300 |
N/A |
196.00 EUR |
VAT Input Recoverable |
206103 |
196.00 EUR |
N/A |
Accounts Payable |
200000 |
1196.00 EUR |
N/A |
Cash Distribution |
100001 |
N/A |
1196.00 EUR |
Applied Regular Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Expense Account |
631000 |
10000.00 EUR |
N/A |
VAT Intermediate Recoverable |
206300 |
1960.00 EUR |
N/A |
Accounts Payable |
200000 |
N/A |
11960.00 EUR |
Prepaid Expense |
122000 |
N/A |
1000.00 EUR |
VAT Intermediate Recoverable |
206300 |
N/A |
196.00 EUR |
Accounts Payable |
200000 |
1196.00 EUR |
N/A |
Payment to vendor for 10764.00 EUR.
Payment (payment posting):
Description |
Account |
Debit |
Credit |
VAT Intermediate Recoverable |
206300 |
N/A |
1764.00 EUR |
VAT Input Recoverable |
206103 |
1764.00 EUR |
N/A |
Accounts Payable |
200000 |
10764.00 EUR |
N/A |
Cash Distribution |
100001 |
N/A |
10764.00 EUR |
This scenario assumes:
Prepayment for 1000.00 EUR.
Applied regular voucher for 11960.00 EUR.
VAT declaration point is payment.
VAT Type: Prorate nonrecoverable.
Prepaid Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Prepaid Expense |
122000 |
1186.20 EUR |
N/A |
VAT Intermediate Recoverable |
206300 |
9.80 EUR |
N/A |
Accounts Payable |
200000 |
N/A |
1196.00 EUR |
Payment (payment posting):
Description |
Account |
Debit |
Credit |
VAT Intermediate Recoverable |
206300 |
|
9.80 EUR |
VAT Input Recoverable |
206103 |
9.80 EUR |
N/A |
Accounts Payable |
200000 |
1196.00 EUR |
N/A |
Cash Distribution |
100001 |
N/A |
1196.00 EUR |
Applied Regular Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Expense Account |
631000 |
11862.00 EUR |
N/A |
VAT Input Recoverable |
206103 |
98.00 EUR |
N/A |
Accounts Payable |
200000 |
N/A |
11960.00 EUR |
Prepaid Expense |
122000 |
N/A |
1186.20 EUR |
VAT Input Recoverable |
206103 |
N/A |
9.80 EUR |
Accounts Payable |
200000 |
1196.00 EUR |
N/A |
Payment to vendor for 10764.00 EUR.
Payment (payment posting):
Description |
Account |
Debit |
Credit |
VAT Intermediate Recoverable |
206300 |
N/A |
88.20 EUR |
VAT Input Recoverable |
206103 |
88.20 EUR |
N/A |
Accounts Payable |
200000 |
10764.00 EUR |
N/A |
Cash Distribution |
100001 |
N/A |
10764.00 EUR |
This scenario assumes the following:
Vendor is subject to 31 percent withholding.
Prepayment for 1000.00 USD gross.
Withholding is not postponed.
Payment to vendor is 690.00 USD.
Withholding payment is scheduled for 310.00 USD.
Regular voucher for 5000.00 USD.
1000.00 USD of prepaid voucher is applied.
Payment to vendor is 2760.00 USD.
Withholding payment is scheduled for 1240.00 USD.
Prepaid Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Prepaid Expense |
122000 |
1000.00 USD |
N/A |
Accounts Payable |
200000 |
N/A |
1000.00 USD |
Payment (payment posting):
Description |
Account |
Debit |
Credit |
Accounts Payable |
200000 |
310.00 USD |
N/A |
Withholding Liability |
203000 |
N/A |
310.00 USD |
Accounts Payable |
200000 |
690.00 USD |
N/A |
Cash |
100001 |
N/A |
690.00 USD |
Applied Regular Voucher
Accrual (voucher posting):
Description |
Account |
Debit |
Credit |
Expense |
631000 |
5000.00 USD |
N/A |
Accounts Payable |
200000 |
N/A |
5000.00 USD |
Prepaid Expense |
122000 |
N/A |
1000.00 USD |
Accounts Payable |
200000 |
1000.00 USD |
N/A |
Payment (payment posting):
Description |
Account |
Debit |
Credit |
Accounts Payable |
200000 |
1240.00 USD |
N/A |
Withholding Liability |
203000 |
N/A |
1240.00 USD |
Accounts Payable |
200000 |
2760.00 USD |
N/A |
Cash |
100001 |
N/A |
2760.00 USD |
This section discusses voucher contracts.
PeopleSoft voucher and order contracts enable you to manage recurring voucher payments and PO releases over any time period. PeopleSoft voucher and order contracts support both product and service contracts and enable you to share contracts across business units. Use voucher contracts to establish and schedule amounts for recurring payments such as rent and lease payments, utilities, and regular supply deliveries, and you can generate the resulting vouchers. As each voucher comes due according to the payment terms of the vendor and business unit, the voucher is approved and paid. You can adjust the amount of individual vouchers during the life of the contract.
Select the Prepaid Voucher option or the Prepaid Voucher with Advance PO Contract process option in the Voucher Contracts Options group box on the Maintain Contract - Header page to associate a prepayment reference for the contract. When a recurring voucher is generated, it is applied to the prepaid voucher using either the batch or manual application processes.
See Also
Using Voucher and Order Contracts
To process prepayments, set up a default prepaid expense account and give users the authority to prepay vouchers. You set up a default prepaid expense account in the Accounting Entry Template page. The account that you enter here automatically changes to the Account field on the distribution line for prepaid vouchers.
Note. Because prepayments are created immediately, the open liability should never be overstated. For this reason, the liability account is the accounts payable account.
You give users the authority to prepay vouchers on the Voucher Styles page. Select the Allow Prepay Voucher check box to give the user the authority to enter a prepayment voucher. Once you select the check box, the Prepay Limit field (in the Online Voucher Processing group box on the User Preferences - Procurement: Payables page) becomes available for entry, and you can specify a maximum amount for each prepayment the user can enter. You must also specify a currency and rate type for this amount.
Note. If you do not enter an amount, the user may enter a prepayment for any amount.
See Also
Creating Accounting Entry Templates
Defining Payables User Preferences
This section discusses how to:
Create prepaid vouchers.
Set batch prepayment processing options.
Specify VAT and withholding on prepayments.
Schedule and record prepayments.
Note. You can also enter and apply prepayments using the Quick Invoice Entry component (VCHR_QUICK_PNL).
See Using Quick Invoices.
Page Name |
Definition Name |
Navigation |
Usage |
VCHR_EXPRESS1 |
Accounts Payable, Vouchers, Add/Update, Regular Entry, Invoice Information Select the Prepaid Voucher voucher style on the Add a New Value page before accessing the Invoice Information page. |
Create a prepaid voucher. |
|
VCHR_STATUS_IA |
Accounts Payable, Vouchers, Add/Update, Regular Entry, Voucher Attributes |
Set batch processing options for prepayments and withholding. |
|
VCHR_PAYMENT_PNL |
Accounts Payable, Vouchers, Add/Update, Regular Entry, Payments |
Schedule and record prepayments. |
Access the Invoice Information page (Accounts Payable, Vouchers, Add/Update, Regular Entry, Invoice Information).
When you select a voucher style of Prepaid Voucher, the Invoice Information page looks different than it does when you select Regular Voucher. The fields that differ are:
Pay Terms |
Override the payment terms, but only single payment terms with no discount are allowed. The payment terms code appears by default from the PeopleSoft Payables business unit. The payment term is validated when you click Refresh or Save. |
Misc. Amount (miscellaneous amount), Freight Amount, and Sales Tax |
For prepaid vouchers, the nonmerchandise charges (freight, miscellaneous charges, and taxes) do not appear. |
(USF) Advance Payment Option |
Select Use Advance Payment in the Advance Payment Option group box. If you are creating a prepayment voucher and you are a U.S. federal agency with Enable Federal Payments field selected on the Installation Options - Payables page, the Advance Payment Option group box appears. Note. The Voucher component (VCHR_EXPRESS) does not copy lines from the associated purchase order when you enter the purchase order number here. Purchase order business unit and purchase order ID are used as a verification step only when creating an advance payment. See (USF) Processing PeopleSoft Payables for U.S. Federal Agencies. |
Account |
Override the account with any valid account. For prepaid vouchers, the account in the distribution line appears by default from the Prepaid Expense field on the Accounting Entry Template page. |
Note. Prepaid vouchers can contain only a single voucher line and a single distribution line. The ability to insert and delete voucher lines and distribution lines is disabled for prepaid vouchers.
See Also
Entering Invoice Information for Online Vouchers
Creating Accounting Entry Templates
Access the Voucher Attributes page (Accounts Payable, Vouchers, Add/Update, Regular Entry, Voucher Attributes).
You establish the processing options for the AP Prepayment Application process in the Prepayment group box on the Voucher Attributes Page. The two options are:
Prepayment Reference |
Enter the reference number on both the prepaid voucher and the unapplied voucher so the system can match them. This is a free-form (10-character) field used to match up prepaid vouchers with unapplied vouchers. |
Automatically Apply Prepayment |
Select this check box to enable the system to apply unapplied vouchers to prepayments automatically during the Voucher Posting process. |
These fields work together to determine whether the prepayment is to be applied to a specific voucher and whether it can be applied automatically to any other open voucher for that vendor.
Note. You can also apply the regular vouchers and prepaid vouchers manually using the Apply Vouchers to Prepayment page. Changes made on this page are updated in the VCHR_PPAY_XREF record immediately.
Batch Prepayment Application Process Logic
The AP Prepayment Application process applies prepaid vouchers and regular vouchers to each other using the Prepayment Reference field first, and then using the auto-apply (automatically apply prepayment) feature. The Prepayment Reference field and the Automatically Apply Prepayment check box can be used for both prepaid vouchers and regular vouchers. How they function depends on the voucher type.
On prepaid vouchers, the Automatically Apply Prepayment check box is selected by default and is unavailable for entry. Once you enter a prepayment reference, the Automatically Apply Prepayment check box becomes available for entry and is deselected. You now have the option to select the Automatically Apply Prepayment check box, or to leave it deselected. If you do not use the Prepayment Reference field to match prepayments and regular vouchers, the system uses the auto-apply feature.
For regular vouchers, the Automatically Apply Prepayment check box is selected by default and is available for entry. You can enter a prepayment reference and select the Automatically Apply Prepayment check box or deselect the Automatically Apply Prepayment check box. By leaving the prepayment reference blank and deselecting the Automatically Apply Prepayment check box, you can set the regular voucher to be ignored by the auto-apply feature, in which case, no prepaid vouchers are applied to it.
Prepaid and regular vouchers can have one of these possible combinations of settings for these fields. The following table lists these combinations from most to least restrictive and shows how the system applies regular vouchers and prepayments for each one:
Prepayment Reference |
Automatically Apply Prepayment Check Box |
Prepayment Rule Applied |
Entered |
Deselected |
The system applies prepayments only where the prepayment reference on the prepaid voucher is equal to the prepayment reference on the unapplied voucher. |
Entered |
Selected |
The system first applies prepayments where the prepayment reference on the prepaid voucher is equal to the prepayment reference on the unapplied voucher. If no matches exist, if there is a remaining prepayment to be applied, or if there are remaining unapplied voucher amounts, the system applies prepayments automatically. |
Blank |
Selected |
The system applies prepayments to unapplied vouchers automatically. |
Blank |
Blank |
This option can only be used for regular vouchers. The system does not apply the regular voucher to any prepayments. |
See Also
Applying Final Invoices to Prepayments
Access the Voucher Attributes page (Accounts Payable, Vouchers, Add/Update, Regular Entry, Voucher Attributes).
VAT and withholding work much the same way with prepaid vouchers as they do with regular vouchers with a few exceptions.
Withholding on Prepayments
You can postpone the withholding on a prepaid voucher by selecting the Postpone Withholding check box in the Prepayment group box on the Voucher Attributes page.
Postpone Withholding |
Select to postpone withholding until you process the final invoice. This field is also stored on the PS_VCHR_PPAY_XREF table. If withholding is postponed (that is, withholding does not occur on the prepaid voucher), withholding occurs on the regular voucher using the total of the regular schedule rows and the related applied rows. If withholding is not postponed, (that is, if withholding occurs on the prepaid voucher) when the regular voucher is processed, only the non-applied rows are used as a basis for withholding. |
Note. When there is withholding on a prepaid voucher (that is, when withholding is not postponed), the full gross amount of the prepaid voucher (not the amount of the payment to the vendor) is available for application to regular vouchers.
VAT on Prepayments
The accounting entries for prepayments also differ when they involve VAT. When the applied regular voucher is posted, all of the accounting entries for the associated prepayment vouchers are reversed, including the VAT accounting entries.
See Also
Calculating Withholding on Prepayments
Access the Voucher - Payments page (Accounts Payable, Vouchers, Add/Update, Regular Entry, Payments).
PeopleSoft Payables treats prepaid vouchers like regular vouchers with some slight modifications with respect to payments. Schedule payments for prepaid vouchers using the Payments page, and then the Pay Cycle process picks up the scheduled payment and generates an actual check.
You can also record payments for prepaid vouchers using the Payments page. Use the record payment feature to record checks that were processed outside PeopleSoft Payables.
To schedule the payment for a prepayment:
Enter a prepaid voucher for 1000.00 USD using a unique prepayment reference number in the Prepayment Reference field.
Run the Pay Cycle process and the system produces a check that you can mail to the vendor.
Receive a final voucher for 2001.00 USD.
Enter a regular voucher using the same prepayment reference number that you used on the prepaid voucher.
When you run the Voucher Posting process, it automatically calls the AP Prepayment Application process which applies the two vouchers to one another.
Run the Pay Cycle process to create a second check for 1001.00 USD.
Note. You can also manually apply the vouchers, and the Pay Cycle process creates the second check.
To record the payment for a prepayment
Write a check and give it to the vendor.
(Assume a vendor needs a check for a deposit of 1000.00 USD immediately).
Enter a prepaid voucher.
On the Payments page, change the value in the Action field to Record, and enter the check number of the manual check.
Enter the final voucher when it comes in, and if you are using the Prepayment Reference field, the AP Prepayment Application process applies the two vouchers to each other during the Voucher Posting process.
The system issues a check to the vendor for the remainder amount when you run the Pay Cycle process.
Fields that Differ on the Payments Page
Prepayment |
Click this link to access the Apply Vouchers to Prepayment page. You can search for and apply eligible regular vouchers to a prepaid voucher. The link is enabled after the voucher is posted. |
Discount |
Discounts are not permitted on the payment for a prepaid voucher, so the Discount, Net Due, and Discount Due fields are unavailable for entry when you are entering a prepaid voucher. |
Note. Prepaid vouchers can only be paid with a single payment. The ability to insert and delete payments is disabled for prepaid vouchers. Also note that prepaid vouchers cannot be paid with an express payment.
See Also
Scheduling and Creating Voucher Payments for Online Vouchers
This section describes how to:
Apply prepaid vouchers manually.
Search for eligible vouchers.
Page Name |
Definition Name |
Navigation |
Usage |
PPAY_MANUAL_APPLY |
Accounts Payable, Payments, Manual Payment and Prepayment, Apply Vouchers to Prepayment |
Apply and unapply vouchers manually to prepaid vouchers. |
|
VCHR_PPAY_SRCH |
Click the Apply new vouchers to payment link on the Apply Vouchers to Prepayment page. |
Search for regular vouchers that are eligible for application to a prepaid voucher. |
Access the Apply Vouchers to Prepayment page (Accounts Payable, Payments, Manual Payment and Prepayment, Apply Vouchers to Prepayment).
Note. Prepaid vouchers must be paid before you can apply regular vouchers to them. Also note that if you apply vouchers manually, the reversal accounting entries are not created at the time of application; they are not created until you run the Voucher Posting process.
Prepayment
Contains details for the prepaid voucher.
Prepaid Voucher |
Click to access the Voucher - Summary page where you can view the prepaid voucher. |
Total applied |
Displays the total amount of the regular vouchers that you have applied to the prepaid voucher. |
Pending Application |
Displays the amount of the regular vouchers that you have copied from the Voucher Prepayment Search page but which you have not yet applied to the prepaid voucher. |
Available Amount |
Displays the amount of the prepaid voucher that is still available for application to a regular voucher. |
Applied Voucher
Contains details for the regular applied voucher.
Applied Voucher |
Displays the voucher ID for the regular voucher. Click to access the Voucher - Summary page where you can view the regular voucher. |
Payment Count |
Displays the payment count of the scheduled payment for this regular voucher. |
Schedule Amount |
Displays the amount and currency of the scheduled payment for this regular voucher. |
Applied Amount |
Enter the amount of the regular voucher that you want to apply to the prepaid voucher. When you copy the voucher from the Voucher Prepayment Search page, this field is available for entry. Apply a partial amount or the full amount of the voucher. Once you apply the regular voucher to the prepaid voucher, this field becomes display-only, and shows you the amount and currency of the regular voucher that you have applied to the prepaid voucher. |
Select for Unapply |
Select to unapply a regular voucher from the prepaid voucher. Note. You must unpost regular vouchers before you can unapply them. The Select for Unapply check box is unavailable for regular voucher payment schedules that have been fully paid. Note. You must cancel the payment before you can unapply the regular voucher payment schedule. |
Reversal Posting Status |
Displays the status of the reversal accounting entries for the applied voucher. Values are: Not Applied (payment not applied): The regular voucher has not been applied to the prepaid voucher. Unposted: The regular voucher has been applied, but no reversal accounting entries have been created for it. Posted: The regular voucher has been applied to the prepaid voucher, and reversal accounting entries have been generated for it. Note. You must unpost regular vouchers before you can unapply them. |
|
Click to delete the row. You can only delete rows that have not been applied to a prepaid voucher. |
Apply new vouchers to payment |
Click to access the Voucher Prepayment Search page, where you can search for regular vouchers that are eligible to be applied to the selected prepaid voucher. This link becomes unavailable once the available amount is 0.00. |
Apply All |
Click to apply all of the vouchers pending application. Note. The sum of the vouchers selected for application cannot exceed the available amount of the prepaid voucher. |
Unapply |
Click to unapply the vouchers that you have selected for unapply. |
Note. When you click the Apply All or Unapply buttons, the system saves the page and applies or unapplies the selected vouchers accordingly. If you save the page without clicking the Apply or Unapply buttons, the system does not apply or unapply the selected regular vouchers.
Access the Voucher Prepayment Search page (click the Apply new vouchers to payment link on the Apply Vouchers to Prepayment page).
The system only searches for regular vouchers with the same business unit, invoicing vendor, and transaction currency as the prepaid voucher.
Additional Eligibility Criteria for Regular Voucher
To be eligible, regular vouchers must have the following characteristics:
Approved.
Entry status of Postable.
Valid budget status.
Voucher style of Regular.
Additional Eligibility Criteria for Regular Voucher's Payment
To be eligible, regular vouchers payments must have the following characteristics:
Available for payment.
Prepaid status of Unapplied.
Not on hold or on withhold hold.
Netting select status of Applicable.
Gross amount of greater than zero.
The business unit, invoicing vendor, and transaction currency of the prepaid voucher appear at the top of this page.
Copy/Back |
Click this link to copy selected regular vouchers to the Apply Vouchers to Prepayment page. |
Search Criteria
Voucher ID |
Search for eligible regular vouchers by voucher ID or invoice ID. |
Apply Method |
Indicate which vendor the system should use when applying prepaid vouchers to regular vouchers. Values are: Invoicing Vendor: The system performs application based on the invoicing vendor of the prepaid and regular voucher. This is the default value. Remit Vendor: The system performs application based on the remit vendor of the prepaid and regular voucher. Note. You must select the invoicing vendor or remit vendor prior to entering either the voucher ID or the invoice ID. |
Date From and Date To |
Use to search for eligible vouchers whose invoice date falls within a specified range of time. |
Apply Vouchers to a Prepayment
Displays details about the regular vouchers that your search produced.
Payment Information
Displays details about the scheduled payments for the regular vouchers that your search produced.
Select |
Select for the scheduled payments that you want to copy to the Apply Vouchers to Prepayment page. The selected rows are copied when you click the Copy/Back button at the top of the page. |
After you apply the prepaid vouchers to the regular vouchers, run the Pay Cycle process to create the final payment. The system treats the applied voucher just as it treats any other regular voucher during payment selection.
You can also pay the balance of an applied regular voucher with a manual check. Use the Payments page or the Payment Creation feature to record manual payments.
Applied prepaid vouchers appear on the payment advice for the applied regular voucher.
This section lists the pages used to generate final payments.
See Also
Running and Managing Pay Cycles
Page Name |
Definition Name |
Navigation |
Usage |
PYCYCL_MGR |
Accounts Payable, Payments, Pay Cycle Processing, Pay Cycle Manager |
Run and manage the Pay Cycle Application Engine process (AP_APY2015), from Payment Selection through output processing (printing checks and advices, producing EFT files, and so forth). Transfer to pay cycle exceptions pages and pay cycle detail and summary data pages, where you can handle exceptions and hold, exempt, or separate payments. View Pay Cycle processing status and results. |
|
VCHR_PAYMENT_PNL |
Accounts Payable, Vouchers, Add/Update, Regular Entry, Payments |
Record a manually issued payment by changing the value of the Action field to Record. |
|
AP_MAN_SEL |
Accounts Payable, Payments, Manual Payment and Prepayment, Create Manual Payment, Manual Pay Selection |
Enter criteria to build the manual payment worksheet. |
|
AP_MAN_ENTRY |
Accounts Payable, Payments, Manual Payment and Prepayment, Update Payment Worksheet, Man Pay Worksheet Click the Build Worksheet button on the Manual Pay Selection page. |
Enter manual payment information. |
|
AP_MAN_APPLY |
Accounts Payable, Payments, Manual Payment and Prepayment, Update Payment Worksheet, Apply Voucher Click the Build Worksheet button on the Manual Pay Selection page. |
Apply scheduled vouchers to the manual payment. |
You can review prepayments using several inquiry pages and reports.
This section discusses how to:
Inquire on prepayments.
Report on prepayment settlements.
Page Name |
Definition Name |
Navigation |
Usage |
PREPAYMENT_INQ2 |
Accounts Payable, Review Accounts Payable Info, Payments, Prepayments, Prepayment Inquiry |
Review regular vouchers that have been applied to a prepayment. |
|
RUN_APY2100 |
Accounts Payable, Reports, Prepayments, Open Prepayments |
Define run parameters for the Open Prepayments report (APY2100). Use this report to review unapplied prepaid vouchers. |
|
RUN_APY2101 |
Accounts Payable, Reports, Prepayments, Prepayment Settlements |
Define run parameters for the Prepayment Settlement report (APY2101). Use this report to review regular voucher payment schedules that have been settled (fully applied). |
Access the Prepayment Inquiry page (Accounts Payable, Review Accounts Payable Info, Payments, Prepayments, Prepayment Inquiry).
Enter your search criteria and click Search to retrieve a list of vouchers that meet your criteria. The system displays voucher information, including the payment schedule number, in the Search Results.
The system uses the payment schedule number to properly display payment information for the voucher. For example, you enter a prepayment voucher for a withholding vendor. The first schedule payment is paid to the vendor. The second schedule payment to the withholding entity has not been paid. When you inquire on the prepayment for the first schedule payment, the system displays the payment date and reference number. When you inquire on the prepayment for the second schedule payment, the system does not display any information in the payment date and reference number.
Prepaid Voucher
Displays information associated with the prepayment voucher.
Business Unit |
Displays the business unit that is used when the prepayment voucher was entered. |
Bank SetID |
Displays the bank setID that is associated with the bank code and account that was used for this prepayment. |
Voucher ID |
Displays the voucher ID that is associated with the prepayment voucher. |
Bank Code |
Displays the bank code for the account on which the prepayment was drawn. |
Gross Amount |
Displays the amount of the prepayment that was created for this voucher. |
Bank Account |
Displays the account on which the prepayment was drawn. |
Payment Date |
Displays the date that the prepayment was processed. |
Reference |
Displays the check number of the prepayment. |
Balance |
Displays the balance remaining on the prepayment. (That is, the prepayment amount less the applied amounts). |
Applied Voucher
Displays information related to the regular applied vouchers.
Applied Business Unit |
Displays the business unit in which the applied voucher was entered. |
Applied Voucher |
Displays the voucher ID for the applied vouchers. |
Gross Invoice Amount |
Displays the gross amount of the applied voucher. |
Applied Amount |
Displays the amount of the regular voucher that has been applied to the prepaid voucher. |
Reversal Posting Status |
Displays the status of the reversal accounting entries for the applied voucher. |
Access the Prepayment Settlements Report page (Accounts Payable, Reports, Prepayments, Prepayment Settlements).
Vendor Range
From Vendor ID and To Vendor ID |
Enter the from and to vendor IDs to restrict the report to single vendor or a range of vendors. |
Date Range
From Date and Through Date |
Enter the from and through dates to restrict the report to a single date or a range of dates. |