Micah
4Penny.net
Points: 7659

3/11/2013 11:38:11 AM

SQL - Script to increment a document number

As much as possible, I use the 'GetNext' eConnect procedures and methods to get the next document number in Dynamics. But it's not always available, and they're not available for all modules.

This article is a script that takes an alphanumber document number as a parameter and increments it.

For example, the current document number might be 'TSFR002345', this proc would increment that to 'TSFR002346'

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3