Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0024483Openbravo ERP04. Warehouse managementpublic2013-08-05 13:392014-06-10 14:23
VictorVillar 
jonalegriaesarte 
urgentmajoralways
closedinvalid 
5
pi 
 
gorkaion
Core
No
0024483: The transactions accounting date should be the one used to find the transaction cost in the Valued Stock Report
The transactions accounting date should be the one used to find the transaction cost in the Valued Stock Report
The transactions accounting date should be the one used to find the transaction cost in the Valued Stock Report.

As you can check in the ReportValuationStock_data.xsql --> currently the costdate column in the m_transaction_cost table is the transactionprocessdate of the m_transaction

........
 LEFT JOIN M_INOUT io ON iol.M_INOUT_ID = io.M_INOUT_ID " +
      " LEFT JOIN (SELECT sum(cost) AS trxcost, m_transaction_id, c_currency_id" +
      " FROM M_TRANSACTION_COST" +
      " WHERE costdate < to_date(?)" +
      " GROUP BY m_transaction_id, c_currency_id) tc ON trx.m_transaction_id = tc.m_transaction_id" +
      " WHERE trx.MOVEMENTDATE < to_date(?)" +
........
Create a new column in the m_transaction_cost table that should be the accounting date of the transaction. Then, this column should be used to recover the cost where necessary. For instance, the Valued Stock Report
No tags attached.
related to design defect 0024285 new dmiguelez It is necessary to review some reports regarding the product quantity shown 
related to defect 00268233.0PR14Q3 closed rafaroda the transaction cost of the Valued Stock report should be filtered regarding the movement date 
Issue History
2013-08-05 13:39VictorVillarNew Issue
2013-08-05 13:39VictorVillarAssigned To => dmiguelez
2013-08-05 13:39VictorVillarModules => Core
2013-08-05 13:39VictorVillarTriggers an Emergency Pack => No
2013-08-05 13:39VictorVillarIssue Monitored: networkb
2013-12-16 09:35VictorVillarAssigned Todmiguelez => jonalegriaesarte
2014-01-02 17:51jonalegriaesarteNote Added: 0063215
2014-01-02 17:51jonalegriaesarteTypedesign defect => feature request
2014-05-12 14:24ngarciaIssue Monitored: ngarcia
2014-05-13 09:46ngarciaRelationship addedrelated to 0024285
2014-06-10 14:23VictorVillarReview Assigned To => gorkaion
2014-06-10 14:23VictorVillarNote Added: 0067846
2014-06-10 14:23VictorVillarStatusnew => closed
2014-06-10 14:23VictorVillarResolutionopen => invalid
2014-06-10 15:03VictorVillarRelationship addedrelated to 0026823

Notes
(0063215)
jonalegriaesarte   
2014-01-02 17:51   
Changed to Feature request because the system behaves as expected (real-time material transactions). We need to support backdated material transactions. Once transactions are registered and posted on the backdate the report would work as the customers request
(0067846)
VictorVillar   
2014-06-10 14:23   
That is not the correct change, the valuation column should be calculated regarding the movement date of the transactions