How to set up a date or period in a transaction reference
To set up part of the reference as a date, you must enter the following in the Value field:
- 1 - century
- 2 - year
- 3 - month
- 4 - day
- 5 - period
- 6- year of accounting period.
Example 1
Part | Type | Value | Delimiter | Length |
Part 1 | Date (and the year is 2010) | 2 | - | 2 |
Part 2 | Number Stream | SEQ (and the next number in the sequence is 123456) | 6 |
The next transaction reference produced is 10-123456.
Example 2
Part | Type | Value | Delimiter | Length |
Part 1 | Number Stream | SEQ (and the next number in the sequence is 32) | - | 2 |
Part 2 | Date (and the date is 20th April 2010) | 234 (that is, year, month, day) | 6 |
The next transaction reference produced is 32-100420.
Example 3
Part | Type | Value | Delimiter | Length |
Part 1 | Number Stream | SEQ (and the next number in the sequence is 32) | - | 2 |
Part 2 | Date (and the year is 2010) | 2 (that is, year) | / | 2 |
Part 3 | Date (and the month is April) | 3 (that is, month) | / | 2 |
Part 4 | Date (and the day is 20th) | 4 (that is, day) | 2 |
The next transaction reference produced is 32-10/04/20.
Example 4
Part | Type | Value | Delimiter | Length |
Part 1 | Journal Class (and the class used is BANKTRANS) | SEQ (and the next number in the sequence is 12) | - | 9 |
Part 2 | Date/Period (and the period is 012/2010) | 5 (that is, period) | - | 8 |
Part 3 | Voucher Number Stream | VSEQ (and the next number in the sequence is 37) | 4 |
The next transaction reference produced is BANKTRANS-2010012-0037.