Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008190
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminorhave not tried2009-03-18 11:042009-10-01 19:32
ReporterRenateNieuwkoopView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchpiFixed in SCM revision10b7dec17f2f
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50alpha-r11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008190: 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
Tags250mp2, main
Attached Filesjpg file icon 180309ParetoReport250.jpg [^] (241,443 bytes) 2009-03-18 11:04


jpg file icon 070509Issue8190ParetoReport.jpg [^] (457,276 bytes) 2009-05-07 12:42
jpg file icon 140909MultiplelinesProduct.jpg [^] (372,271 bytes) 2009-09-14 16:40

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0008448 closedvinothbabu In Product movements report, in the result set products attribute detail is missing 

-  Notes
(0015236)
hgbot (developer)
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 (reporter)
2009-04-24 09:29

working fine
(0016132)
RenateNieuwkoop (reporter)
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 (manager)
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 (developer)
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 (reporter)
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 (reporter)
2009-05-28 10:58

Tested working fine
(0019913)
RenateNieuwkoop (reporter)
2009-09-14 16:40

As per the screenshot, based on testing in MP5, this is not resolved.
(0020194)
rafaroda (developer)
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 (manager)
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

- Issue History
Date Modified Username Field Change
2009-03-18 11:04 RenateNieuwkoop New Issue
2009-03-18 11:04 RenateNieuwkoop Assigned To => rafaroda
2009-03-18 11:04 RenateNieuwkoop File Added: 180309ParetoReport250.jpg
2009-03-30 18:48 psarobe Severity trivial => minor
2009-03-30 18:48 psarobe Status new => scheduled
2009-03-30 18:48 psarobe Steps to Reproduce Updated
2009-03-31 12:24 rafaroda Assigned To rafaroda => sathiyan
2009-03-31 18:32 sathiyan Assigned To sathiyan => vinothbabu
2009-04-07 08:09 hgbot Checkin
2009-04-07 08:09 hgbot Note Added: 0015236
2009-04-07 08:09 hgbot Status scheduled => resolved
2009-04-07 08:09 hgbot Resolution open => fixed
2009-04-07 08:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/975fcc9866a63c151d4e421e7b8d3b8abef91ce8 [^]
2009-04-08 12:04 rafaroda Relationship added related to 0008448
2009-04-22 11:24 psarobe Tag Attached: main
2009-04-24 09:29 sureshbabu Regression testing => No
2009-04-24 09:29 sureshbabu Status resolved => closed
2009-04-24 09:29 sureshbabu Note Added: 0015664
2009-04-24 09:29 sureshbabu Fixed in Version => main
2009-04-25 00:00 anonymous sf_bug_id 0 => 2780806
2009-05-07 12:41 RenateNieuwkoop Status closed => new
2009-05-07 12:41 RenateNieuwkoop Resolution fixed => open
2009-05-07 12:41 RenateNieuwkoop Note Added: 0016132
2009-05-07 12:41 RenateNieuwkoop Fixed in Version main =>
2009-05-07 12:42 RenateNieuwkoop File Added: 070509Issue8190ParetoReport.jpg
2009-05-07 16:09 psarobe Status new => scheduled
2009-05-07 16:09 psarobe Note Added: 0016141
2009-05-07 16:09 psarobe fix_in_branch => pi
2009-05-07 16:09 psarobe Tag Attached: 250mp2
2009-05-08 15:16 hgbot Checkin
2009-05-08 15:16 hgbot Note Added: 0016186
2009-05-08 15:16 hgbot Status scheduled => resolved
2009-05-08 15:16 hgbot Resolution open => fixed
2009-05-08 15:16 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/975fcc9866a63c151d4e421e7b8d3b8abef91ce8 [^] => http://code.openbravo.com/erp/devel/pi/rev/10b7dec17f2fc344ada0b6ce16fcd326c3bd11ca [^]
2009-05-11 14:25 RenateNieuwkoop Note Added: 0016262
2009-05-28 10:58 sureshbabu Status resolved => closed
2009-05-28 10:58 sureshbabu Note Added: 0016714
2009-05-28 10:58 sureshbabu Fixed in Version 2.50MP1 => pi
2009-09-14 16:40 RenateNieuwkoop Status closed => new
2009-09-14 16:40 RenateNieuwkoop Resolution fixed => open
2009-09-14 16:40 RenateNieuwkoop Note Added: 0019913
2009-09-14 16:40 RenateNieuwkoop Fixed in Version pi =>
2009-09-14 16:40 RenateNieuwkoop File Added: 140909MultiplelinesProduct.jpg
2009-09-18 12:23 rafaroda Note Added: 0020194
2009-09-18 12:23 rafaroda Assigned To vinothbabu => rafaroda
2009-09-18 12:23 rafaroda Status new => feedback
2009-10-01 19:32 psarobe Status feedback => closed
2009-10-01 19:32 psarobe Note Added: 0020641
2009-10-01 19:32 psarobe Resolution open => no change required


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker