I have been experiencing erros of consistency in the stock_quant table. Is there a possibility to regenerate the table, from the stock_move_line table? Is there a python script or a call to some model that do this?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- إدارة علاقات العملاء
- e-Commerce
- المحاسبة
- المخزون
- PoS
- المشروع
- MRP
لقد تم الإبلاغ عن هذا السؤال
2
الردود
8593
أدوات العرض
Here is the script, Sorry for the late response:
It is good to know that someone has the same problem as me, because odoo support, did not solve this case.
Here is the main script: https://github.com/hydrosIII/odoo12-stock-correction
The script installss as a module and adds a cronjob in odoo. You can configure this job to run when you want. The script in my database takes all night to run, so we have another module that just checks quicky and depends on this script. This other one runs daily. The difference is that the first one checks all the database and all the dates. The second just checks the new bad recent entries.
https://github.com/hydrosIII/odoo12-stock-correct-short
THANK YOU VERY MUCH
Hi there, we're experiencing the same problem, did u find the root cause of the issue?
هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!
أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!
تسجيل| المنشورات ذات الصلة | الردود | أدوات العرض | النشاط | |
|---|---|---|---|---|
|
1
نوفمبر 24
|
3663 | ||
|
2
أغسطس 24
|
6366 | ||
|
3
سبتمبر 19
|
4864 | ||
|
2
مارس 25
|
2525 | ||
|
2
أكتوبر 24
|
3331 |
Hi,
Have you found something ?
Hi, we have generated a custom script, that installs as a custom module that runs once a month. If you are interested I can give you the script.
Regards.
Hi, thank you for your quick reply.
That would be great! Can I ask you why you need to run it every month? Have you found what messes with stock.quants ?
Regards
Hi, we have the same case, just one question, after the script do you have faced the same problem ?