+4I’m looking to create a GI with a item list and and a sum of how many days this item was at 0 qty in the warehouse in the past 365 days.
Where do I start?
I thought maybe using the INItemSiteHistDay table would be the way to go but I’m just not sure where to go from there.
Best answer by lauraj46
Hi
You could the DateInfo table as a starting table to get the 365 dates. The tricky bit after that is to get the total item quantity by warehouse (possibly with multiple locations) for any particular date.
The INItemSiteHistDay table only contains records for the dates where there is a change.
Maybe someone else knows of a different DAC that already has the daily quantities. In that case you should be able to do this in a GI. Otherwise, I think would be easier and more efficient in a report. There you can sort the InItemSiteHistDay records by date and use variables to do some calculations.
A basic design might be something like this:
Hope this give you some ideas!
Laura
+8Hi
You could the DateInfo table as a starting table to get the 365 dates. The tricky bit after that is to get the total item quantity by warehouse (possibly with multiple locations) for any particular date.
The INItemSiteHistDay table only contains records for the dates where there is a change.
Maybe someone else knows of a different DAC that already has the daily quantities. In that case you should be able to do this in a GI. Otherwise, I think would be easier and more efficient in a report. There you can sort the InItemSiteHistDay records by date and use variables to do some calculations.
A basic design might be something like this:
Hope this give you some ideas!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
