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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0024285
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 04. Warehouse managementmajoralways2013-07-08 17:002014-05-12 14:24
ReporterVictorVillarView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024285: It is necessary to review some reports regarding the product quantity shown

DescriptionIt is necessary to review some reports regarding the product quantity shown.
The 'Valued Stock Report' and the 'Stock Report' are taking into account the movement date of the m_transaction table, might be it will be necessary to take into account the transaction process date of the same table.
Steps To ReproduceIt is necessary to review some reports regarding the product quantity shown.
The 'Valued Stock Report' and the 'Stock Report' are taking into account the movement date of the m_transaction table, might be it will be necessary to take into account the transaction process date of the same table.

1) On 1-Nov-12, Product P123 on-hand qty = 100 kpc
2) On 1-Nov-12, Customer Service created a Goods Shipment for Product P123 of 150 kpc.
The Goods Shipment was left in "Draft" status since there wasn't enough qty for the shipment.
3) On 8-Nov-12, 80 kpc were transferred from production to the warehouse. Qty on hand: 180
4) On 8-Nov-12, Customer Service successfully completed the Goods Shipment of 150 kpc for Product P123
without changing the date to 8-Nov-12. So the goods movement date is recorded as 1-Nov-12.

"Valued Stock Report" setting the date to 1-Nov-12,
the report shows 30 kpc for Product P123.
Proposed SolutionThe 'Valued Stock Report' and the 'Stock Report' are taking into account the movement date of the m_transaction table, might be it will be necessary to take into account the transaction process date of the same table.
Another option could be: inform the user that the document that is going to be processed has the movement date different from the transaction process date.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0024483 closedjonalegriaesarte The transactions accounting date should be the one used to find the transaction cost in the Valued Stock Report 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2013-07-08 17:00 VictorVillar New Issue
2013-07-08 17:00 VictorVillar Assigned To => dmiguelez
2013-07-08 17:00 VictorVillar Modules => Core
2013-07-08 17:00 VictorVillar Triggers an Emergency Pack => No
2014-05-12 14:24 ngarcia Issue Monitored: ngarcia
2014-05-13 09:46 ngarcia Relationship added related to 0024483


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker