Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME

Sign Up Now!Log In
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