Inventory Adjustment Duplicating Count

Question

I'm having an issue where I've exported my products from the Inventory Valuation page. I've made several hand count adjustments and then tried uploading the document. Once I upload the document it shows two separate lines in the inventory adjustment page for each product. One was the original quantity with nothing in the counted quantity and the other line has the original quantity and my counted quantity.

When I Select all and apply all it combines the original quantity and my counted quantity

Binkal Vadaliya (biva) · Answer

Hello,
If you want to make changes to an existing inventory adjustment line, you need to add the External ID of the inventory adjustment and update the Counted Quantity. Then, import it back to merge with the existing line. If you upload the inventory adjustment without including the external ID, it will create a duplicate line.
You can also refer to a test case video:
https://drive.google.com/file/d/1kO4P3OAalv89-n4yKNCxJ-V8TJ614WCO/view [1]
Have a great day!

[1] https://drive.google.com/fi

product_id/product_variant_id/id	location_id	quantity	inventory_quantity
__export__.product_product_30787_c5b169ec	WH/Stock	2.00	100.00
__export__.product_product_30788_23c6ca4f	WH/Stock	4.00	100.00
__export__.product_product_30789_c13cc2b7	WH/Stock	2.00	100.00

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Back Date Inventory adjustment excel import Ratkaistu InventoryAdjustment	1 heinäk. 25	1555
Inventory Adjustment page is Blank \| Would like to manually edit inventory numbers for initial count InventoryAdjustment	2 kesäk. 25	1870
Odoo Enterprise 16 Inventory Adjustment Set to ZERO Products in Locations Ratkaistu InventoryAdjustment	2 jouluk. 24	4802
beginning inventory manual / odoo 15.2e Ratkaistu InventoryAdjustment	1 heinäk. 22	3299
Inventory Adjustments - Importing File Ratkaistu InventoryAdjustment V18	3 syysk. 25	2277

Tämä kysymys on merkitty

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