I need to end up with a record showing inventory position for every day so I can get a true count of cases in inventory each day -- currently the inventory count is way off, because if there was no transaction on that day, no inventory cases show for the item.
Right now I see 2 cases of widgets in inventory on Jan 1st, and 1 case on Jan 4 -- meaning I sold one on the 4th -- but need to be able to see that I also had 2 cases on the 2nd and the 3rd.
here's a snippet of what I have -- you can see that I had 10 cases of this item on 9/28, and went down to 8 cs on 10/4. This means that I had 10 cases on each day in between. Just looking for a way to fill in the blanks.