Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
InventoryAdjustment
2 Odpowiedzi
3935 Widoki
Awatar
Neto

I have Products A1, A2, A3, with Internal Reference for A1 as 111, A2 as 222, A3 as 333. These three products are located in Rack 1, Rack 2, Rack 3, respectively. In Odoo Inventory Adjustment Screen, the three products shows "Available Qty" and "Counted Qty" as "1". I want to use an Excel file to upload to Odoo and set the three products to ZERO (0) in the mentioned rack locations.


I tried the standard Odoo Inventory Adjustment Template setting column headers QUANTITY and Counted Quantity to ZERO. After Uploading, still the Available and Counted shows as "1". WHY???


Next I tried to add the location WH/Stock/Rack 1 to Rack 3 under column header LOCATION. I set to ZERO the Available, Counted and Quantity column headers. Under PRODUCT Header, I placed [111] A1, [222] A2, and [333] A3.


But still the quantity for A1, A2, A3, is still 1. WHY???

Awatar
Odrzuć
Awatar
Leonardo L
Najlepsza odpowiedź

To get what you need, it is important to know that any data import must first export the correct fields, in this particular case always export the external IDs.

We select the products to adjust and look for the Export option:


https://ibb.co/TmnjQ4j


We locate and select the option to export compatible with import


https://ibb.co/Dt1bzP0


And we would select the fields, the only one we require is the counted quantities field, the location and product field will only serve as a reference.


https://ibb.co/n1XZ85Z


I offer you an example with different locations of the same product, it is important that you do not delete the ID column since it is important.


https://ibb.co/6N3qYwN


we modify the quantity to 0


https://ibb.co/9HNhXh8


And it's just a matter of importing the data.


It is important to deselect the location and product fields as they are not useful


https://ibb.co/s9ZFGcH


And we already have the products counted, it's just a matter of applying them.


https://ibb.co/qpY6tcJ

Awatar
Odrzuć
Awatar
Lars Aam
Najlepsza odpowiedź

A little variation of the explanation from Leonardo:

Go to Inventory->Operations->Inventory Adjustment.

Set filter for the products / Locations you want to count.  Select all. Go to Action Export to Excel with parameter "I want to update".  Then you get the xml ID field that identify each record for your upload.

In  Excel, modify the qty to actual count.  Go to inventory favourites Import.  Upload file.  Make sure the qty field is set to update Counted Quantity.  

After upload set filter to To Apply.  Press Apply all.  You get a pop up to enter a reference. 

Awatar
Odrzuć
Tarik Ibrahim

Thanks Lars,Your solution worked for me on Odoo 16

Powiązane posty Odpowiedzi Widoki Czynność
Back Date Inventory adjustment excel import Rozwiązane
InventoryAdjustment
Awatar
Awatar
1
lip 25
623
Inventory Adjustment page is Blank | Would like to manually edit inventory numbers for initial count
InventoryAdjustment
Awatar
Awatar
Awatar
2
cze 25
1190
Inventory Adjustment Duplicating Count
InventoryAdjustment
Awatar
Awatar
1
maj 24
1563
beginning inventory manual / odoo 15.2e Rozwiązane
InventoryAdjustment
Awatar
Awatar
1
lip 22
2542
Inventory Adjustments - Importing File Rozwiązane
InventoryAdjustment V18
Awatar
Awatar
Awatar
3
lip 25
1070