...
UPDATE SM_Jobs SET JobNo = RIGHT('0000000000' + JobNo, 6)
UPDATE SY_Numbers SET LastInvoiceNo = RIGHT('0000000000' + LastInvoiceNo, 6) WHERE Description = 'ServiceManagerJobNo'
Example changing Work Orders numbers to 8 characters
UPDATE BM_WorkOrder SET WorkOrderNo = RIGHT('0000000000' + WorkOrderNo, 8)
UPDATE SY_Numbers SET LastInvoiceNo = RIGHT('0000000000' + LastInvoiceNo, 8) WHERE Description = 'WorkOrderNo'
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...