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 Microsoft Dynamics GP through eConnect.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP24 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
- Dyn365GP23 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
- Dyn365GP22 April 2024Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (May-Jul 2024) from MADIC dynamics
- Dyn365GP22 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment