How print "stock in a certain day" report?

Question

I want to know (and print as a report) the sock in a certain day. For ex. 2013.02.28.
I see that if I go to Warehouse->Locations and select Stock, from Print menu I have Location Inventory Overview, but this shows the stock in this moment.
But I need in a specific date.
Anybody knows a solution?
Thanks, TArpi

Dharmesh Rathod · Accepted Answer

Hi,

Warehouse -> Inventory Control -> Location Strucure.

When you click on any location, it will open popup with some parameters.
You can select 'Analyse Type' = Analyse a Period.

Hope it will help you.

Email : info@acespritech.com
Skype : acespritech
Blog : acespritechblog.wordpress.com

patrick · Answer

I do not know if there is a date field inthe table stock.move or other other related tables.

You have to create your own module, which loops though all the stock.move, and accept only the moves which are on or before the given date.

Related Posts	Odgovori	Prikazi
How to solve this error Field `show_check_availability` does not exist ? stock inventory	0 jul. 24	2904
How to prefill one2many records stock inventory	1 mar. 24	3077
Out of Stock Solved stock inventory	4 feb. 24	6480
Available stock by the end of each month in each location (Stock History) stock inventory	1 jul. 23	3669
How to add production batch number in production not lot number and show in invoice stock inventory	1 maj 23	4437

This question has been flagged

Enjoying the discussion? Don't just read, join in!