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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033006
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementmajoralways2016-05-19 16:322016-05-20 13:32
ReporterngarciaView Statuspublic 
Assigned Toaferraz 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionee83803babb4
ProjectionnoneETAnoneTarget Version3.0PR16Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket42061
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033006: Stock available previous to the validation of the costing rule is not shown in Valued Stock Report

DescriptionStock available previous to the validation of the costing rule is not shown in Valued Stock Report. The starting date (timestamp) is truncated to date with the to_date function. Example:

to_date('02-07-2015 20:36:35') -> '2015-07-02 00:00:00'
Steps To ReproduceAs group admin role:
   Check there is stock of a product
   Validate a costing rule for the organization the stock belongs to
   Create a goods receipt for that product
   Launch the Costing Background Process and check it finishes successfully
   Launch the Valued Stock Report with tomorrow's date and check only the stock received in the goods receipt is shown
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00330023.0PR16Q3 closedaferraz Stock available previous to the validation of the costing rule is not shown in Valued Stock Report 

-  Notes
(0086615)
hgbot (developer)
2016-05-20 13:28

 Repository: erp/backports/3.0PR16Q2
Changeset: ee83803babb409535c74f7fd44b460906f51ad7d
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri May 20 10:08:11 2016 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR16Q2/rev/ee83803babb409535c74f7fd44b460906f51ad7d [^]

Fixes issue 33006: Stock before costing rule not shown in Valued Stock Report

Convert current costing rule starting date with to_timestamp instead of with to_date function to avoid date truncation.
Before, current costing rule starting date was truncated and closing and opening inventories created by costing rule validation were taken, so stock was zero.
Now, current costing rule starting date will not be truncated and only opening inventory created by costing rule validation will be taken, then stock will be the same as before the costing rule.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0086619)
dmiguelez (viewer)
2016-05-20 13:32

 Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2016-05-20 09:30 aferraz Type defect => backport
2016-05-20 09:30 aferraz Target Version => 3.0PR16Q2
2016-05-20 10:11 aferraz Assigned To Triage Finance => aferraz
2016-05-20 13:28 hgbot Checkin
2016-05-20 13:28 hgbot Note Added: 0086615
2016-05-20 13:28 hgbot Status scheduled => resolved
2016-05-20 13:28 hgbot Resolution open => fixed
2016-05-20 13:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR16Q2/rev/ee83803babb409535c74f7fd44b460906f51ad7d [^]
2016-05-20 13:32 dmiguelez Review Assigned To => dmiguelez
2016-05-20 13:32 dmiguelez Note Added: 0086619
2016-05-20 13:32 dmiguelez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker