I’ve been organising a demo of software which can be used to produce documentation using data from Microsoft Dynamics GP and integrate it with data from other systems or network shares. I thought about a few ways of getting the Dynamics GP data and decided that a custom SQL view returning only the required information was the best way to go.
This view returns sales invoice lines and related…
Continue Reading Ian Grieve’s Article on their blog
SQL View to Return Sales Invoice Lines
I’ve been organising a demo of software which can be used to produce documentation using data from Microsoft Dynamics GP and integrate it with data from other systems or network shares. I thought about a few ways of getting the Dynamics GP data and decided that a custom SQL view returning only the required information was the best way to go.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP3 February 2024SQL Query on Matomo Database to Calculate the Number of Visits to Each Page
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use Virtual Tables to Expose More Business Central Data in Dataverse
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Work Orders in Field Service, Invoice Them in Business Central
- Dyn365GP2 February 2024In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location