DARKF3D3 Posted May 13, 2014 Share Posted May 13, 2014 I need to know the total value of the in stock products, i see that i can do that in B.O. >> Stats, the problem is that i need to know the total value at a defined date (for example 2 month ago) and on that page i found only the actual value. There's no way to do that? I'm using PS 1.4.9 Link to comment Share on other sites More sharing options...
Dh42 Posted May 13, 2014 Share Posted May 13, 2014 There is not. I doubt that something custom could be written either since there is no column in the database that keeps track of dates when new stock was added. Link to comment Share on other sites More sharing options...
DARKF3D3 Posted May 14, 2014 Author Share Posted May 14, 2014 I need to find a way to obtain that information. A way could be take the actual ammount, decrease with all supplier invoices and then add the total order made between today and 2 month ago. The only problem is that i should add the net price, so no shipping and purchase price. It's possible to do this? Link to comment Share on other sites More sharing options...
Dh42 Posted May 14, 2014 Share Posted May 14, 2014 I mean anything is possible. best bet would be to export the database to excel and then try to figure it manually that way. Link to comment Share on other sites More sharing options...
DARKF3D3 Posted May 14, 2014 Author Share Posted May 14, 2014 I hope someone here could help me to understand how to get that data from database, because i have no idea how cai i do that. Link to comment Share on other sites More sharing options...
Recommended Posts