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