Ir al contenido
Se marcó esta pregunta
1 Responder
2353 Vistas
Avatar
Jonathan Wilson

This may be an old-fashioned way to do stock takes but some customers still do this - Scenario: 

1) Print off stock-taking sheets by location, 

2) Operator manually counts and enters the results on the printed sheets,

3) The results are entered into a spreadsheet, and 

4) the results are imported into Odoo. 

That last step used to be easy in older versions of Odoo that batched stock-takes, but it looks like it is impossible in V16 as the import just creates new records without the imported count quantity, and it is very difficult to identify the new records. Maybe I am missing something fundamental in Odoo's model? Is anyone else using this scenario?

Avatar
Descartar
Avatar
Paresh Wagh
Mejor respuesta

Hi Jonathan:

Export the Inventory Adjustment rows (Inventory > Operations > Inventory Adjustments) and select the I want to update data checkbox as indicated in the screenshot below. This will export the rows with their "external ids". Update the quantity in this spreadsheet and reimport the data (just the quantity). Odoo will update the quantities on the existing rows instead of creating new rows.


Avatar
Descartar
Jonathan Wilson
Autor

Thank you for your reply.

If you attempt to import the ID you get an errors:
"Unknown error during import: <class 'odoo.exceptions.UserError'>: Quant's editing is restricted, you can't do this operation. at multiple rows
Resolve other errors first

The results can be imported without the ID and appears to work.
I think the way it might work for the above scenario (which is pretty simple as it has no locations) is:
1. Export the products to do a stock take on from the products form and print the spread sheet
2. Give the print count sheet to the operators and get them to fill out the counted quantity
3. Import the figures into Inventory Adjustments
4. "Apply all"

I still have questions: why no stock freeze while the stock take is being done? I understand the stock adjustment is done based on the stock take date, however, the accounting date seems to have no effect.

All very confusing and the documentation does not help much.