Syndicate
Home arrow Sun Documentation arrow General Ledger arrow Automatic Sequence Numbers (LSS)
Automatic Sequence Numbers (LSS) PDF Print E-mail
User Rating: / 0
PoorBest 
Sun Documentation - General Ledger
Article Index
Automatic Sequence Numbers (LSS)
Page 2
Page 3
Introduction
Ledger Sequence Numbers are applied to transactions to enable users to produce a sequenced listing of transactions and groups of transactions, such as IVA reports required by Italian tax authorities, using Daybook Listings.
Two types of sequence numbers can be maintained: transactions sequence numbers and daybook sequence numbers. The sequence numbers generated for these transactions are maintained in two analysis dimensions identified in Ledger Setup. These are Transaction Dimension and the Daybook Dimension.
Discuss in forum
Separate series of transaction sequence numbers can be generated and assigned to different types of transactions. For example, you might wish to assign one set of numbers to cash receipts transactions and another set to ledger revaluation journals.
The transaction sequence code you define is used as the prefix for each sequence number. For example, if the series of numbers required for cash receipt transactions is identified by transaction sequence code CRJ, the sequence numbers generated are CRJ1, CRJ2 etc.
For each transaction sequence code, you can choose an update sequence to control how the sequence numbers are assigned i.e. Manual, Automatic, Date Control or Entry. If you select Entry, any transactions that are deleted between entry and posting lose their associated sequence numbers. SunSystems does not reuse any numbers that are excluded from the sequence in this way. You can make manual corrections in Ledger Entry or Account Allocation.
The sequence number itself can include a maximum of seven digits. The number of digits in the sequence number itself (which appears after the prefix) depends on the overall length of the analysis dimension code.
Understanding Transaction Sequence Numbers
Transaction sequence numbers can be defined and assigned automatically to transactions when they are posted to Financials. A registration date can also be assigned automatically to the transactions at the same time as a transaction sequence, if required.
The transaction sequence number that is assigned to each transaction is stored in the analysis dimension identified as the Transactions Dimension on Ledger Setup (LS).
A transaction sequence number consists of two parts: a sequence number code followed by a sequential number.
For example, the following transaction sequence numbers might be assigned to consecutive cash receipt transactions: CRJ1, CRJ2, and CRJ3. In this case CRJ is the sequence number code and the numbers 1, 2, 3 are the sequence numbers.
Sequence number codes and their numbering requirements are defined using Ledger Sequences Setup (LSS).
Sequence Number Codes
A sequence number code identifies a set of transaction sequence numbers. Separate sets of transaction sequence numbers can be generated and assigned to different types of transactions. For example, you might want to assign one set of numbers to cash receipt transactions and another set to ledger revaluation transactions.
A sequence number code can include up to five characters.
Sequence Numbers
The sequential number portion of the overall transaction sequence assigned to a transaction is determined by the Update Sequence option on Ledger Sequences Setup. The following options are available:
Manual - this forces the user to assign the number manually to each new transaction.
Automatic - this updates and assigns the next sequential number automatically to each new transaction (the previous number used is held in the Transaction Dimension).
Entry - this updates and assigns the next sequential number automatically but also displays the number during Ledger Entry (LE). This allows you to copy the number to the source document for cross referencing purposes.
Date Control - this assigns a registration date in addition to a sequence number.
The number can include a maximum of seven digits. However, the number of digits available depends on:
the length of the analysis dimension being used to store the sequence numbers - this is the dimension identified in the Transaction Dimensions field in Ledger Setup (LS)
and
the number of characters in the Sequence Number Code in Ledger Sequence Setup (LSS).
For example, if the length of the analysis code has been defined as 7 and you define a sequence code of CRJ, then the sequence numbers are four digits long.


Latest News
Forum Topics
Latest Articles
 
 
Popular Articles