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

Description

The generate average cost process should not take into account 'incoming/outcoming shipments'

Steps To Reproduce

checking 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 Solution

add the condition islogistic='N' as follow:

AND M_INOUT.DOCSTATUS <> 'DR' AND M_INOUT.DOCSTATUS <> 'RE' AND M_INOUT.DOCSTATUS <> 'VO' and islogistic='N'

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0053062) hgbot (developer) 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 (developer) 2012-10-05 09:11	Verified

(0053244) hudsonbot (developer) 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

Issue History
Date Modified	Username	Field	Change
2012-10-02 18:29	VictorVillar	New Issue
2012-10-02 18:29	VictorVillar	Assigned To	=> dmiguelez
2012-10-02 18:29	VictorVillar	Modules	=> Core
2012-10-02 18:31	VictorVillar	Assigned To	dmiguelez => ngarcia
2012-10-03 10:08	VictorVillar	Issue Monitored: networkb
2012-10-05 08:47	hgbot	Checkin
2012-10-05 08:47	hgbot	Note Added: 0053062
2012-10-05 08:47	hgbot	Status	new => resolved
2012-10-05 08:47	hgbot	Resolution	open => fixed
2012-10-05 08:47	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/9bc482b13d1c0cb324cf291ac07fc9126905737d [^]
2012-10-05 09:11	VictorVillar	Note Added: 0053069
2012-10-05 09:11	VictorVillar	Status	resolved => closed
2012-10-11 07:50	hudsonbot	Checkin
2012-10-11 07:50	hudsonbot	Note Added: 0053244