Skip to main content
Administrator Guide
Last Updated: 2024-09-20
Concept: Journal Sequencing in AP&C

Concept: Journal Sequencing in AP&C

You can enable journal sequencing in Adaptive Planning and Consolidation (AP&C) for a company and define the sequence generator rules. Workday uses the sequence generator rules to create sequence ID generators for unique, sequential, and gapless journal sequence numbers. Workday derives the sequence ID generators based on the source and accounting period of the journal.
You can sequence journals by
Accounting Date
or
Posting Date
. This sequencing method determines when Workday sequences your journals, and in what order.
Accounting Date
sequences your journals when you close a ledger period and sequences them based on the accounting date. For journals with an accounting date on the same day, Workday sequences the journals based on the business document sequence IDs, and then the transaction type.
Example: You create 3 journals with an accounting date of 11/06/2017. Workday sequences the journals based on the business document sequence IDs:
  • SUPINV-001
  • SUPINV-002
  • SUPINV-003
If the business document sequence IDs are undefined, Workday sequences by transaction type:
  • Customer Contracts
  • Payroll
Posting Date
sequences your journals when you post the journals based on the posting date.
To enable journal sequencing, the journal sequence
Start Period
and all subsequent periods:
  • Must be in
    Created
    ,
    Closed
    , or
    Not Available
    ledger period status.
  • Have no posted journals from the specified
    Start Period
    .
You can only disable journal sequencing for a company if:
  • You haven't used sequence ID generators to assign a sequence number to any journals.
  • You’ve deleted all sequence ID generators.