Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

SQL skills are required

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' + BankRecNo, 10)

UPDATE SY_Numbers SET LastInvoiceNo = RIGHT('0000000000' + LastInvoiceNo, 10) WHERE Description = 'GLReconciliation'

  • No labels