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

客户关系管理
e-Commerce
会计
库存
PoS
项目
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

Inventory Adjustments - Importing File

InventoryAdjustment V18

3 回复

2276 查看

Angelina Moschella

When doing a stocktake you would want to use an import file as it will contain all the products and locations.

The import file only allows you to import the counted quantities.

The template that Odoo provides doesn't populate the quantity or the difference fields when you import the template, the user has to select the filed, but there is no Odoo field that matches with the template.

If you have done an adjustment to a product before, the next time you import the file for the same product it doubles up the quantity on hand value.

Example

In the Physical Adjustment screen I have the following

ProductA with a location of WH/Stock and a quantity value of 1

ProductA with a location of WH/Stock/AA001 and a quantity value of 2

In my Import File I have the following

ProductA with a location of WH/Stock and a counted quantity value of 0

ProductA with a location of WH/Stock/AA001 and a counted quantity value of 3

When I import the file and apply the adjustment, it doesn't not adjust the WH/Stock location that still has a quantity on hand value of 1, and the product for location WH/Stock/AA001 has now doubled.

Shouldn't the counted quantity adjust the quantity on hand value to what is in the import file?

How do you reduce the quantity on hand value, as ProductA should not have any quantity available within the WH/Stock location, via the import file?

Thanks

Angelina Moschella

编写者

This is the current Physical Adjustment screen

This is the Odoo Template File

When I import the template

Do I change this to the below 'Inventoried Quantity'?

When I import the file, it doubles up the quantity rather than reducing it.

Also didn't let me Apply the changes.

Chris TRINGHAM

You need to export the file with "I want to update data (import-compatible export)" selected. Then you can update the existing inventory balances. If you don't do that you are creating new records.

Chris TRINGHAM

最佳答案

When updating, you only need two columns - the Record ID and the quantity. If you include the user id, lot, product, date Odoo may give you errors because you can't update them.

Angelina Moschella

编写者

Yes this works.
However, if the product is not already in the Inventory Adjustments screen you have to add it first.
Odoo should list all items that are designated to a location so that it can be counted during the Stocktake process. If the product isn't in the Inventory Adjustment screen and during the stocktake process the user found that product and it is physically in the location, you would have to add it first and then do a bulk upload of all the other products for that same location.
To me it seems like a 2 step process, in my opinion when doing a stocktake you would want to do a bulk import for all products for that location, even if there is no stock on hand, at least you have recorded that you have counted that stock during the stocktake process and that it is logged that it was counted on that date and time for auditing purposes.

Chris TRINGHAM

I wouldn't recommend using Inventory Adjustments to create stock (though others do). I think it's better to create a PO from a dummy supplier so you can specify the cost.

Angelina Moschella

编写者

Based on the comment I should use the 'I want to update data'.

I update the file with my Counted Quantity

I receive the following message

So how do I update the Counted Quantities for Products, because the suggestions don't seem to be working?

Thanks

Angelina Moschella

编写者

Hi Chris,
Importing the records by Record ID and Quantity worked.
Thank you

Cybrosys Techno Solutions Pvt.Ltd

Hi,

Importing quantities does not directly update stock on hand; it updates Inventory Adjustment lines with the inventory_quantity.

Odoo calculates the difference between the inventory_quantity and current stock only when you validate the Inventory Adjustment, creating stock moves to adjust stock.

Use the exact import template exported from Odoo’s Inventory Adjustment, which includes the correct fields and identifiers (product, location, inventory_quantity).

When importing, ensure the inventory_quantity is the absolute physical stock count you want for each product/location, not an incremental or additional quantity.

To reduce stock in a location via import, include that product/location line with an inventory_quantity of 0 explicitly in the import file.

Avoid importing into multiple open inventory adjustments simultaneously; this can cause quantity doubling or inconsistencies.

Always validate the Inventory Adjustment after import to apply the changes to stock levels correctly.

Hope it helps.

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
Back Date Inventory adjustment excel import 已解决 InventoryAdjustment	1 7月 25	1554
Inventory Adjustment page is Blank \| Would like to manually edit inventory numbers for initial count InventoryAdjustment	2 6月 25	1870
Hide 'Apps' module from the HOME screen for users not set as 'Administrators'. 已解决 V18	1 6月 25	2260
Truenas Official docker odoo self hosted image no persistancy V18	1 5月 25	2570
Odoo Enterprise 16 Inventory Adjustment Set to ZERO Products in Locations 已解决 InventoryAdjustment	2 12月 24	4801

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！