Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008189Openbravo ERP04. Warehouse managementpublic2009-03-18 10:482010-02-03 15:57
Reporternetworkb 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.50alpha-r11 
Target Version2.50MP7Fixed 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
Summary0008189: 250 VM: Pareto Report: Update ABC is executed incorrectly
DescriptionWarehouse Management || Analysis Tools || Pareto Product Report || Pareto Product Report

After having entered some Purchase Orders, I ran the Pareto Product Report.
Parts that were classified as A in 2.40 are now displayed as C (boots). However, when I execute the 'update ABC', the code assigned was an A, not a C.
See snapshots.
Steps To Reproduce
Proposed Solution
Additional Information
Tags250MP8, main
Relationships
related to defect 0014161 closed sivaraman Pareto report: ABC codes do not get assigned correctly 
Attached Filesjpg 180309ParetoReport250.jpg (241,443) 2009-03-18 10:48
https://issues.openbravo.com/file_download.php?file_id=1012&type=bug
jpg

jpg 180309ABCcodeProduct250.jpg (171,433) 2009-03-18 10:49
https://issues.openbravo.com/file_download.php?file_id=1013&type=bug
jpg

jpg 231109ParetoReportasterix.jpg (318,037) 2009-11-24 10:39
https://issues.openbravo.com/file_download.php?file_id=1976&type=bug
jpg 231109ParetoReportABC.jpg (136,934) 2009-11-24 10:40
https://issues.openbravo.com/file_download.php?file_id=1977&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-03-18 10:48RenateNieuwkoopNew Issue
2009-03-18 10:48RenateNieuwkoopAssigned To => rafaroda
2009-03-18 10:48RenateNieuwkoopFile Added: 180309ParetoReport250.jpg
2009-03-18 10:49RenateNieuwkoopFile Added: 180309ABCcodeProduct250.jpg
2009-03-18 11:14RenateNieuwkoopNote Added: 0014767
2009-03-30 18:54psarobeNote Added: 0015073
2009-03-30 18:54psarobeStatusnew => feedback
2009-03-30 19:47RenateNieuwkoopNote Added: 0015077
2009-04-22 16:31psarobeNote Added: 0015549
2009-04-22 16:44RenateNieuwkoopNote Added: 0015554
2009-04-23 13:06psarobeStatusfeedback => scheduled
2009-04-23 13:06psarobefix_in_branch => pi
2009-10-09 13:23networkbNote Added: 0020907
2009-10-09 13:23networkbReporterRenateNieuwkoop => networkb
2009-10-09 13:23networkbTarget Version => 2.50MP7
2009-10-09 13:23networkbfix_in_branchpi =>
2009-10-13 12:14psarobeAssigned Torafaroda => gorkaion
2009-10-20 19:05hgbotCheckin
2009-10-20 19:05hgbotNote Added: 0021227
2009-10-20 19:05hgbotStatusscheduled => resolved
2009-10-20 19:05hgbotResolutionopen => fixed
2009-10-20 19:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/92157df159bf8fe63ede03f42fd62a49d52eac09 [^]
2009-10-22 19:26psarobeTag Attached: main
2009-10-22 19:33psarobeTag Attached: 250MP8
2009-10-23 13:19arunkumarStatusresolved => closed
2009-10-23 13:19arunkumarNote Added: 0021361
2009-10-23 13:19arunkumarFixed in Version => 2.50MP8
2009-10-24 00:00anonymoussf_bug_id0 => 2885053
2009-11-24 10:35RenateNieuwkoopNote Added: 0022132
2009-11-24 10:37psarobeStatusclosed => new
2009-11-24 10:37psarobeResolutionfixed => open
2009-11-24 10:37rafarodaIssue Monitored: rafaroda
2009-11-24 10:37psarobeFixed in Version2.50MP8 =>
2009-11-24 10:39RenateNieuwkoopFile Added: 231109ParetoReportasterix.jpg
2009-11-24 10:40RenateNieuwkoopFile Added: 231109ParetoReportABC.jpg
2009-12-07 20:18psarobeNote Added: 0022509
2009-12-07 20:18psarobeStatusnew => feedback
2009-12-10 17:43rafarodaIssue Monitored: RenateNieuwkoop
2009-12-10 17:43rafarodaNote Added: 0022653
2009-12-10 17:51RenateNieuwkoopNote Added: 0022657
2009-12-11 17:00RenateNieuwkoopNote Added: 0022715
2009-12-11 17:22psarobeStatusfeedback => closed
2009-12-11 17:22psarobeResolutionopen => no change required
2010-02-03 10:29RenateNieuwkoopNote Added: 0023920
2010-02-03 10:43RenateNieuwkoopNote Added: 0023921
2010-02-03 15:57RenateNieuwkoopNote Added: 0023928
2010-08-16 12:00adrianromeroRelationship addedrelated to 0014161

Notes
(0014767)
RenateNieuwkoop   
2009-03-18 11:14   
Also when executing a PI based on the ABC code 'A', the boots do appear (see snapshot).

Warehouse Management || Transactions || Physical Inventory || Header >> Lines
(0015073)
psarobe   
2009-03-30 18:54   
Sorry Renate but still not clear for me.

Do you mean that after pressing the button Update ABC everything works fine? What is the problem?
(0015077)
RenateNieuwkoop   
2009-03-30 19:47   
Hi Pablo,

Please check the snapshots. What you can see is that the Pareto report gives incorrect information. It's saying that the boots are 'C', yet when you update the codes, an A appears.

So the Pareto report gives incorrect information, that's the problem.
(0015549)
psarobe   
2009-04-22 16:31   
still not clear to me
(0015554)
RenateNieuwkoop   
2009-04-22 16:44   
Hi Pablo,

As you know in the Training environment we always have the same data and the same exercises with the same output. Now, in 2.50, we are running the Pareto report and based on our outcome in 2.40 were expecting certain parts to be classified as an 'A' part. However, on the Pareto report they appear as a class 'C', which is not what we expected. The we comment the codes to the product and now on the product the class 'A' is assigned (as we expected it to be in the first place).

So the display in the Pareto report of the values is incorrect, but when it actually assigns the classification to the products, it does have the correct classification.
So that's why I am saying that just the display in the Pareto report seems to be incorrect.
(0020907)
networkb   
2009-10-09 13:23   
Changed the target version to the next release
(0021227)
hgbot   
2009-10-20 19:05   
Repository: erp/devel/pi
Changeset: 92157df159bf8fe63ede03f42fd62a49d52eac09
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue Oct 20 19:04:22 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/92157df159bf8fe63ede03f42fd62a49d52eac09 [^]

Fixed issue 8189. Fixed the Pareto Report Product
The ABC categories are now calculated based on the total amount stocked and
not on the cost of one unit.
Removed the attributes from the report that were not needed.

---
M src-db/database/model/functions/M_GET_PARETO_ABC.xml
M src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.xml
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
---
(0021361)
arunkumar   
2009-10-23 13:19   
The code 'A' has been assigned for Boots in both places
(1) Product -> org specifis
(2) After running Pareto report product

Tested & Working fine.
(0022132)
RenateNieuwkoop   
2009-11-24 10:35   
Well, it looks a lot better now, most products are updated correctly.
The strange thing is that on the whole list, still one product was updated incorrectly: product shirt appeared on the Pareto report wtih a code 'B', yet it was updated with a code 'C' in the Org Specific tab.
(0022509)
psarobe   
2009-12-07 20:18   
Renate, are you sure that that product is not a problem in your environment?
(0022653)
rafaroda   
2009-12-10 17:43   
Reminder sent to: RenateNieuwkoop

Renate,

Please comment on this issue otherwise it will be closed as properly resolved.

Thanks.
(0022657)
RenateNieuwkoop   
2009-12-10 17:51   
Sorry Rafa, I will retest it tomorrow!

thanks for your patience
Renate
(0022715)
RenateNieuwkoop   
2009-12-11 17:00   
Hi Rafa,

I reran the report and now it was updated correctly. I'll keep an eye on it, but for now you can close this issue

thanks
Renate
(0023920)
RenateNieuwkoop   
2010-02-03 10:29   
Hi

As I am testing MP11 this bug is reappearing. Please fix this again.
See snapshots.

thanks
Renate
(0023921)
RenateNieuwkoop   
2010-02-03 10:43   
The ABC report states that the code for Boots is A (which is correct, since we always use the same data in Training). However, when committing the data, the ABC code in the product setup for boots appears as C. Also when creating the Physical Inventory count list based on the ABC code, the boots are considered C instead of A.
(0023928)
RenateNieuwkoop   
2010-02-03 15:57   
Actually I had MP10. Now testing in MP11 it appears to be correct again.