Announcements
No record found.
Can anyone explain the contents of the Item Daily Quantity table? I was hoping it would contain item balances by site, by day...but in looking at the data it doesn't seem to be the case.
*This post is locked for comments
Hi,
Check Victoria's blog. Here is link for Inventory Qty on hand: victoriayudin.com/.../sql-view-for-inventory-quantities-on-hand
This may give you some lead to create your report.
Thanks
Sandip
That won't help...hers will only show the current balances. I was hoping to be able to retrieve historical balances without going through all the gyrations done by the Historical Stock Status report. The ItemDailyQuantity table in the Analysis Cubes data warehouse looked like it might be saving the item balances on a daily basis, but closer inspection shows that's not the case.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
talty09 2
Anthony Beatty 2
CP04-islander 1
