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.
/*
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
Dyn365GP15 April 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Access Worksheet Pages from Mobile Phones
Dyn365GP15 April 2024Microsoft Excel Showing Formula Instead of Result
Dyn365GP12 April 2024VAT Bus. Posting Group Error in Get Shipment Lines in Microsoft Dynamics 365 Business Central
Dyn365GP11 April 2024Error Calculating Depreciation in Microsoft Dynamics 365 Business Central: “No journal lines were created”
