Has anyone played around with the inventory snapshot subject area? I'm trying to get the quantity on hand for the first day of the month over the last x months, but the Oracle filters/functions are making it... tricky. Fortunately, I can do average by month so I'm not data-less, but I really hate not figuring out a solution.
The core issue is that the system wants to sum up the months, not give me a first (or even last) day value.