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
- Dyn365GP1 May 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Approaches to Configuring a New Company
- Dyn365GP30 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Company
- Dyn365GP29 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Refresh an Environment
- Dyn365GP26 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time