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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008535
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementmajoralways2009-04-03 13:142009-04-24 09:13
ReportersureshbabuView Statuspublic 
Assigned Tojayakumar 
PriorityhighResolutionno change requiredFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50betaSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008535: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0008422 closedjayakumar Value stock report shows same value if the product as more than one attributes 

-  Notes
(0015658)
jayakumar (reporter)
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 (reporter)
2009-04-24 09:13

 No change is required in 2.40 source code for this issue since it does not reproduce anymore.

- Issue History
Date Modified Username Field Change
2009-04-09 17:22 rafaroda Type defect => backport
2009-04-09 17:22 rafaroda fix_in_branch => 2.40
2009-04-15 08:32 sathiyan Assigned To sathiyan => jayakumar
2009-04-24 09:10 jayakumar Status scheduled => closed
2009-04-24 09:10 jayakumar Note Added: 0015658
2009-04-24 09:10 jayakumar Resolution open => no change required
2009-04-24 09:13 jayakumar Note Added: 0015661

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker