Ledger Sequence Numbering

You can choose to automatically generate and assign a unique sequence number to ledger transactions when they are processed by a particular function. This enables you to produce sequenced listings of transactions and groups of transactions, such as the IVA reports required by Italian tax authorities.

Three different types of sequence number can be generated and maintained:

  • Transaction sequence number - this is assigned to a transaction when it is posted by a particular posting function, for example, by Ledger Entry (LEN), Ledger Import (LIM), or a system posting function like Payment Run (PYR).
  • Daybook sequence number - this is assigned to a transaction when it is printed on the Daybook Listing (DYL), when this report is run with the Definitive Request option set to Yes.
  • Voucher number - this is assigned to a transaction either when entering the journal details, or when posting to the ledger. If you are using voucher numbering, several different voucher numbering sequences are all simultaneously maintained and incremented for each different journal class.

When one of these sequence numbers is assigned to a transaction, it is stored on the transaction itself, as follows:

  • The Transaction and Daybook sequence numbers are stored in analysis dimensions on the transaction. The analysis dimensions used are identified in Ledger Setup (LES). Transaction sequence numbers are maintained in the Dimension in the Transaction section, and daybook sequence numbers are maintained in the Dimension in the Daybook section in Ledger Setup (LES).
  • The Voucher number is stored in either the transaction reference field, or the second ledger reference field, as defined in Ledger Setup (LES).

There are several steps required to implement these ledger sequence numbering options.

Note:  These transaction sequence numbers are assigned to ledger transactions. They should not be confused with the transaction references that can be generated and assigned to selected documents, for example, payment documents or sales orders. For example, transaction references are used to assign cheque numbers to payment documents.