I'd like to be able to calculate how much stock I had at a paticular date/time in the past.
Eg. What was the value of stock I had on the 1st of January?
How can i do that?
Thanks,
Leigh.
How Do I Calculate My Total Stock Value At A Specific Date?
Jan 30, 2006
2 Replies
There is no direct report that can provide you with the stock on hand from a previous date.
But there are 2 reports whereby the difference will assist with what you are trying to achieve.
You can see all item movement for lets say now to last week and remove this value from the current item value 'should' in thery provide you with a previous date stock value.
Hope this helps.
Ivan
Do you have a database backup from that day? You can temporarily load it up, run your report and then close it.
"El Presidente" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required