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
Ranger 2/5/2013 10:47:47 AM

Get next timesheet number


i need to get the next timesheet number, but am unable to figure out where to get it from.

there is a dd article that explains how to do this, but i find it hard to believe i have to create a stored procedure to do this.  i would think there is already one to get the next ts number.

i suppose i could just query the table pa timesheet history tables, get the max number and do my own increment, but i would rather use a built-in function from gp to do it.



Version: GP 2010
Section: .NET Development, Dynamics GP, eConnect

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables