I've used this approach as well before @zengs and it's been very helpful.
z
zengs
07/25/2019, 2:49 PM
oh i didn't think about calculating available qty, thats clever
zengs
07/25/2019, 2:51 PM
i ended up playing with the date filter on the inventory valuation report until i found the relevant ones. we had a customer that wanted to know the -exact- day her item became out of stock
a
al3xicon
07/25/2019, 2:53 PM
That's a bit more manual but definitely works!
m
michoel
07/25/2019, 11:35 PM
Was on mobile before so I couldn't upload a screenshot. Here is how it looks.