1. Mailing Lists
  2. Logistics
  3. Re: negative quants and returns

Logistics mailing list archives

logistics@odoo-community.org

Browse archives

Re: negative quants and returns

Re: negative quants and returns

Avatar

Re: negative quants and returns

by
WilldooIT, Jonathan Wilson
- 10/12/2015 01:23:23
We have a similar issue for "serialise on delivery" items - the system leaves the original quant (un-serialised) in place and generates a new negative quant for the moved serialised item. There was a bug that was causing the QoH to just take into account the +ve quants which was causing mayhem resulting in rubbish QoH figures. We fixed that but now need a way to get then system "clean" again and have been wondering about the best way to do that. The "stock_quant_merge" nearly does it, however in our case, the original quant has no serial number. Maybe the module could be extended so that if the one of the merged quants was without a serial it could pick up the serial number from the other serialised quant. Not quite sure if this would break something though - thoughts? 


Jonathan Wilson
ph: +61 3 8506 0393
mob: +61 4 000 17 444
2013 & 2015 Odoo Best Partner Asia/Pacific
Creators of  Odoo-Pentaho integration project





On 10 December 2015 at 08:22, Joël Grand-Guillaume <joel.grandguillaume@camptocamp.com> wrote:
Hi there,


I thought about this one. What about building an OCA addon to reconcile stock.quants in a same location ?

I mean, it makes sense, like dedupplicating partners or bank reconciliation. Those are similar uses cases made manually, with some automation magic.

We can imagine a simple tools suggesting quants reconciliation that someone approves on a periodical basis. What do you think ?



My2cents,

Joël



On Wed, Dec 9, 2015 at 2:08 PM, Alexandre Fayolle <alexandre.fayolle@camptocamp.com> wrote:
Hello all,

I'm facing an issue on a customer's database. For various reasons
(including, but exclusively, errors in custom addons), some
availabilities of outgoing moves have been forced, resulting in negative
quants. I need to repair the situation for my customer.

My first attempt was to return the pickings, to have the quant
reconciliation code do the work, but in case the quant that originally
created the negative quant is being returned, the stock module
explicitly refuses to reconcile them (see
https://github.com/odoo/odoo/pull/9907). The official answer is that it
breaks the traceability of quants, and that stock inventories should be
used for this. I'm not fond of inventories there, because I don't think
that the resulting traceability is clearer (quite the contrary in fact),
but I'm concerned pushing 9907 could break other parts of Odoo (Joss
mentionned mrp).

Before moving further, I'd like to gather opinions from people here.
Here are the options I could think of, feel free to add your suggestions:

* stick to inventories to fix this
* create an addon module to allow returns to reconcile the broken quants
(possibly asking the user to explicitly say he wants to do so)
* merge #9907 in OCB
* ???

Thanks for your feedback.

-- 
Alexandre Fayolle
Chef de Projet
Tel : +33 4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com

_______________________________________________
Mailing-List: http://odoo-community.org/groups/logistics-21
Post to: mailto:logistics@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe




--


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS

Joël Grand-Guillaume
Division Manager


_______________________________________________
Mailing-List: http://odoo-community.org/groups/logistics-21
Post to: mailto:logistics@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


Reference