...
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. Compare the following screen with the one above to see the change after the script was run.
UPDATE BR_Main SET BankRecNo = RIGHT('0000000000' + BankRecNo, 10)
UPDATE SY_Numbers SET LastInvoiceNo = RIGHT('0000000000' + LastInvoiceNo, 10) WHERE Description = 'GLReconciliation'
Related articles
...