Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024483
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 04. Warehouse managementmajoralways2013-08-05 13:392014-06-10 14:23
ReporterVictorVillarView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityurgentResolutioninvalidFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
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
Summary

0024483: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0024285 newdmiguelez It is necessary to review some reports regarding the product quantity shown 
related to defect 00268233.0PR14Q3 closedrafaroda the transaction cost of the Valued Stock report should be filtered regarding the movement date 

-  Notes
(0063215)
jonalegriaesarte (viewer)
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 (viewer)
2014-06-10 14:23

 That is not the correct change, the valuation column should be calculated regarding the movement date of the transactions

- Issue History
Date Modified Username Field Change
2013-08-05 13:39 VictorVillar New Issue
2013-08-05 13:39 VictorVillar Assigned To => dmiguelez
2013-08-05 13:39 VictorVillar Modules => Core
2013-08-05 13:39 VictorVillar OBNetwork customer => Yes
2013-08-05 13:39 VictorVillar Support ticket => 22607
2013-08-05 13:39 VictorVillar Triggers an Emergency Pack => No
2013-08-05 13:39 VictorVillar Issue Monitored: networkb
2013-12-16 09:35 VictorVillar Assigned To dmiguelez => jonalegriaesarte
2014-01-02 17:51 jonalegriaesarte Note Added: 0063215
2014-01-02 17:51 jonalegriaesarte Type design defect => feature request
2014-05-12 14:24 ngarcia Issue Monitored: ngarcia
2014-05-13 09:46 ngarcia Relationship added related to 0024285
2014-06-10 14:23 VictorVillar Review Assigned To => gorkaion
2014-06-10 14:23 VictorVillar Note Added: 0067846
2014-06-10 14:23 VictorVillar Status new => closed
2014-06-10 14:23 VictorVillar Resolution open => invalid
2014-06-10 15:03 VictorVillar Relationship added related to 0026823

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker