Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033006Openbravo ERP04. Warehouse managementpublic2016-05-19 16:322016-05-20 13:32
Reporterngarcia 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR16Q2Fixed in Version 
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
Summary0033006: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00330023.0PR16Q3 closed aferraz Stock available previous to the validation of the costing rule is not shown in Valued Stock Report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-20 09:30aferrazTypedefect => backport
2016-05-20 09:30aferrazTarget Version => 3.0PR16Q2
2016-05-20 10:11aferrazAssigned ToTriage Finance => aferraz
2016-05-20 13:28hgbotCheckin
2016-05-20 13:28hgbotNote Added: 0086615
2016-05-20 13:28hgbotStatusscheduled => resolved
2016-05-20 13:28hgbotResolutionopen => fixed
2016-05-20 13:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR16Q2/rev/ee83803babb409535c74f7fd44b460906f51ad7d [^]
2016-05-20 13:32dmiguelezReview Assigned To => dmiguelez
2016-05-20 13:32dmiguelezNote Added: 0086619
2016-05-20 13:32dmiguelezStatusresolved => closed

Notes
(0086615)
hgbot   
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   
2016-05-20 13:32   
Code Review + Testing Ok