How Do I Calculate My Total Stock Value At A Specific Date?

Posted by El Presidente on January 30, 2006, 9:03 am

Please log in for more thread options

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.

Posted by Ivan Brebner on January 30, 2006, 5:21 pm

Please log in for more thread options

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

The Item movement report and the Item Value report.

> 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.

Posted by Mickie on January 30, 2006, 10:46 pm

Please log in for more thread options

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:

> 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.