Assigning transaction sequence numbers to transaction types

Once you have defined a transaction sequence code using Ledger Sequences (LEQ), you can assign the number series to the type of ledger transactions you want to be sequenced. There are two ways of doing this, depending on the type of transaction.

For user generated journals, you assign the sequence number code to a type of journal using Journal Types (JNT).

Note: When the journal is posted using Ledger Entry (LEN), the transaction sequence number is displayed on the message line at the bottom of the form alongside the journal number if it is generated using the Entry option in Ledger Sequences (LEQ). If a registration date is assigned this is also displayed.

For system generated journals, you assign the sequence number code to the relevant System Codes field on the Sequence Dimensions tab in Ledger Setup (LES) for these functions:

  • Payment Run
  • Payment Collection Run
  • Transaction Matching
  • Payment Voiding
  • Ledger Revaluation
  • Post Withheld Taxes
  • Depreciation Calculation
  • Asset Disposal

If you are required to produce an ESL for European tax reporting, or a 1099 for US tax requirements, you can also use these transaction sequence number codes to identify the various types of transaction.

Assigning sequence numbers to provisional postings

If provisional postings are optional or mandatory, then transaction sequence numbers can be applied either when transactions are posted as provisional postings, or when they are posted as permanent postings. This is determined by the Hard Posting Only option in Ledger Setup (LES).

Note:  If sequence numbers are being assigned to permanent postings only, Tax Reporting assigns the numbers when a Final run of a tax report is produced. This is because the Final run posts the provisional postings as permanent postings. Similarly, if a definitive Daybook Listing is used to make the provisional postings permanent, the transaction sequence number is assigned at this stage.