Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementmajoralways2016-05-19 16:322016-05-20 13:31
ReporterngarciaView Statuspublic 
Assigned Toaferraz 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision43e2d443e6c9
ProjectionnoneETAnoneTarget Version3.0PR16Q1.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0033007: 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
hgbot (developer)
2016-05-20 13:28

Repository: erp/backports/3.0PR16Q1.2
Changeset: 43e2d443e6c922425000203753b2bc297ea9e9a0
Author: Alvaro Ferraz <alvaro.ferraz <at>>
Date: Fri May 20 10:08:11 2016 +0200
URL: [^]

Fixes issue 33007: 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/
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
dmiguelez (developer)
2016-05-20 13:31

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.0PR16Q1.2
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: 0086616
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 => [^]
2016-05-20 13:31 dmiguelez Review Assigned To => dmiguelez
2016-05-20 13:31 dmiguelez Note Added: 0086618
2016-05-20 13:31 dmiguelez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker