This post is part of the series on VBA Snippets.
In yesterdays post, I covered adding an ODBC connection to Microsoft Dynamics GP VBA for use n windows or reports. The below is an example of a SQL query using the ODBC connection.
SOPType
and SopNUmber
(highlighted) are fields from a window added to the VBA.
This example retries a list of fields from the Sales Transaction Amounts Work…
Continue Reading Ian Grieve’s Article on their blog
VBA Snippets: Select Records from Microsoft Dynamics ODBC Connection
This post is part of the series on VBA Snippets. In yesterdays post, I covered adding an ODBC connection to Microsoft Dynamics GP VBA for use n windows or reports. The below is an example of a SQL query using the ODBC connection. SOPType and SopNUmber (highlighted) are fields from a window added to the VBA.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Specify Dimensions on Posted Entries Applications With Realized Gains or Losses