Setting Up a System for Document Sequencing
The system does not perform any document sequencing functions unless you select the Document Sequencing option on the Installation Options - Overall page. Once you enable document sequencing at the system level, activate it for designated General Ledger business units on the General Ledger Definition page.
Document sequencing uses the components, Sequence Range (SEQ_RANGE), Journal Type (JRNL_TYPE), Journal Code (JRNL_CODE), Document Type (DOC_TYPE ) and Document Type Template (DOC_TYPE_TMPL).
See Defining Document Sequencing.
This section discusses how to specify a document sequence range, define journal types, journal codes, document types and sequencing options for accounting entries.
Page Name |
Definition Name |
Usage |
---|---|---|
INSTALLATION_FS1 |
Activate the document sequencing functionality by selecting the Enable Document Sequencing option. After activating document sequencing at the system level, it must also be activated at the individual business unit level. The product-specific documentation for setting business unit options. To activate document sequencing within PeopleSoft Asset Management, you must also add a Document Type Template by SetID for sequencing at the asset level. |
|
SEQ_RANGE |
Define the sequence range for your documents. You can define a range that spans yearly, monthly, daily, or any other desired increments. |
|
JRNL_TYPE |
Identify a journal type, and determine at which level the system assigns a sequence number—either at the journal code level or the document type level within the journal code. |
|
JRNL_CODE |
Define journal codes, specify sequence ranges, and determine how document sequence numbers are assigned for each journal code. |
|
Document Type Page |
DOC_TYPE |
Establish document sequencing options for PeopleSoft applications that generate financial transactions. |
DOC_TYPE_TMPL |
Activate document sequencing for PeopleSoft Asset Management. |
To specify a document sequence range:
Use the Document Sequence Range page (SEQ_RANGE) to define the sequence range for your documents. You can define a range that spans yearly, monthly, daily, or any other desired increments. (Navigation: Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Sequence Range)
Enter a Begin Date and End Date to search for document sequence ranges you have already defined. Click the search button to refresh the page with the data you requested. To ensure that only one range is used for each Accounting Date, the system does not allow an overlap in these fields.
Enter a Prefix.
Document sequence numbers consist of a prefix and a number. The prefix may be alphanumeric, and you can leave this field blank. When combined, the prefix and number may not exceed 12 characters. If the total length has fewer than 12 characters, the system inserts zeros between the prefix and the number. For example, if the sequence number prefix is 97 and the number is 201, the sequence number is 970000000201.
Enter a valid Start # (start number) and End # (end number) for your document sequencing number range.
Because the system defines each number range by a date range, it does not allow an overlap in sequence number ranges. Once a document is created and the system has assigned a sequence number, you cannot change the Start # because sequencing has already begun. However, you can change the End # if you have not assigned enough numbers to your range.
To define a journal type:
Use the Journal Type page (JRNL_TYPE) to identify a journal type, and determine at which level the system assigns a sequence number—either at the journal code level or the document type level within the journal code. (Navigation: Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Journal Type)
Enter either a numeric or character value to represent the journal type.
Select a Sequence By option to specify where the document sequencing is to take place—at the journal code level or the document type level (within the journal code).
Note: When you first set up a journal type, all fields on the page are available. Once you enter a transaction record for journal type, and the system assigns a document sequence number (or validates the manual document sequence number) for the transaction, the Journal Type field and the Sequence By options become unavailable.
To define journal codes:
Use the Journal Code page (JRNL_CODE) to define journal codes, specify sequence ranges, and determine how document sequence numbers are assigned for each journal code. (Navigation: Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Journal Code)
Enter a Journal Code.
Select a Journal Type to define the category of financial transaction to which the journal code belongs.
The Sequence By option that you defined for the selected journal type appears.
Note: The Sequence Range field and Document Sequencing Type options are available on this page only if you specified journal code level sequencing on the Journal Type page. When you first set up a journal code, all fields on the page are available. Once you enter a transaction record for this journal code, and the system assigns a document sequence number (or validates the manual document sequence number) for the transaction, the Journal Code, Journal Type, Sequence Range, and Document Sequencing Type options become unavailable for entry.
To define document types:
Use the Document Type Template page (DOC_TYPE_TMPL) to activate document sequencing for PeopleSoft Asset Management. (Navigation: Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Document Type Template)
Enter a Document Type that represents the business purpose of a financial transaction.
Select a Journal Code with which you associate the document type.
The Journal Type and the Sequence By option that were defined for the selected journal code appear.
Note: The Sequence Range field and Sequence Type options are available only if you specify document type level sequencing on the Journal Type page. When you first set up a document type, all fields on the page are available. Once you enter a transaction record for this document type, and the system assigns a document sequence number (or validates the manual document sequence number) for the transaction, the Document Type, Journal Code, Sequence Range, and Sequence Type options become unavailable.
The system assigns document sequencing field values for accounting entries in different ways. If you post a document, and the system creates accounting entries, the system treats document sequencing field values in one of the following ways:
For initiating (anchor) business unit accounting entries, the system carries document sequencing field values forward to the accounting entries and the Journal Generator process carries those field values to the journal lines.
Interunit transactions are treated as separate documents — one for each business unit. Each document has its own document type and document sequence number. The system leaves the document sequencing field values blank for the interunit accounting entries (those entries belonging to other business units than the anchor business unit).
The Journal Generator populates these fields with different values than the anchor business unit based on the document type that is defined in the Journal Generator template.
Defining Document Sequencing Options for Journal Generator Templates
The document type is stored in subsystems at the accounting line level. PeopleSoft General Ledger, however, stores the document type at both the journal header and journal line level.
The journal line document type always inherits the subsystem document type except when summarizations are involved, in which case the document type is left blank.
The Journal Generator process enables you to specify multiple document types for each journal template for accounting entries that share the same business unit, ledger group, journal template, and accounting date. The Journal Generator process then creates journals based on the document type value on the subsystem accounting entries.
For PeopleSoft applications that generate accounting entries, the document type value in the journal header is based on how you set up the Journal Generator Template. You can:
Leave the Document Type Mapping fields blank on the Journal Generator Template - Defaults page and Journal Generator assigns the Default GL Document Type value that you enter on the same page.
Refer to Journal ID 001 in the example that follows.
Retain the subsystem document type values in the Journal Header. You must map each subsystem document type with itself.
Refer to Journal ID 002 in the example that follows.
Replace the subsystem values with new values for GL or summarize the entries. Map each source document type with a GL document type.
If a source document type is not mapped, the value in the Default GL Document Type field is used. Refer to Journal ID 003 and 004 in the example that follows.
Leave the Default GL Document Type field blank.
An error is created when the journal is generated if the business unit is enabled for document sequencing. You can then correct the error by entering the document type manually on the Journal Header page.
See Understanding Document Sequencing.
See Journal Generator Template - Defaults Page.
This example illustrates journals that are created when a subsystem posts accounting entries where you mapped the document types of the subsystem to corresponding general ledger document types:
BU |
Ledger Group |
Accounting Date |
Subsystem Document Type |
Account |
Amount |
---|---|---|---|---|---|
FRAE1 |
ACTUALS |
May 1, 2005 |
AP1 |
200000 |
EUR 500 |
FRAE1 |
ACTUALS |
May 1, 2005 |
AP1 |
400000 |
EUR – 500 |
FRAE1 |
ACTUALS |
May 1, 2005 |
AP2 |
200000 |
EUR 100 |
FRAE1 |
ACTUALS |
May 1, 2005 |
AP2 |
400000 |
EUR –100 |
FRAE1 |
ACTUALS |
May 1, 2005 |
AP3 |
200000 |
EUR 50 |
FRAE1 |
ACTUALS |
May 1, 2005 |
AP3 |
400000 |
EUR –50 |
FRAE1 |
ACTUALS |
May 1, 2005 |
AP4 |
200000 |
EUR 300 |
FRAE1 |
ACTUALS |
May 1, 2005 |
AP4 |
400000 |
EUR –300 |
The Journal Generator process creates the following journals:
Journal ID = 001, Doc Type = GL1 (value entered in the Default GL Document Type field where the Document Type Mapping field values are left blank on the Journal Generator Template - Defaults page) consists of accounting entries:
BU
Ledger Group
Accounting Date
Journal Header Document Type
Account
Amount
FRAE1
ACTUALS
May 1, 2005
GL1
200000
EUR 500
FRAE1
ACTUALS
May 1, 2005
GL1
400000
EUR –500
Journal ID = 002, Doc Type = AP2 (AP2 mapped to AP2 in Journal Generator Template - Defaults page) consists of accounting entries:
BU
Ledger Group
Accounting Date
Journal Header Document Type
Account
Amount
FRAE1
ACTUALS
May 1, 2005
AP2
200000
EUR 100
FRAE1
ACTUALS
May 1, 2005
AP2
400000
EUR –100
Journal ID = 003, Doc Type = GL2 (AP3 mapped to GL2 in the Journal Generator Template - Defaults page) consists of accounting entries:
BU
Ledger Group
Accounting Date
GL Document Type
Account
Amount
FRAE1
ACTUALS
May 1, 2005
GL2
200000
EUR 50
FRAE1
ACTUALS
May 1, 2005
GL2
400000
EUR –50
Journal ID = 004, Doc Type = GL3 (AP4 mapped to GL3 in the Journal Generator Template - Defaults page) consists of accounting entries:
BU
Ledger Group
Accounting Date
GL Document Type
Account
Amount
FRAE1
ACTUALS
May 1, 2005
GL3
200000
EUR 300
FRAE1
ACTUALS
May 1, 2005
GL3
400000
EUR –300