Hello I need to have the stock on a past date, i need to sum and rest (incoming and outgoing) stock movements in order to get stock on a past date. I have all the movements but i need any way to agregate the movements prior to a date to get the stock in our plant in the selected date. Example:
1/1/2020 - brick initial stock: 0
1/2/2020 - incoming brick + 10
1/3/2020 - incoming brick + 10
1/4/2020 - incoming brick + 10
If i ask for stock on 20/3/20 i should get 20
Current stock is 30.
Any help? thanks.