SQL Query to get First Level Items from Microsoft Dynamics GP Manufacturing BOM

We’re currently doing some work for a client using the Manufacturing module of Microsoft Dynamics GP and I’ve been involved in the periphery of the manufacturing element while focusing on the financial and distribution parts, but have been assisting with some reporting items. One of them was to help create a report on the Mfg BOM showing only the first level items.

The below script, against…

Continue Reading Ian Grieve’s Article on their blog

SQL Query to get First Level Items from Microsoft Dynamics GP Manufacturing BOM

We’re currently doing some work for a client using the Manufacturing module of Microsoft Dynamics GP and I’ve been involved in the periphery of the manufacturing element while focusing on the financi‎…

Blog Syndicated with Ian Grieve’s Permission