DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Simon 10/16/2018 3:20:11 PM

GetNextNumber

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

Increment a document number:

This routine takes the input number and increments it by 1

Document numbers commonly are in the format of a few alpha characters followed by a number --like 'ORD0001' or 'PO0001'

This routine will strip off the trailing numbers, increment, and then put the two parts back together again

Version: Unknown or N/A
Section: SQL Scripts