SQL View to Return Accounts Assigned to Inventory Item Classes in Microsoft Dynamics GP

Posted By Ian Grieve on 7 Jul 2022 in Dyn365GP

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