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.