This chapter provides an overview of document sequencing in PeopleSoft Payables and the document sequence header table, lists prerequisites, and discusses how to:
Define and assign document types.
Use document sequencing with various transactions.
Statutory requirements in some countries require that all financial transactions (documents) be classified into different transaction types, and that within each transaction type, all documents entered be numbered sequentially. The Document Sequencing feature helps you maintain established business practices by meeting both of these requirements.
Document sequencing is available for documents that you create either online or through background (batch) processing. When you activate the Document Sequencing feature, the PeopleSoft system automatically assigns a sequence number to each document (invoice, voucher, journal, and so on) that you create. You can also enter sequence numbers manually. When you delete, change, or unpost a document, the system may generate additional document sequence numbers, as appropriate.
Document Sequencing Setup Considerations
Document sequencing must be established for business units at implementation, before transactions exist for the business units. Activating document sequencing functionality when a business unit has existing transactions results in payment cancellation and voucher closure issues. Consequently, once a business unit has transactions, its document sequencing setting should not be changed.
If you have erroneously activated document sequencing, you must correct the resulting voucher issues as follows:
Use credit vouchers to close vouchers.
Use journal entries to correct the accounting entries of canceled payments.
See Also
PeopleSoft Payables uses a Document Sequence Header table, VCHR_DOCSEQ_HDR, to store document sequence numbers for each new set of accounting entries. This table is a child of the voucher table. Where possible, the data for VCHR_DOCSEQ_HDR is populated online. For example, when a voucher is closed, the voucher close document sequence number is generated or validated when you save the page. The Voucher Posting Application Engine process (AP_PSTVCHR) then copies the document sequencing information to the closure accounting lines.
In other cases, however, document sequence numbers have to be generated in a batch process. In these instances, the necessary information is inserted by bulk into VCHR_DOCSEQ_HDR. The document sequencing routine is invoked to create a new document sequence number for each row in VCHR_DOCSEQ_HDR. PeopleSoft Payables processes (payment posting, revaluation, and cash clearing) call a routine (FTDOCAE) that copies the document sequence information from VCHR_DOCSEQ_HDR to the accounting entry table. For example, when a payment is canceled, and the associated vouchers are closed, a closure document sequence number is generated for each voucher that is associated with the payment.
When the certain events occur, the system combines four data elements to generate a document sequence number and inserts this combination into VCHR_DOCSEQ_HDR. The document sequence number consists of the following:
The PeopleSoft General Ledger business unit.
The default ledger group of the business unit.
The appropriate journal code/document type (this is dependent on the defined sequence by option).
The sequence date range value.
This table lists the various events in PeopleSoft Payables that generate document sequence numbers, and it details whether document sequencing occurs online or as a batch process, as well as which pages and processes are involved.
Event |
Type of Processing |
Pages / Processes |
New voucher |
Online Batch |
Voucher component Voucher Build (AP_VCHRBLD) |
Voucher closure |
Online Batch |
Close Voucher component Voucher Mass Maintenance component Voucher Posting (AP_PSTVCHR) |
Voucher unpost |
Online |
Unpost Voucher component Voucher Mass Maintenance component |
Voucher delete |
Online |
Delete Voucher component Voucher Mass Maintenance component |
New payment |
Online or Batch |
Express Payment page Voucher component (Payments page) Manual Pay component Pay Cycle (AP_APY2015) |
Pay cycle reset |
Online |
Pay Cycle Manager page |
Cancel payment |
Online |
Cancel Payment page Mass Payment Cancellation component |
Cancel payment voucher close |
Batch |
Payment Posting (AP_PSTPYMNT) |
Manual draft |
Online |
Manual Draft Creation page |
Draft write-off |
Online |
Draft Write Off page |
Cash clearing |
Batch |
Cash Clearing (AP_APCSHCLR) |
Payables revaluation |
Batch |
PS/AP Revaluation (AP_REVALUE) |
Before you can begin using the Document Sequencing feature in PeopleSoft Payables, you must:
Enable document sequencing at the system level.
Enable document sequencing at the PeopleSoft General Ledger business unit level.
Specify a document sequence range.
Define the journal types and journal codes.
See Also
Setting Up a System for Document Sequencing
To set up your document types and assigning document types, use the following components:
Document Type (DOC_TYPE).
Journal Generator Template (JRNLGEN_APPL_ID).
Procurement Control (BUS_UNIT_INTFC2).
External Accounts (BANK_EXTERNAL).
This section discusses how to:
Define PeopleSoft Payables document sequencing.
Assign document types to journals.
Assign document types to accounting entry types.
Assign default document types for payment methods.
Page Name |
Definition Name |
Navigation |
Usage |
DOC_TYPE |
Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Document Type |
Use this page to define your Payables document types. |
|
JRNL_GEN_DEFAULTS |
General Ledger, Journals, Subsystem Journals, Journal Generator Template, Defaults |
Assign a document type to the accounting entries that PeopleSoft Payables generates. The Journal Generator Application Engine process (FS_JGEN) uses this information to assign a document sequence number when you create journals through the Journal Generator process. |
|
JRNL_GEN_SUM |
General Ledger, Journals, Subsystem Journals, Journal Generator Template, Summarization |
Select Retain Detail in the How Specified Option group box to retain and pass the document sequence numbers to PeopleSoft General Ledger. |
|
BUS_UNIT_INTFC4 |
Set Up Financials/Supply Chain, Business Unit Related, Procurement, Procurement Control, Document Types The Procurement Control - Document Types page only appears if you have document sequencing enabled at the installation level. |
Assign document types to each accounting entry type in PeopleSoft Payables. |
|
PYMNT_BANK_DOC_SEC |
Banking, Bank Accounts, External Accounts, Payment Methods Click the Document Sequencing link on the External Accounts - Payment Methods page. This link is active only if the bank belongs to a PeopleSoft General Ledger business unit that is set up for document sequencing. |
Assign default document types for payment methods. |
Access the Document Type page (Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Document Type).
Once you set up your system for document sequencing, you can use this page to define your payables document types.
See Also
Access the Journal Generator Template - Defaults page and the Summarization page (General Ledger, Journals, Subsystem Journals, Journal Generator Template, Defaults).
Use the Journal Generator Template - Defaults page to assign a document type to the accounting entries. Use the Journal Generator Template - Summarization page to select Retain Detail to retain and pass the document sequence number to PeopleSoft General Ledger.
See Also
Defining Sequencing Options for Accounting Entries
Access the Procurement Control - Document Types page (Set Up Financials/Supply Chain, Business Unit Related, Procurement, Procurement Control, Document Types).
You assign document types for each accounting entry type in PeopleSoft Payables at the PeopleSoft General Ledger business unit level.
See Also
Defining Procurement Controls for General Ledger Business Units
Access the External Accounts - Document Sequence page (click the Document Sequencing link on the External Accounts - Payment Methods page).
Set up the default document type setup for the various payment methods on the Payment Methods page in the External Accounts component. From this page, you can access a Document Sequence page for assigning the default document type for that payment method, if the bank account is tied to a PeopleSoft General Ledger business unit for which the Document Sequencing feature has been enabled.
See Also
This section describes how document sequencing affects various transactions and activities in PeopleSoft Payables processing.
To create accounting transactions and document sequencing, you:
Enter vouchers with document sequencing.
Close vouchers with document sequencing.
Unpost and repost vouchers with document sequencing.
Delete vouchers with document sequencing.
Create payments with document sequencing.
Create manual payments with document sequencing.
Cancel payments with document sequencing.
Create manual drafts with document sequencing.
Write-off drafts with document sequencing.
Use document sequencing with interunit transactions.
Process cash clearing entries with document sequencing.
Use document sequencing with revaluation entries.
Page Name |
Definition Name |
Navigation |
Usage |
DOC_SEQ_AP_SEC |
Accounts Payable, Vouchers, Add/Update, Regular Entry, Invoice Information Click the Document Sequencing link on the Invoice Information page. |
Override the default document type and enter a document sequence number, if applicable. |
|
DOC_SEQ_CLOSE_SEC |
Accounts Payable, Vouchers, Add/Update, Close Voucher Click the Document Sequencing link on the Close Voucher page. |
Override the default document type and enter a document sequence number, if applicable. |
|
DOC_SEQ_UNPST_SEC |
Accounts Payable, Vouchers, Add/Update, UnPost Voucher Click the Unpost Document Sequencing link on the UnPost Voucher page. |
Override the default document type and enter a document sequence number, if applicable. |
|
DOC_SEQ_REPST_SEC |
Accounts Payable, Vouchers, Add/Update, UnPost Voucher Click the Repost Document Sequencing link on the Voucher UnPost page. |
Override the default document type and enter a document sequence number, if applicable. |
|
SEQ_NBR_DEL_TBL |
Accounts Payable, Vouchers, Add/Update, Delete Voucher A prompt appears when you click the Delete button in the Delete Voucher component. |
After you click the Delete button, enter a deletion reason. The deletion reason is required if you are using the Document Sequencing feature. |
|
PYCYCL_MGR |
Accounts Payable, Payments, Pay Cycle Processing, Pay Cycle Manager |
Run and manage the Pay Cycle process, from payment selection through output processing (printing checks and advices, producing electronic file transfer (EFT) files, and so forth). Transfer to the pay cycle exceptions pages and pay cycle detail and summary data pages, where you can handle exceptions and hold, exempt, or separate payments. View the status and results of the Pay Cycle process. |
|
PYMNT_EXPRESS |
|
Create a payment for one or multiple vouchers for one specific vendor. |
|
VCHR_PAYMENT_PNL |
Accounts Payable, Vouchers, Add/Update, Regular Entry, Payments |
Record a manually issued payment by changing the schedule payment Action field value to Record. Click the Doc Seq (document sequence) link to override the default document type and enter a document sequence number, if applicable. |
|
AP_MAN_SEL |
Accounts Payable, Payments, Manual Payment and Prepayment, Create Manual Payment, Manual Pay Selection |
Enter criteria to build the manual payment worksheet. On the Man Pay Worksheet (manual payment worksheet) page, enter the manual payment information. On the Apply Voucher page, apply scheduled vouchers to the manual payment. |
|
DOC_SEQ_CANCEL_SEC |
Accounts Payable, Payments, Cancel/Void Payments, Payment Cancellation, Cancel Payment Click the Document Sequencing link on the Cancel Payment page. |
Override the default document type and enter a document sequence number, if applicable. |
|
DOC_SEQ_PY_REC_SEC |
Accounts Payable, Payments, Drafts, Create Manual Draft, Manual Draft Creation Click the Document Sequencing link on the Manual Draft Creation page. |
Override the default document type and enter a document sequence number, if applicable. |
|
DOC_SEQ_PY_REC_SEC |
Accounts Payable, Payments, Drafts, Draft Write-Off Click the Document Sequencing link on the Draft Write Off page. |
Override the default document type and enter a document sequence number, if applicable. |
Access the Invoice Information - Document Sequence page (click the Document Sequencing link on the Invoice Information page).
When you enter a voucher online that is associated with a business unit setup for document sequencing, a document sequencing link appears on the Invoice Information page, enabling you to access the Document Sequence page. On that page, you can override the default document type and enter a document sequence number, if applicable.
Document Type |
The system automatically assigns the default document type for each transaction based on your setup. You can override this setting by selecting a new value from the available types. |
Journal Code |
Displays the associated journal code for the selected document type. This field is display only. |
Document Sequence Number |
Displays NEXT until you save the transaction if you have opted to use automatic numbering. When you save the transaction, the system assigns the next available sequence number. If you have not opted to use automatic numbering, use this field to enter the document sequence number. |
Document Sequence Date |
When you save the transaction, the system automatically records the current date in the Document Sequence Date field. |
Note. The Voucher Build Application Engine process (AP_VCHRBLD) assigns the document type, document sequence number, and document sequence date as part of its process.
See Also
Entering Invoice Information for Online Vouchers
Access the Close Voucher - Document Sequence page (click the Document Sequencing link on the Close Voucher page).
Voucher closure creates a new document sequence number and document sequence date for the closure accounting entries that are created by the Voucher Posting process. If you are using the online Close Voucher component (VCHR_CLOSE), you can access a document sequence page, where you can override the default document type and enter a manual document sequence number.
When you save the Close Voucher component, the online document sequencing routines are invoked. If the edit is successful, a row is inserted into the VCHR_DOC_SEQ_HDR table for the closure event. This row contains the document type, document sequence number and the document sequence date for the closure event. When the Voucher Posting process processes the closed voucher, it copies this new document sequence information to the closure accounting entries.
Regardless of the voucher type and closure method you use—either closing individual vouchers using Close Voucher page, or closing multiple vouchers using the Mass Maintenance component (VCHR_MASS_MAINT)—the system writes to VCHR_DOC_SEQ_HDR table. When you use the Mass Maintenance component, you can enter comments that the system applies to all the vouchers included in a single closure event.
Note. The Close Voucher page is used to mark the voucher for closure. The voucher is closed when you run the Voucher Posting process.
Note. If you are using document sequencing and have saved the voucher on the Close Voucher page with the Close check box selected, you cannot access the voucher again to reopen it.
See Also
Access the Unpost Voucher - Document Sequence page (click the Unpost Document Sequencing link on the UnPost Voucher page).
When you unpost a voucher, the Voucher Posting process:
Creates reversal accounting entries for any vouchers with document sequence numbers, regardless of whether the vouchers have been distributed to PeopleSoft General Ledger.
Creates a new document sequence number and document sequence date for the reversing accounting entries that it generates.
Creates a new accrual document sequence number for the unposted voucher.
If the unposted voucher is reposted, the Voucher Posting process creates new accounting entries with the new accrual document sequence number and date, based on the setup specified on the Procurement Control - Document Types page.
In the UnPost Voucher component, you can access two document sequence pages for processing document sequencing as part of unpost and repost.
Unpost Document Sequencing |
Click this link to override the default document type and number for unposting. When you click the Unpost button on the UnPost Voucher page and click OK, the system creates reversing accounting entries with a new document sequence number. |
Repost Document Sequencing |
Click this link to override the default document type and number for reposting. When you run the Voucher Posting process to repost this voucher, the system creates new accounting entries with a new document sequence number. |
See Also
Access the Delete Voucher - Delete Document page (Accounts Payable, Vouchers, Add/Update, Delete Voucher).
Enter a document delete reason in the Long Description field. This page appears and a document delete reason is required when document sequencing is enabled for the PeopleSoft General Ledger business unit.
See Also
You can create payments in a batch process or online.
For batch processing, access the Pay Cycle Manager page to run the Payment Creation process to create payments. This process generates document sequence numbers for these payments. The Payment Posting Application Engine process (AP_PSTPYMNT) then copies the document sequence numbers generated during the Payment Creation process to the payment accounting entries.
For online payment processing, you can record a manual payment in the Voucher component (VCHR_EXPRESS), create a manual payment, or access the Express Payment page to create a payment for one or multiple vouchers for one specific vendor. These online processes create payments and generate document sequence numbers. The Payment Posting process then copies the document sequence numbers generated during online payment processing to the payment accounting entries.
See Also
Running and Managing Pay Cycles
You can create manual payments using online voucher entry or through the Manual Payment feature.
Record a manual payment in the online voucher entry component by selecting Record as the payment action for the scheduled payment on the Voucher - Payments page. Payment posting, reissuing, closing, and voiding work the same as they do for payments created with the Pay Cycle process.
Use the Manual Payment Creation feature to create manual payments. You create a payment, but you apply it to existing vouchers rather than creating a voucher specifically for the payment. Payment posting, reissuing, closing, and voiding work the same as they do for payments created with the Pay Cycle process. However, for payments canceled with the option to close the liability, the Payment Posting process generates new document sequence numbers instead of copying them from another table.
See Also
Access the Payment Cancellation - Document Sequence page (click the Document Sequencing link on the Cancel Payment page).
Use the Payment Cancellation component (PYMNT_CANCEL) to cancel individual payments, or you can use the Mass Payment Cancellation component (AP_PMT_MASS_CNL) to cancel multiple payments. Regardless of the component you use, you can override the document type for the cancellation accounting entries and enter a document sequence number, if applicable.
Payment cancellation creates a new document sequence number and date for the cancellation accounting entries that are created by the Payment Posting process. Payment posting also generates new closure document sequence numbers for all the vouchers that are associated with the canceled payment with the option to close the liability.
If you choose to undo a payment cancellation for a payment with a document sequence number by selecting Undo Cancel on the Payment Cancellation page or the Mass Payment Cancellation page, the following warning message appears: Undo Cancel requires deletion of document sequence number Proceed? (7015,209) Undo Cancel requires deletion of document sequence number. Proceed?
If you click OK, the Delete Document - Document Deletion Reason dialog box appears.
Note. This is possible only if you have not run the Payment Posting process on the payment.
See Also
Access the Manual Draft Entry - Document Sequence page (click the Document Sequencing link on the Manual Draft Creation page).
You can override the document type for the draft accounting entries and enter a document sequence number, if applicable.
When you create manual drafts for a bank that is tied to a PeopleSoft General Ledger business unit enabled for document sequencing, the system assigns the draft that you create a document sequence type, document sequence number, and date.
See Also
Access the Draft Write Off - Document Sequence page (Accounts Payable, Payments, Drafts, Draft Write-Off).
The Document Sequence page that you access from the Draft Write Off page is the same as the Document Sequence page that you access from the Manual Draft Worksheet component.
You can override the document type for the draft write off accounting entries and enter a document sequence number, if applicable.
When you are writing off drafts for a bank that is tied to a PeopleSoft General Ledger business unit enabled for document sequencing, the system assigns the draft that you are writing off a document sequence type, document sequence number, and date.
See Also
This section discusses how to:
Process cash clearing entries with document sequencing.
Use document sequencing with revaluation entries.
In some cases, the charged-to distribution (PeopleSoft General Ledger) business unit for a voucher is different from the PeopleSoft General Ledger business unit related to the vouchering (PeopleSoft Payables) business unit. The accounting entries created for this type of voucher by the Voucher Posting process go to more than one PeopleSoft General Ledger business unit. This type of transaction is called an interunit voucher. Because document sequencing is based on the PeopleSoft General Ledger business unit, document sequencing is more complex.
If the voucher's Payables business unit is related to a PeopleSoft General Ledger business unit enabled for document sequencing, then the Voucher Posting process assigns the voucher accounting entries for that PeopleSoft General Ledger business unit, the document sequence type, and number.
The Voucher Posting process sequences the interunit accounting entries for any applicable PeopleSoft General Ledger business units separately. The Voucher Posting process takes the document type from the default accrual interunit document type specified on the Procurement Control - Document Types page for those PeopleSoft General Ledger business units.
Note. This document type must be set to auto-numbering because the interunit accounting entries are created during the Voucher Posting process without any user interaction.
Interunit payments occur when a payment is created for a bank that is tied to a different PeopleSoft General Ledger business unit than the associated voucher's Payables business unit.
When the Payment Posting process creates accounting entries for an interunit payment, it:
Assigns to the accounting entries, which go to the PeopleSoft General Ledger business unit of the payment's bank, the document sequence type, and number generated at the time the payment was created.
Sequences the other accounting entries to the PeopleSoft General Ledger business unit tied to the associated voucher's Payables business unit separately, taking the default payment interunit document type specified on the Procurement Control - Document Types page.
Note. This document type must be set for auto-numbering, because the interunit accounting entries are created during the Payment Posting process without any user interaction.
For accounting entries created by cash clearing, the Cash Clearing Application Engine process (AP_CSHCLR) creates a new document sequence number and updates the cash clearing accounting entries with the new document sequence data. The cash clearing document type appears by default from the setup specified on the Procurement Control - Document Types page.
See Also
Running the Cash Clearing Process
For accounting entries that are created by revaluation, the PS/AP Revaluation Application Engine process (AP_REVALUE) creates a new document sequence number for the revaluation accounting entries on the revaluation accounting line (RVL_ACCTG_LN_AP). The revaluation document type appears by default from the setup specified on the Procurement Control - Document Types page.
Note. If you run revaluation in PeopleSoft Payables rather than in PeopleSoft General Ledger, the process occurs at a specified level of detail. If you run the process in PeopleSoft Payables for the accounts that you use here, do not run the General Ledger revaluation against the same account balances in PeopleSoft General Ledger; if you do, you will be double counting.
See Also
Performing the PS/AP Revaluation Process