← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 872242] [NEW] [6.0] Picking validation has rounding errors with uom computation

 

Public bug reported:

This is a follow-up, not a duplicate, to bug lp:862449.


Processing an internal picking, I got the message:

=> Processing quantity 36.256 kg for $PRODUCT is larger than the
available quantity 36.256 kg!

(note that the 3 decimals originate from my fix of bug lp:862449, if you
don't have them while trying to reproduce)

The message comes from a test "if calc_qty > move.move_id.product_qty:",
but only the originating move.quantity, not the calculated calc_qty was
shown in the error message. So I enhanced the message to show calc_qty.

=> Processing quantity 36.256 kg (36.26) for $PRODUCT is larger than the
available quantity 36.256 kg !


Looks like calc_qty did not compute in expected decimal precision, but had rounding errors.
If found this to be originating from a wrong user setting at the Rounding Precision setting of the used uom, which was set to 0.01 while the dp for Product_UoM was 3.

Ok, user problem you might say, but nevertheless, a normal user can't
see WHY his processing failed, and even our experts didn't figure it
out, until I did extensive debugging.

I therefore enhanced the error messages by a note "Please note that
there may be rounding issues due to the Unit of Measurement rounding
precision.", if the decimals vary.

Example:

Processing Error
Can not process quantity 0.002 for Product $PRODUCT !
Please note that there may be rounding issues due to the Unit of Measurement rounding precision. (UoM computed quantity is 0.0 kg)

(Please note that rev. 4802 was not applied, otherwise this specific
example message would not have shown)

Please take a look at the following merge proposal.

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/872242

Title:
  [6.0] Picking validation has rounding errors with uom computation

Status in OpenERP Addons (modules):
  New

Bug description:
  This is a follow-up, not a duplicate, to bug lp:862449.

  
  Processing an internal picking, I got the message:

  => Processing quantity 36.256 kg for $PRODUCT is larger than the
  available quantity 36.256 kg!

  (note that the 3 decimals originate from my fix of bug lp:862449, if
  you don't have them while trying to reproduce)

  The message comes from a test "if calc_qty >
  move.move_id.product_qty:", but only the originating move.quantity,
  not the calculated calc_qty was shown in the error message. So I
  enhanced the message to show calc_qty.

  => Processing quantity 36.256 kg (36.26) for $PRODUCT is larger than
  the available quantity 36.256 kg !

  
  Looks like calc_qty did not compute in expected decimal precision, but had rounding errors.
  If found this to be originating from a wrong user setting at the Rounding Precision setting of the used uom, which was set to 0.01 while the dp for Product_UoM was 3.

  Ok, user problem you might say, but nevertheless, a normal user can't
  see WHY his processing failed, and even our experts didn't figure it
  out, until I did extensive debugging.

  I therefore enhanced the error messages by a note "Please note that
  there may be rounding issues due to the Unit of Measurement rounding
  precision.", if the decimals vary.

  Example:

  Processing Error
  Can not process quantity 0.002 for Product $PRODUCT !
  Please note that there may be rounding issues due to the Unit of Measurement rounding precision. (UoM computed quantity is 0.0 kg)

  (Please note that rev. 4802 was not applied, otherwise this specific
  example message would not have shown)

  Please take a look at the following merge proposal.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/872242/+subscriptions


Follow ups

References