c2c-oerpscenario team mailing list archive

["Jordi Esteve \(www.zikzakmedia.com\)" <jesteve@xxxxxxxxxxxxxxx>]

Public bug reported:

[6.0.2] stock_planning: outgoing_before field in stock.planing is not
correctly computed.

The quantity in the 'Planned out' field (planned_outgoing) is not added
between the start date of the current period and one day before the
start of the computed period.

It works well doing this change in stock_planning/stock_planning.py
file:

 @@ -338,7 +338,7 @@
                      FROM stock_planning AS planning \
                      LEFT JOIN stock_period AS period \
                      ON (planning.period_id = period.id) \
 -                    WHERE (period.date_stop >= %s) AND (period.date_stop <= %s) \
 +                    WHERE (period.date_stop >= %s) AND (period.date_start <= %s) \
                          AND (planning.product_id = %s) AND (planning.company_id = %s) \
                      GROUP BY planning.product_uom", \
                          (date_start, date_stop, val.product_id.id, val.company_id.id,))

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

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

Title:
  [6.0.2] stock_planning: outgoing_before field in stock.planing is not
  correctly computed

Status in OpenERP Modules (addons):
  New

Bug description:
  [6.0.2] stock_planning: outgoing_before field in stock.planing is not
  correctly computed.

  The quantity in the 'Planned out' field (planned_outgoing) is not
  added between the start date of the current period and one day before
  the start of the computed period.

  It works well doing this change in stock_planning/stock_planning.py
  file:

   @@ -338,7 +338,7 @@
                        FROM stock_planning AS planning \
                        LEFT JOIN stock_period AS period \
                        ON (planning.period_id = period.id) \
   -                    WHERE (period.date_stop >= %s) AND (period.date_stop <= %s) \
   +                    WHERE (period.date_stop >= %s) AND (period.date_start <= %s) \
                            AND (planning.product_id = %s) AND (planning.company_id = %s) \
                        GROUP BY planning.product_uom", \
                            (date_start, date_stop, val.product_id.id, val.company_id.id,))

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