Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Micah 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'
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