The unique numbering in all forms e.g. sales orders, bank reconciliations, creditor purchases is a alpha numeric field and display in the search screen in that order e.g. in an alpha numeric sort, 10, 11, 11001, 11121200 etc. displays before records starting with 2.
Step-by-step guide
...
| Warning | ||
|---|---|---|
| ||
Sound SQL skills are required to complete this task |
For the list of records to appear in a logical order (i.e. date of entry) leading zeroes need to be added to the batch or form unique number to facilitate that. The SY_Numbers table must also be updated to reflect the new number. Below is an example of updating the numbering for bank reconciliations.
UPDATE BR_Main SET BankRecNo = RIGHT('0000000000' + LastInvoiceNoBankRecNo, 10) WHERE Description = 'GLReconciliation'
UPDATE BRSY_Main Numbers SET BankRecNo LastInvoiceNo = RIGHT('0000000000' + BankRecNoLastInvoiceNo, 10) WHERE Description = 'GLReconciliation'
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...