How to Define Journal Sequences Manually

You can manually define sequences to generate numbers for journal entries. Use the Manage Accounting and Reporting Sequences task to search, create, and update sequences, sequence versions, and sequencing assignments.

You can also create journal sequences using the Rapid Implementation process. The process creates and assigns the sequences.

Sequences

Create, update, and search for sequences from the Sequences tab on the Manage Accounting and Reporting Sequences page. To define a sequence, enter a unique sequence name and description. Create at least one sequence version to complete the sequence. The sequence version indicates the series of sequence numbers to be used and the effective date range of the series.

When you create a sequence version, you specify the:

Effective Start Date: The default date is the current date. The date can be set to any date in the past or future.
Effective End Date: The date when the sequence should be disabled.
Initial Number: A positive integer that's the starting number of the sequence. The number increments by one for each accounting entry.

Note: The Edit Sequences page displays the last sequence number used for each sequence version.

Sequencing Assignments

After creating your sequences, assign them various criteria to specify when the sequences are generated. Use the Sequencing Assignments tab on the Manage Accounting and Reporting page to search, update, or create sequencing assignments.

The following table describes the fields on the Sequencing Assignments tab.

Field	Description
Ledger	The ledger for which the journal entries must be sequentially numbered or that contains the legal entity.
Legal Entity	The legal entity for which the journal entries must be sequentially numbered. The Legal Entity field appears when you set your Sequence By ledger option to Legal Entity.
Journal Entry Type	Select whether general ledger or subledger entries are being sequentially numbered.
Sequencing Event	The event which triggers the sequence numbering,
Sequence Validation Date	The date when generating a sequence number. This date is used to determine if a sequence is available and the sequence assignment is active.
Require Assignment for All Journals	If you select this option, you must explicitly define valid Sequence Assignments, Exceptions, or Exclusions for all journal entries.
Status	Indicates if the assignment is enabled or disabled.

The following table outlines some of the different combinations of journal entry type, sequencing event, sequence validation date, and journal sorting date. For each combination, the table also indicates whether the sequence is an accounting or reporting sequence.

Journal Entry Type	Sequencing Event	Sequence Validation Date	Journal Sorting Date	Remark
General Ledger	Posting	Accounting Date	Accounting Date	Accounting Sequence
Subledger	Subledger Accounting	Accounting Date	Accounting Date	Accounting Sequence
General Ledger	Period Close	Accounting Date	Accounting Date, or Completion or posting date	Reporting Sequence
General Ledger	Period Close	Reference Date	Reference Date	Reporting Sequence
Subledger	Period Close	Accounting Date	Accounting Date	Reporting Sequence
Subledger	Period Close	Reference Date	Reference Date	Reporting Sequence

Tip: For reporting sequences, you can specify fiscal balancing segment values to specify what balancing segment values to use with reporting sequences for period close. You can deselect the option to exclude balancing segments with management type journals or nonfinancial journals such as, statistical journals.

The following figure shows the Fiscal Balancing Segment Values section from the Sequencing Assignment page. The section includes the segment value, description, and an indicator for whether the segment value is selected for use with the reporting sequence.

This figure shows the Fiscal Balancing Segment Values section of the Sequencing Assignment page.

Sequencing Assignment Details

The following table lists and describes the fields in the Sequences section on the Create Sequencing Assignment page.

Field	Description
Status	Status of the assignment such as New or Used.
Priority	Priority of the exception. This option is inactive unless you define an exception.
Sequence Name	Name of the sequence to be assigned. A blank indicates the entries must not be sequenced.
Start Date	Define the effective start date for the sequence assignment.
End Date	Define the effective end date for the sequence assignment.
Journal Source	Select the journal sources from the list to be sequentially numbered for a sequence event.
Journal Category	Select the journal categories from the list to be sequentially numbered for a sequence event.
Accounting Event Type	Select the accounting event types to be sequentially numbered (only for subledger entries).
Accounting Entry Type	Select the accounting entry types to be sequentially numbered (only for subledger entries).
Document Category	Select to group transactions assigned to the sequence.

The following figure shows the Add Exception and Add Exclusion buttons on the Create Sequencing Assignment page.

This figure shows the Add Exception and Add Exclusion buttons on the Create Sequencing Assignment page.

Use the following buttons to add a row:

Add Exception: When you create an exception, the priority value is always one more than the highest number in the Priority field. Use exceptions to assign different sequences to certain journal sources, journal categories, accounting event types, or accounting entity types. For example, you want to include all journal sources, but assign a different sequence for your Expense journals.
Add Exclusion: Create exclusions to exclude specific journal sources, journal categories, accounting event types, or accounting entity types. For example, you want to exclude journal sources and categories containing management or statistical accounts that don't impact financial results.