Processing Prepayments

This section provides an overview of prepayment processing, lists prerequisites, and discusses how to:

Click to jump to parent topicUnderstanding Prepayment Processing

This section discusses:

Click to jump to top of pageClick to jump to parent topicPrepayment Overview

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:

Use prepayments to create payments for vendors before receiving an invoice:

  1. Enter and pay a prepaid voucher immediately.

  2. Enter it as a regular voucher when the invoice is received.

  3. 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.

  4. 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

Click to jump to top of pageClick to jump to parent topicPrepayment Application and Payment

Complete the following steps to apply and pay regular and prepaid vouchers:

  1. Create the prepaid voucher.

  2. 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

  3. 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.

  4. (Optional) Manually apply the regular voucher to the prepaid voucher.

  5. 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.

  6. 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.

Click to jump to top of pageClick to jump to parent topicPrepayment Posting

When you run the Voucher Posting process for the regular voucher:

  1. The Voucher Posting process calls the AP Prepayment Application process, which processes the vouchers in the following order:

    1. Auto-apply prepayments with matching references.

    2. Auto-apply prepayments with the Auto-Apply check box selected.

  2. The AP Prepayment Application process loops through the available prepaid vouchers by invoice date (oldest first).

  3. 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.

  4. 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.

  5. The scheduled payment (PS_PYMNT_VCHR_XREF) on the regular voucher is reduced by the amount of the applied prepaid voucher.

  6. 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.

  7. If voucher posting encounters regular vouchers which are applied to prepaid vouchers, reversal accounting entries are created for the prepaid vouchers.

  8. 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.

  9. 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.

Click to jump to top of pageClick to jump to parent topicPrepaid and Regular Voucher Cross-Reference Record

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:

  1. A row is inserted into PS_VCHR_PPAY_XREF when a new prepaid voucher is entered.

  2. This row is updated with the relevant linkage data when a regular voucher is applied to the prepaid voucher.

  3. Additional rows are added to PS_VCHR_PPAY_XREF, if and when the prepaid voucher is applied to additional regular vouchers.

  4. 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.

  5. When payments are created, the scheduled payment generates a payment that has already been reduced by the applied prepaid vouchers.

  6. When a regular voucher is posted, unposted rows in PS_VCHR_PPAY_XREF generate a set of reversal accounting entries for the prepaid voucher.

  7. 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.

Click to jump to top of pageClick to jump to parent topicDiscounts and Prepayment Application

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.

Click to jump to top of pageClick to jump to parent topicPrepayment Cancellation

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.

Canceling and Reissuing

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.

Canceling and Closing

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.

Click to jump to top of pageClick to jump to parent topicPrepaid and Applied Voucher Closure

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:

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.

Click to jump to top of pageClick to jump to parent topicManual Prepayment Application Example

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.

Click to jump to top of pageClick to jump to parent topicAccounting Entry Example 1: Prepayment Without VAT or Withholding

This scenario assumes:

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

Click to jump to top of pageClick to jump to parent topicAccounting Entry Example 2: Prepayment with 100% VAT on Regular Voucher

This scenario assumes:

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

Click to jump to top of pageClick to jump to parent topicAccounting Entry Example 3: Prepayment with 100% VAT on Payment

This scenario assumes:

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

Click to jump to top of pageClick to jump to parent topicAccounting Entry Example 4: Prepayment with 5% Prorated, Nonrecoverable VAT

This scenario assumes:

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

Click to jump to top of pageClick to jump to parent topicAccounting Entry Example 5: Prepayment with Withholding

This scenario assumes the following:

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

Click to jump to top of pageClick to jump to parent topicRecurring Prepayment Vouchers

This section discusses voucher contracts.

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

Click to jump to parent topicPrerequisites

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

Click to jump to parent topicEntering Prepaid Vouchers Online

This section discusses how to:

Note. You can also enter and apply prepayments using the Quick Invoice Entry component (VCHR_QUICK_PNL).

See Using Quick Invoices.

Click to jump to top of pageClick to jump to parent topicPages Used to Enter Prepaid Vouchers Online

Page Name

Definition Name

Navigation

Usage

Invoice Information

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.

Voucher Attributes

VCHR_STATUS_IA

Accounts Payable, Vouchers, Add/Update, Regular Entry, Voucher Attributes

Set batch processing options for prepayments and withholding.

Voucher - Payments

VCHR_PAYMENT_PNL

Accounts Payable, Vouchers, Add/Update, Regular Entry, Payments

Schedule and record prepayments.

Click to jump to top of pageClick to jump to parent topicCreating Prepaid Vouchers

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

Defining Payment Options

Entering Invoice Information for Online Vouchers

Creating Accounting Entry Templates

Click to jump to top of pageClick to jump to parent topicSetting Batch Prepayment Processing Options

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

Completing Voucher Attributes

Click to jump to top of pageClick to jump to parent topicSpecifying VAT and Withholding on 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

Completing Voucher Attributes

Calculating Withholding on Prepayments

Click to jump to top of pageClick to jump to parent topicScheduling and Recording 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:

  1. Enter a prepaid voucher for 1000.00 USD using a unique prepayment reference number in the Prepayment Reference field.

  2. Run the Pay Cycle process and the system produces a check that you can mail to the vendor.

  3. Receive a final voucher for 2001.00 USD.

  4. Enter a regular voucher using the same prepayment reference number that you used on the prepaid voucher.

  5. 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

  1. Write a check and give it to the vendor.

    (Assume a vendor needs a check for a deposit of 1000.00 USD immediately).

  2. 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.

  3. 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.

  4. 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

Click to jump to parent topicApplying Final Invoices to Prepayments

This section describes how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Apply Final Invoices to Prepayments

Page Name

Definition Name

Navigation

Usage

Apply Vouchers to Prepayment

PPAY_MANUAL_APPLY

Accounts Payable, Payments, Manual Payment and Prepayment, Apply Vouchers to Prepayment

Apply and unapply vouchers manually to prepaid vouchers.

Voucher Prepayment Search

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.

Click to jump to top of pageClick to jump to parent topicApplying Prepaid Vouchers Manually

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.

Click to jump to top of pageClick to jump to parent topicSearching for Eligible 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:

Additional Eligibility Criteria for Regular Voucher's Payment

To be eligible, regular vouchers payments must have the following characteristics:

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.

Click to jump to parent topicGenerating Final Payments

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

Recording Manual Payments

Creating Manual Payments

Click to jump to top of pageClick to jump to parent topicPages Used to Generate Final Payments

Page Name

Definition Name

Navigation

Usage

Pay Cycle Manager

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.

Voucher - Payments

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.

Manual Pay Selection

AP_MAN_SEL

Accounts Payable, Payments, Manual Payment and Prepayment, Create Manual Payment, Manual Pay Selection

Enter criteria to build the manual payment worksheet.

Man Pay 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.

Apply Voucher

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.

Click to jump to parent topicReviewing Prepayments

You can review prepayments using several inquiry pages and reports.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Review Prepayments

Page Name

Definition Name

Navigation

Usage

Prepayment Inquiry

PREPAYMENT_INQ2

Accounts Payable, Review Accounts Payable Info, Payments, Prepayments, Prepayment Inquiry

Review regular vouchers that have been applied to a prepayment.

Open Prepayments Report

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.

Prepayment Settlements Report

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).

Click to jump to top of pageClick to jump to parent topicInquiring on Prepayments

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.

Click to jump to top of pageClick to jump to parent topicReporting on Prepayment Settlements

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.