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 Options - Overall Page

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.

Document Sequence Range Page

SEQ_RANGE

Define the sequence range for your documents. You can define a range that spans yearly, monthly, daily, or any other desired increments.

Journal Type Page

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.

Journal Code Page

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.

Defining Document Sequencing

Defining and Assigning Document Types

Document Type Template Page

DOC_TYPE_TMPL

Activate document sequencing for PeopleSoft Asset Management.

To specify a document sequence range:

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

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

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

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

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

  2. Enter either a numeric or character value to represent the journal type.

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

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

  2. Enter a Journal Code.

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

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

  2. Enter a Document Type that represents the business purpose of a financial transaction.

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