As with most of the other views I have posted, this is one I have written a few times over the years and am now posting it to make it easy to find next time I need it.
This view returns the Item Number from the Item Master (IV00101) table split into sections by hyphens. It assumes the item number has up to three sections, but can easily be extended.
With the view deployed, it can easily be…
Continue Reading Ian Grieve’s Article on their blog
https://www.azurecurve.co.uk/2021/05/sql-view-to-return-microsoft-dynamics-gp-item-number-split-by-hyphens/
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP15 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Enhancements to the User Experience
- Dyn365GP15 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Boost Productivity With the Modern Action Bar
- Dyn365GP14 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Experience the New Embedded AppSource Marketplace Page
- Dyn365GP14 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use Premium License to Sign In to Environment with Essentials Licenses