Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007200Openbravo ERP05. Production managementpublic2009-01-28 16:262009-04-24 15:56
ReporterRenateNieuwkoop 
Assigned ToAinhoaPagola 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007200: Product Movement Report: incorrect movement shown for Work Effort
DescriptionWarehouse Management || Analysis Tools || Product Movements Report || Product Movements Report

When there are parts from a Work requirement on the report for which Work efforts were created, the Movement link in the report links to BOM Production. Not sure why there would even be BOM Production entries (since the parts are related to a Work Requirement) and the BOM Production looks incomplete (no name)
See snapshots.
Steps To ReproduceSee Basic Functional training Production management module, Final Scenario:

- Create activities
- create process plan
- create Operations and I/O Product in the Process Plan
- Enter Work Requirement based on the process plan
- Create several Work Efforts for various operations
- run Product Movements report
- Check one of the products for which you had a Work Effort and click 'movement' link
Proposed Solution
Additional Information
Tagsmain
Relationships
depends on backport 0007280 closed AinhoaPagola Product Movement Report: incorrect movement shown for Work Effort 
has duplicate defect 0008753 closed rafaroda Product Movements Report do not show shipments/receptions 
Attached Filesjpg 280109ProductMovement1.jpg (356,895) 2009-01-28 16:26
https://issues.openbravo.com/file_download.php?file_id=756&type=bug
jpg 280109ProductMovement2.jpg (180,345) 2009-01-28 16:26
https://issues.openbravo.com/file_download.php?file_id=757&type=bug
jpg

jpg 280109ProductMovement3.jpg (176,532) 2009-01-28 16:27
https://issues.openbravo.com/file_download.php?file_id=758&type=bug
jpg

jpg 280109ProductMovement4.jpg (165,264) 2009-01-28 16:27
https://issues.openbravo.com/file_download.php?file_id=759&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-01-28 16:26RenateNieuwkoopNew Issue
2009-01-28 16:26RenateNieuwkoopAssigned To => rafaroda
2009-01-28 16:26RenateNieuwkoopsf_bug_id0 => 2543230
2009-01-28 16:26RenateNieuwkoopFile Added: 280109ProductMovement1.jpg
2009-01-28 16:26RenateNieuwkoopFile Added: 280109ProductMovement2.jpg
2009-01-28 16:27RenateNieuwkoopFile Added: 280109ProductMovement3.jpg
2009-01-28 16:27RenateNieuwkoopFile Added: 280109ProductMovement4.jpg
2009-01-30 16:32psarobeStatusnew => scheduled
2009-01-30 16:32psarobeAssigned Torafaroda => gorkaion
2009-01-30 16:32psarobefix_in_branch => trunk
2009-02-16 12:34gorkaionNote Added: 0013517
2009-02-16 12:35gorkaionNote Edited: 0013517
2009-02-16 12:39gorkaionAssigned Togorkaion => AinhoaPagola
2009-02-23 11:22AinhoaPagolaNote Added: 0013905
2009-03-30 17:45networkbPrioritynormal => immediate
2009-03-30 17:45networkbfix_in_branchpi =>
2009-04-06 11:57hgbotCheckin
2009-04-06 11:57hgbotNote Added: 0015217
2009-04-06 11:57hgbotStatusscheduled => resolved
2009-04-06 11:57hgbotResolutionopen => fixed
2009-04-06 11:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/973c7412989413272a112939b7fab8f40964dea3 [^]
2009-04-22 11:24psarobeTag Attached: main
2009-04-23 13:44hgbotCheckin
2009-04-23 13:44hgbotNote Added: 0015618
2009-04-23 13:44hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/973c7412989413272a112939b7fab8f40964dea3 [^] => http://code.openbravo.com/erp/devel/pi/rev/860eb43815e69c175e9b66f4467122461a491461 [^]
2009-04-24 09:59AinhoaPagolaRelationship addedhas duplicate 0008753
2009-04-24 15:56sureshbabuRegression testing => No
2009-04-24 15:56sureshbabuStatusresolved => closed
2009-04-24 15:56sureshbabuFixed in Version => main

Notes
(0013517)
gorkaion   
2009-02-16 12:34   
(edited on: 2009-02-16 12:35)
The Manufacturing module's Work Effort and the BOM production at database level share the same tables.

This report was made before the Manufacturing module was developed, so it is not filtering the BOM Productions and Work Efforts and consider all the entries as BOM Productions.

We'll fix the report to differentiate both types of productions.
(0013905)
AinhoaPagola   
2009-02-23 11:22   
There are some extra issues regarding this bug:

- In PostgreSQL the movement link is null because is not properly created. (There is concatenation with null values, so the whole value is set to null)

- The report is not working for UUIDs. It works for numeric IDs (even is these numbers are strings) but not for IDs that include letters.
(0015217)
hgbot   
2009-04-06 11:57   
Repository: erp/devel/pi
Changeset: 973c7412989413272a112939b7fab8f40964dea3
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Mon Apr 06 11:55:56 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/973c7412989413272a112939b7fab8f40964dea3 [^]

Fixes bug 0007200. Product Movement Report: Links issue solved.

---
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.html
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.xml
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql
---
(0015618)
hgbot   
2009-04-23 13:44   
Repository: erp/devel/pi
Changeset: 860eb43815e69c175e9b66f4467122461a491461
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Thu Apr 23 13:43:06 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/860eb43815e69c175e9b66f4467122461a491461 [^]

Bug 7200. Fixes link in Product Movement Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.html
---