Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006335Openbravo ERP05. Production managementpublic2008-12-02 18:002009-04-21 10:54
ReporterRenateNieuwkoop 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006335: Daily Work Requirement Report output seems incorrect
DescriptionProduction Management || Transactions || Work Requirement || Header >> Operation

I have a Work requirement with different phases (see snapshot 1) and quantities

When I run the Daily Work Requirment report the output doesn't make sense. For example 100 assembly has been completed, 52 still to do.

Production Management || Transactions || Work Requirement || Header >> Operation

This report is showing 1200 still need to be assembled.
Steps To Reproduce
Proposed Solution
Additional Information
Tagscommsup_sprint6
Relationships
depends on backport 0007259 closed gorkaion Daily Work Requirement Report output seems incorrect 
Attached Filesjpg 021208Workrequirement.jpg (223,312) 2008-12-02 18:00
https://issues.openbravo.com/file_download.php?file_id=487&type=bug
jpg

jpg 021208DailyWorkrequirementreport1.jpg (119,925) 2008-12-02 18:00
https://issues.openbravo.com/file_download.php?file_id=488&type=bug
jpg

jpg 021208DailyWorkrequirementreport2.jpg (105,061) 2008-12-02 18:01
https://issues.openbravo.com/file_download.php?file_id=489&type=bug
jpg

? 200109Issue6335exercise.odp (3,955,245) 2009-01-20 11:16
https://issues.openbravo.com/file_download.php?file_id=677&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-12-02 18:00RenateNieuwkoopNew Issue
2008-12-02 18:00RenateNieuwkoopAssigned To => rafaroda
2008-12-02 18:00RenateNieuwkoopsf_bug_id0 => 2378391
2008-12-02 18:00RenateNieuwkoopFile Added: 021208Workrequirement.jpg
2008-12-02 18:00RenateNieuwkoopFile Added: 021208DailyWorkrequirementreport1.jpg
2008-12-02 18:01RenateNieuwkoopFile Added: 021208DailyWorkrequirementreport2.jpg
2008-12-09 13:05pheenanAssigned Torafaroda => gorkaion
2008-12-16 18:29rafarodaNote Added: 0011449
2008-12-16 18:29rafarodaStatusnew => feedback
2008-12-18 16:53RenateNieuwkoopNote Added: 0011531
2009-01-09 18:01psarobeNote Added: 0012065
2009-01-19 10:07psarobeOBNetwork customer => No
2009-01-19 10:07psarobeversion => 2.40
2009-01-19 10:08psarobeNote Added: 0012295
2009-01-19 10:08psarobeNote Added: 0012296
2009-01-20 11:16RenateNieuwkoopFile Added: 200109Issue6335exercise.odp
2009-01-20 11:18RenateNieuwkoopNote Added: 0012383
2009-01-30 11:40rafarodaStatusfeedback => scheduled
2009-01-30 11:40rafarodaNote Added: 0012875
2009-01-30 11:40rafarodafix_in_branch => trunk
2009-02-16 20:31svnbotCheckin
2009-02-16 20:31svnbotNote Added: 0013549
2009-02-16 20:31svnbotStatusscheduled => resolved
2009-02-16 20:31svnbotResolutionopen => fixed
2009-02-16 20:31svnbotsvn_revision => 13258
2009-02-19 12:53gorkaionTag Attached: commsup_sprint6
2009-04-21 10:54psarobeStatusresolved => closed

Notes
(0011449)
rafaroda   
2008-12-16 18:29   
Renate, please provide the Openbravo ERP version. Thank you.
(0011531)
RenateNieuwkoop   
2008-12-18 16:53   
It's 2.40 community version
(0012065)
psarobe   
2009-01-09 18:01   
Hi Renate,

Can you please provide the steps to reproduce the bug or the steps to QA to verify the bug is properly fixed?

Thanks
(0012295)
psarobe   
2009-01-19 10:08   
Reminder sent to: RenateNieuwkoop

Renate

Please provide more feedback to Gorka
(0012296)
psarobe   
2009-01-19 10:08   
Reminder sent to: gorkaion

Please ask Renate for more information
(0012383)
RenateNieuwkoop   
2009-01-20 11:18   
Hi Paolo, Gorka,

I think you could just make a simple test with a work requirement, execute some work efforts and then check the report. If that didn't work for you, then please find attached the full exercise that we use in training.

cheers
Renate
(0012875)
rafaroda   
2009-01-30 11:40   
Gorka Ion, please try the exercise and confirm that this defect is reproducing.
(0013549)
svnbot   
2009-02-16 20:31   
Repository: openbravo
Revision: 13258
Author: gorkaion
Date: 2009-02-16 20:31:49 +0100 (Mon, 16 Feb 2009)

Fixed bug 6335. The quantity shown for each phase now takes into account the done quantity.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDaily_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=13258&sc=1 [^]