SQL View to Return Microsoft Dynamics GP Item Number Split by Hyphens

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

SQL View to Return Microsoft Dynamics GP Item Number Split by Hyphens

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 N‎…

Blog Syndicated with Ian Grieve’s Permission