SQL Stored Procedure to Get the Next Microsoft Dynamics GP Sales Document Number

This stored procedure can be executed to generate the next sequential sales document number; this script was created to get the next sales invoice number for a transaction to be inserted into Microsoft Dynamics GP through eConnect. I write stored procedures as a wrapper around the eConnect stored procedure as we are often working with the clients IT department or a third party and this…

Continue Reading Ian Grieve’s Article on their blog

SQL Stored Procedure to Get the Next Microsoft Dynamics GP Sales Document Number

This stored procedure can be executed to generate the next sequential sales document number; this script was created to get the next sales invoice number for a transaction to be inserted into Microso‎…

Blog Syndicated with Ian Grieve’s Permission