This code will show how to get the next document number in a Integration Manager PA timesheet integration
There are two parts, the VBA code, and a stored proc that does the work.