Skip to Content
Menu
This question has been flagged

Hi everyone,

i am having problem with some of my products here.  It created double location but referring to the same location. Overall, stock is rightly calculated but it's kinda strange to see stock report like this.

How can i delete these negative qty so it should remain non-negative qty only? Did Inventory adjustment but negative ones still appear.

Here is the image of that problem : https://drive.google.com/open?id=1vD048AbnT0LPOLKW4UD8UpdnJ3q1Twwc

Any help would be appreciated!

Avatar
Discard

There is something related to the quant not showing in that list. What is that field "Created On" referring to? Is there lot number or serial numbers involved?

Author

Hi Lars Aam, thanks for replying.

"Created on" is referring to first date which product entering the location.

I tried exporting both error location for Lot/Serial number, and the result is empty. But each of it has different external ID.

The negative ones is : __export__.stock_quant_484119_c6e2b954

Non Negative is : __export__.stock_quant_500089_e16d7142

Do you have any ideas regarding information above?

Best Answer

There looks to be two different quants. They come up with two different quant ID.  The screen shot looks to be a list of quants. 

Either you have Lot number / serial numbers , or you have created two products with same name. Odoo does not stop you from creating two products with same name.   Or you use Packages. That would also create different quants.

Click on the item in the list should bring up the detailed quant view (if the list is from Inventory Report current inventory).

Avatar
Discard
Author

Strange things happen here,

When i click on current inventory in inventory report, it took some time to load. When it finished i look at "on hand qty" of my error product. The negative stock is gone by itself. Then i see my list of another product which has this problem, and it's also gone too.

I think the system is really calculating and get rid these obsolete data of location and stock. Strange thing, but that's good! at least the problem is now done and we know the solution for that.

Huge thanks for the help Lars Aam!

Related Posts Replies Views Activity
2
Oct 24
178
3
Jul 22
4363
0
Mar 15
3244
1
Nov 24
110
2
Aug 24
3970