An historical product stock report

Developing for Dolibarr
1

Hi All,

I want the ability to specify a date and get a look at what the stock looked like at that time. Any idea how I can proceed into this?

Can I use the llx_stock_mouvement table with the movement date to get this by filtering out movements after a certain date?

But not getting any clear way/view that on which stock basis I will calculate this thing.

Thanks & Regards
Saikat

2

hello, maybe you might try the zakat module on dolistore :wink:

1 Like
3

Hi @altatof

Thanks for your reply. Yes as per the module’s description in the Dolistore it will fulfill the purpose though when went to try that into their demo instance then it didn’t work and showed “This website or feature is currently temporarly not available or failed after a technical error.”

But that time I also saw one feature in Dolibarr v14 and that is “Stocks at date” which i think also will fulfill my purpose. I just wanted to know what was the stock at a specific previous date. Although I will have to do some check and test that will it really work for me or not.

Anyway thanks again.

Saikat

4

Good afternoon Saikat,

We corrected the demo.altairis.fr install (and even updated it in v16). Feel free to test again !

Thanks for your report.

5

Hi @altairis-noe

No problem.

Thanks

6

For each product, when you go to the “Stock” tab of a product, on the same line as “Physical stock” there is a clickable link “Stocks at date”

7

Hi @milenmk

Thanks for your reply. Actually the project where I need this feature is developed on Dolibarr v7 which I cant’s upgrade right now. So I am importing this feature from Dolibarr v14 or v16 to my project.

And yes I got that option under the Warehouses menu(left menu) under product module.

Regards,
Saikat