I was writing a report pulling data from the Inventory Control module of Microsoft Dynamics GP the other day and I needed to include the accounts assigned to the Item Classes. I’ve written this query before and, having a need for it again, I decided to create it as a separate SQL view in order to make it more easily reusable.
/*
Created by Ian Grieve of azurecurve|Ramblings of an IT...
Continue Reading azurecurve’s Article on their blog
SQL View to Return Accounts Assigned to Inventory Item Classes in Microsoft Dynamics GP
I was writing a report pulling data from the Inventory Control module of Microsoft Dynamics GP the other day and I needed to include the accounts assigned to the Item Classes. I’ve written this query before and, having a need for it again, I decided to create it as a separate SQL view in order to make it more easily reusable.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP2023.01.27SQL Scripts for Microsoft Dynamics GP: PO Receipt History View
Dyn365GP2023.01.27SQL View to Return the Accounting Period Starting and Ending Dates in Microsoft Dynamics 365 Business Central
Dyn365GP2023.01.26SQL Scripts for Microsoft Dynamics GP: SQL Trogger on PO invoice Insert to Change GL posted Date
Dyn365GP2023.01.26Inactive OneDrive Account Cannot be Removed