Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021837Openbravo ERP02. Master data managementpublic2012-10-02 18:292012-10-11 07:50
ReporterVictorVillar 
Assigned Tongarcia 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP17Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021837: The generate average cost process should not take into account 'incoming/outcoming shipments'
DescriptionThe generate average cost process should not take into account 'incoming/outcoming shipments'
Steps To Reproducechecking the m_generate_average_cost function, when Cur_InOutLine is initialized, is taken into account all m_inout transactions and it should not.

SELECT M_INOUTLINE.M_INOUTLINE_ID, M_INOUTLINE.MOVEMENTQTY, M_PRODUCT.M_PRODUCT_ID, M_PRODUCT.NAME AS PRODUCT_NAME, M_INOUT.MOVEMENTDATE,
        M_INOUTLINE.AD_CLIENT_ID, M_INOUTLINE.AD_ORG_ID, M_INOUT.C_BPARTNER_ID, C_BPARTNER.NAME AS BPARTNER_NAME
      FROM M_INOUT, M_INOUTLINE, M_PRODUCT, C_BPARTNER
      WHERE M_INOUT.M_INOUT_ID=M_INOUTLINE.M_INOUT_ID
        AND M_INOUTLINE.M_PRODUCT_ID=M_PRODUCT.M_PRODUCT_ID
        AND M_INOUT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
        AND M_PRODUCT.COSTTYPE='AV'
        AND M_INOUT.ISSOTRX='N'
        AND M_INOUT.PROCESSED='Y'
        AND M_INOUTLINE.MOVEMENTQTY>0
        AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND M_INOUT.DOCSTATUS <> 'VO'
        AND M_INOUT.AD_CLIENT_ID = v_Client
        AND NOT EXISTS
        (SELECT 1 FROM M_COSTING WHERE M_INOUTLINE_ID=M_INOUTLINE.M_INOUTLINE_ID)
      ORDER BY M_PRODUCT.M_PRODUCT_ID, M_INOUT.MOVEMENTDATE, M_INOUTLINE.MOVEMENTQTY DESC
Proposed Solutionadd the condition islogistic='N' as follow:

 AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND M_INOUT.DOCSTATUS <> 'VO' and islogistic='N'
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-02 18:29VictorVillarNew Issue
2012-10-02 18:29VictorVillarAssigned To => dmiguelez
2012-10-02 18:29VictorVillarModules => Core
2012-10-02 18:31VictorVillarAssigned Todmiguelez => ngarcia
2012-10-03 10:08VictorVillarIssue Monitored: networkb
2012-10-05 08:47hgbotCheckin
2012-10-05 08:47hgbotNote Added: 0053062
2012-10-05 08:47hgbotStatusnew => resolved
2012-10-05 08:47hgbotResolutionopen => fixed
2012-10-05 08:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9bc482b13d1c0cb324cf291ac07fc9126905737d [^]
2012-10-05 09:11VictorVillarNote Added: 0053069
2012-10-05 09:11VictorVillarStatusresolved => closed
2012-10-11 07:50hudsonbotCheckin
2012-10-11 07:50hudsonbotNote Added: 0053244

Notes
(0053062)
hgbot   
2012-10-05 08:47   
Repository: erp/devel/pi
Changeset: 9bc482b13d1c0cb324cf291ac07fc9126905737d
Author: Naiara Garcia <naiara.garcia <at> openbravo.com>
Date: Wed Oct 03 10:18:37 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9bc482b13d1c0cb324cf291ac07fc9126905737d [^]

Fixed issue 21837: The generate average cost process should not take into
account 'incoming/outcoming shipments'

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0053069)
VictorVillar   
2012-10-05 09:11   
Verified
(0053244)
hudsonbot   
2012-10-11 07:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/63dfc135f2a1 [^]

Maturity status: Test