Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008535Openbravo ERP04. Warehouse managementpublic2009-04-03 13:142009-04-24 09:13
Reportersureshbabu 
Assigned Tojayakumar 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS30OS Version
Product Version2.50beta 
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
Summary0008535: Value stock report shows same value if the product as more than one attributes
DescriptionValue stock report shows same values if the product as more than one attributes

Note: check the screen shot for more details

Steps To Reproduce1) Create a PO with product as Grand beer <any attribute> & change the unit value.
2) Create one more PO with product as Grand Beer <any attribute other than the above one > and also change the unit price
3) receive both the PO's
4) Run the Generate Average cost process
5) move to value stock report, enter the required details and run the report

 Warehouse Management || Analysis Tools || Valued Stock Report || Valued Stock Report

Actual result: Values are repeated if the product as more than one different.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0008422 closed jayakumar Value stock report shows same value if the product as more than one attributes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-09 17:22rafarodaTypedefect => backport
2009-04-09 17:22rafarodafix_in_branch => 2.40
2009-04-15 08:32sathiyanAssigned Tosathiyan => jayakumar
2009-04-24 09:10jayakumarStatusscheduled => closed
2009-04-24 09:10jayakumarNote Added: 0015658
2009-04-24 09:10jayakumarResolutionopen => no change required
2009-04-24 09:13jayakumarNote Added: 0015661

Notes
(0015658)
jayakumar   
2009-04-24 09:10   
Reporter wants to have average cost for attribute basis. Currently “Generate Average Cost” process does not include attribute as one of the parameter. They have computed only product basis. If we want to fix it in “Valued Stock Report” (showing different average cost for different attribute), we have to fix it in “Generate Average Cost” process.

Approach 1:
We may not show this report based on the attribute set. It means same product should not repeat again and again (attribute set should not be considered). We have to show single line for any given product. For instance, “Boots” is repeating again and again in the given screen shot. It should not be repeat again and again.

Approach 2:
We can leave “Valued Stock Report” as it is (considering attribute set). But we have to fix it in “Generate Average Cost” process that need to be consider attribute set.

We need to get clarification, since it has business impact.

Gorka's suggestion: The correct way to solve this bug is using the approach 1 that you suggested. the attribute set shouldn't be considered to calculate the average cost. for instance:

I bought 1 L of milk (Lot-AAA) : 1$
Today I've bought another bottle (Lot-BBB) : 2$

So this report should show only a single line for the product milk with the average price 1.50$. I've talked with the QA department and they told to me that this report was working fine some time ago so you could check first if someone has done some modifications on the SQL statement.
(0015661)
jayakumar   
2009-04-24 09:13   
No change is required in 2.40 source code for this issue since it does not reproduce anymore.