Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033002Openbravo ERP04. Warehouse managementpublic2016-05-19 16:322016-06-17 19:37
Reporterngarcia 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR16Q3Fixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket42061
Regression levelProduction - QA Approved
Regression date2015-11-27
Regression introduced in release3.0PR16Q1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/92d905a6c013 [^]
Triggers an Emergency PackNo
Summary0033002: 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
depends on backport 00330063.0PR16Q2 closed aferraz Stock available previous to the validation of the costing rule is not shown in Valued Stock Report 
depends on backport 00330073.0PR16Q1.2 closed aferraz Stock available previous to the validation of the costing rule is not shown in Valued Stock Report 
caused by defect 00314153.0PR16Q1 closed aferraz The valued stock report is not taking into account the starting date of the costing rule 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-19 16:32ngarciaNew Issue
2016-05-19 16:32ngarciaAssigned To => Triage Finance
2016-05-19 16:32ngarciaOBNetwork customer => Yes
2016-05-19 16:32ngarciaModules => Core
2016-05-19 16:32ngarciaSupport ticket => 42061
2016-05-19 16:32ngarciaResolution time => 1465336800
2016-05-19 16:32ngarciaTriggers an Emergency Pack => No
2016-05-19 17:10ngarciaIssue Monitored: networkb
2016-05-19 17:17ngarciaDescription Updatedbug_revision_view_page.php?rev_id=12173#r12173
2016-05-19 17:17ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12175#r12175
2016-05-19 17:17ngarciaRelationship addedcaused by 0031415
2016-05-20 09:30aferrazStatusnew => scheduled
2016-05-20 09:30aferrazRelationship deleteddepends on 0033008
2016-05-20 10:11aferrazAssigned ToTriage Finance => aferraz
2016-05-20 11:04aferrazNote Added: 0086596
2016-05-20 13:29hgbotCheckin
2016-05-20 13:29hgbotNote Added: 0086617
2016-05-20 13:29hgbotStatusscheduled => resolved
2016-05-20 13:29hgbotResolutionopen => fixed
2016-05-20 13:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/98ac1279b215ca0f41ca2844a584b4a7fa315082 [^]
2016-05-20 13:32dmiguelezReview Assigned To => dmiguelez
2016-05-20 13:32dmiguelezNote Added: 0086620
2016-05-20 13:32dmiguelezStatusresolved => closed
2016-05-23 12:57aferrazRegression level => Production - QA Approved
2016-05-23 12:57aferrazRegression date => 2015-11-27
2016-05-23 12:57aferrazRegression introduced in release => 3.0PR16Q1
2016-05-23 12:57aferrazRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/92d905a6c013 [^]
2016-05-23 12:58aferrazFixed in Version => 3.0PR16Q3
2016-05-23 12:58aferrazTarget Version => 3.0PR16Q3
2016-06-17 19:37hudsonbotCheckin
2016-06-17 19:37hudsonbotNote Added: 0087549

Notes
(0086596)
aferraz   
2016-05-20 11:04   
Test Plan:

As 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 previous stock + stock received in the goods receipt is shown
(0086617)
hgbot   
2016-05-20 13:29   
Repository: erp/devel/pi
Changeset: 98ac1279b215ca0f41ca2844a584b4a7fa315082
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri May 20 10:08:11 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/98ac1279b215ca0f41ca2844a584b4a7fa315082 [^]

Fixes issue 33002: 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
---
(0086620)
dmiguelez   
2016-05-20 13:32   
Code Review + Testing Ok
(0087549)
hudsonbot   
2016-06-17 19:37   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0dc7be081b1c [^]
Maturity status: Test