Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Can you regenerate the stock_quant table

stock quantity Quantity on Hand stock.quant

2 Vastaukset

8620 Näkymät

Gabriela Aragón Zamorano

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?

Aïmane

Hi,

Have you found something ?

Gabriela Aragón Zamorano

Tekijä

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.

On 22/2/21 4:59, Aïmane wrote:

Hi,

Have you found something ?

Envoyé par Odoo S.A. utilisant Odoo.

Aïmane

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

Elvis Piobbico

Hi, we have the same case, just one question, after the script do you have faced the same problem ?

Gabriela Aragón Zamorano

Tekijä Paras vastaus

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

Walid Redwan

THANK YOU VERY MUCH

Giovanni Serra

Hi there, we're experiencing the same problem, did u find the root cause of the issue?

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to adjust On hand quantity on stock.quant Ratkaistu stock quantity Quantity on Hand stock.quant	1 marrask. 24	3703
Inventory system integration stock quantity stock_move Quantity on Hand	2 elok. 24	6384
The Product Creating Multiple Location Ratkaistu stock inventory quantity inventories Quantity on Hand	3 syysk. 19	4880
How to edit stock quants location? I messed up when importing Ratkaistu stock quants stock.quant	2 maalisk. 25	2545
Negative quantities on hand inventory quantity Quantity on Hand	2 lokak. 24	3352

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!