Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008190Openbravo ERP04. Warehouse managementpublic2009-03-18 11:042009-10-01 19:32
ReporterRenateNieuwkoop 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.50alpha-r11 
Target VersionFixed in Version 
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
Summary0008190: 250 VM: Seperate lines on Pareto Product Report for lines with Attributes
DescriptionWarehouse Management || Analysis Tools || Pareto Product Report || Pareto Product Report

For parts that have attributes values, like Boots with the different sizes, the Pareto Product Report is displaying seperate lines. However, since the actual attributes are not reflected on the report, it looks strange and has no value add.
See snapshot.
Steps To ReproduceAdd PO/Purchase Invoices for boots with different sizes and run the Pareto Product Report
Proposed SolutionEither add the attribute value on the report or display just one line per product (like in 2.40)

One line per product
Additional Information
Tags250mp2, main
Relationships
related to defect 0008448 closed vinothbabu In Product movements report, in the result set products attribute detail is missing 
Attached Filesjpg 180309ParetoReport250.jpg (241,443) 2009-03-18 11:04
https://issues.openbravo.com/file_download.php?file_id=1014&type=bug
jpg

jpg 070509Issue8190ParetoReport.jpg (457,276) 2009-05-07 12:42
https://issues.openbravo.com/file_download.php?file_id=1271&type=bug
jpg 140909MultiplelinesProduct.jpg (372,271) 2009-09-14 16:40
https://issues.openbravo.com/file_download.php?file_id=1749&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-03-18 11:04RenateNieuwkoopNew Issue
2009-03-18 11:04RenateNieuwkoopAssigned To => rafaroda
2009-03-18 11:04RenateNieuwkoopFile Added: 180309ParetoReport250.jpg
2009-03-30 18:48psarobeSeveritytrivial => minor
2009-03-30 18:48psarobeStatusnew => scheduled
2009-03-30 18:48psarobeSteps to Reproduce Updated
2009-03-31 12:24rafarodaAssigned Torafaroda => sathiyan
2009-03-31 18:32sathiyanAssigned Tosathiyan => vinothbabu
2009-04-07 08:09hgbotCheckin
2009-04-07 08:09hgbotNote Added: 0015236
2009-04-07 08:09hgbotStatusscheduled => resolved
2009-04-07 08:09hgbotResolutionopen => fixed
2009-04-07 08:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/975fcc9866a63c151d4e421e7b8d3b8abef91ce8 [^]
2009-04-08 12:04rafarodaRelationship addedrelated to 0008448
2009-04-22 11:24psarobeTag Attached: main
2009-04-24 09:29sureshbabuRegression testing => No
2009-04-24 09:29sureshbabuStatusresolved => closed
2009-04-24 09:29sureshbabuNote Added: 0015664
2009-04-24 09:29sureshbabuFixed in Version => main
2009-04-25 00:00anonymoussf_bug_id0 => 2780806
2009-05-07 12:41RenateNieuwkoopStatusclosed => new
2009-05-07 12:41RenateNieuwkoopResolutionfixed => open
2009-05-07 12:41RenateNieuwkoopNote Added: 0016132
2009-05-07 12:41RenateNieuwkoopFixed in Versionmain =>
2009-05-07 12:42RenateNieuwkoopFile Added: 070509Issue8190ParetoReport.jpg
2009-05-07 16:09psarobeStatusnew => scheduled
2009-05-07 16:09psarobeNote Added: 0016141
2009-05-07 16:09psarobefix_in_branch => pi
2009-05-07 16:09psarobeTag Attached: 250mp2
2009-05-08 15:16hgbotCheckin
2009-05-08 15:16hgbotNote Added: 0016186
2009-05-08 15:16hgbotStatusscheduled => resolved
2009-05-08 15:16hgbotResolutionopen => fixed
2009-05-08 15:16hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/975fcc9866a63c151d4e421e7b8d3b8abef91ce8 [^] => http://code.openbravo.com/erp/devel/pi/rev/10b7dec17f2fc344ada0b6ce16fcd326c3bd11ca [^]
2009-05-11 14:25RenateNieuwkoopNote Added: 0016262
2009-05-28 10:58sureshbabuStatusresolved => closed
2009-05-28 10:58sureshbabuNote Added: 0016714
2009-05-28 10:58sureshbabuFixed in Version2.50MP1 => pi
2009-09-14 16:40RenateNieuwkoopStatusclosed => new
2009-09-14 16:40RenateNieuwkoopResolutionfixed => open
2009-09-14 16:40RenateNieuwkoopNote Added: 0019913
2009-09-14 16:40RenateNieuwkoopFixed in Versionpi =>
2009-09-14 16:40RenateNieuwkoopFile Added: 140909MultiplelinesProduct.jpg
2009-09-18 12:23rafarodaNote Added: 0020194
2009-09-18 12:23rafarodaAssigned Tovinothbabu => rafaroda
2009-09-18 12:23rafarodaStatusnew => feedback
2009-10-01 19:32psarobeStatusfeedback => closed
2009-10-01 19:32psarobeNote Added: 0020641
2009-10-01 19:32psarobeResolutionopen => no change required

Notes
(0015236)
hgbot   
2009-04-07 08:09   
Repository: erp/devel/pi
Changeset: 975fcc9866a63c151d4e421e7b8d3b8abef91ce8
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Tue Apr 07 11:32:31 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/975fcc9866a63c151d4e421e7b8d3b8abef91ce8 [^]

Fixes bug 8190 Add the attribute column on the Pareto Product Report.

---
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.xml
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
---
(0015664)
sureshbabu   
2009-04-24 09:29   
working fine
(0016132)
RenateNieuwkoop   
2009-05-07 12:41   
I just tested the report and it doesn't look correct to me. For example the boots, there are multiple lines with the same attributes (medium, Large, etc), see snapshot.
(0016141)
psarobe   
2009-05-07 16:09   
Renate completely agree with you. Sorry about that. Probably it has been a mislead by the developers.

The solution is to group by product and attribute and we are not doing that as you can look at the screenshot
(0016186)
hgbot   
2009-05-08 15:16   
Repository: erp/devel/pi
Changeset: 10b7dec17f2fc344ada0b6ce16fcd326c3bd11ca
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Fri May 08 18:42:49 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/10b7dec17f2fc344ada0b6ce16fcd326c3bd11ca [^]

Fixes bug 8190 Removing multiple lines with the same attributes.

---
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
---
(0016262)
RenateNieuwkoop   
2009-05-11 14:25   
Hi

Just a comment, as per previous snapshot, not just products with attributes have duplicates, but also other products, for example the hammer.

cheers
Renate
(0016714)
sureshbabu   
2009-05-28 10:58   
Tested working fine
(0019913)
RenateNieuwkoop   
2009-09-14 16:40   
As per the screenshot, based on testing in MP5, this is not resolved.
(0020194)
rafaroda   
2009-09-18 12:23   
Sorry Renate but I do not see what is wrong with the screenshot. Now Pareto Product Report shows one line per product and attribute, where attribute is informed.

Please provide further information.

Thanks.
(0020641)
psarobe   
2009-10-01 19:32   
Hi Renate,

It seems the issue is already fixed. The attribute has been added so the combination product-attribute is correct

Regards