Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024483Openbravo ERP04. Warehouse managementpublic2013-08-05 13:392014-06-10 14:23
ReporterVictorVillar 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutioninvalid 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket22607
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024483: The transactions accounting date should be the one used to find the transaction cost in the Valued Stock Report
DescriptionThe transactions accounting date should be the one used to find the transaction cost in the Valued Stock Report
Steps To ReproduceThe 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(?)" +
........
Proposed SolutionCreate 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
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-08-05 13:39VictorVillarNew Issue
2013-08-05 13:39VictorVillarAssigned To => dmiguelez
2013-08-05 13:39VictorVillarModules => Core
2013-08-05 13:39VictorVillarOBNetwork customer => Yes
2013-08-05 13:39VictorVillarSupport ticket => 22607
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