ccpete2d 7/29/2018 11:02:23 PM

Raw Materials Days On Hand Reporting

I've been trying to find a way to create a report of the current Days on Hand for all Raw Materials in the BoM (Including Alternates and different levels) for items required for MOPs.

I'm not having much luck creating this myself I am very familiar with SQL Querying, but not so much with inline table valued functions. So something with CTE's may be preferrable.

Any direction or advice is greatly welcome.

Version: GP 2015
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3