Dynamics 365 Great Plains
VBA Snippets: Adding an SQL ODBC Connection in Microsoft Dynamics GP
This post is part of the series on VBA Snippets. There is an ADO connection available to VBA within Microsoft Dynamics GP which you…
Tag: SQL
Dynamics 365 Great Plains
SQL Query to get First Level Items from Microsoft Dynamics GP Manufacturing BOM
We’re currently doing some work for a client using the Manufacturing module of Microsoft Dynamics GP and I’ve been involved in the periphery of…
Dynamics 365 Great Plains
SQL View to Return Microsoft Dynamics GP Item Number Split by Hyphens
As with most of the other views I have posted, this is one I have written a few times over the years and am…
Teams
Creating an Azure SQL Private Link Endpoint and managing DNS
Just a quick blog to capture the stages of creating an Azure Private Endpoint that represents an Azure SQL Database Server in order that…
Dynamics 365 Great Plains
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…