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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012505
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2010-03-01 12:322010-03-12 22:40
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchFixed in SCM revision94a406d2d299
ProjectionnoneETAnoneTarget Version2.50MP14
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012505: m_generate_average_costs when there is no pricelist associated

DescriptionYou create a Goods Receipt for a Product without price in Business Partner price list version. When running Generate Average Costs, inserts entries with cost and price set to NULL in m_costing.
Steps To Reproduce1. Master Data Management || Pricing || Price List || Price List: go to Purchase 2006 and remove Product Price of Hammer
2. Procurement Management || Transactions || Goods Receipt || Header : create record for Macgiver and Hammer, and complete
3. Run Generate Average Costs process
4. Master Data Management || Product || Product >> Costing : check that entries for hammer product have cost and price set to null
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0024953)
adrianromero (manager)
2010-03-02 16:01

The issue here is that the procedure M_GENERATE_AVERAGE_COSTS inserts a cost with price NULL When there is no price in invoice, order and bp pricelist.

The solution to this is to modify the procedure and if there is no price in invoice, order and bp price list, insert a new cost using the price of the previous cost, and if a previous cost does not exist then do not do anything

In both cases, (insert a new cost using the price of the previous cost or not to do anything) a warning must be generated. To generate a warning v_result, the returned variable must be set to 2 and the v_message variable must be set with the message value.

The message of the process: http://wiki.openbravo.com/wiki/ERP/2.50/User_Manual/Warehouse_Management#Create_Average_Costs [^] must be modified by adding an explanation how costs are calculated.
(0024954)
adrianromero (manager)
2010-03-02 16:07

In the solution of the issue, the warning message must show the business partner and the product.
(0025019)
hgbot (developer)
2010-03-03 17:32

Repository: erp/devel/pi
Changeset: 94a406d2d299fc5c8285126694bdaf1716f16d44
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Mar 03 17:36:36 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/94a406d2d299fc5c8285126694bdaf1716f16d44 [^]

Fixes issue 0012505: m_generate_average_costs when there is no pricelist associated

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_PROCESS.xml
---
(0025020)
adrianromero (manager)
2010-03-03 17:35

To test the issue follow the steps to reproduce and check that in step 3 a warning is generated saying that the cost for Hammer cannot be generated and in the step 4, in Master Data Management || Product || Product >> Costing check that the cost is set to 4.5 instead of null. The value was taken from the last cost available.
(0025108)
arunkumar (reporter)
2010-03-08 09:27

Tested & Working fine
(0025385)
hudsonbot (developer)
2010-03-12 22:40

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/94a406d2d299 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]

- Issue History
Date Modified Username Field Change
2010-03-01 12:32 networkb New Issue
2010-03-01 12:32 networkb Assigned To => adrianromero
2010-03-02 15:53 adrianromero Status new => scheduled
2010-03-02 15:53 adrianromero fix_in_branch => pi
2010-03-02 16:01 adrianromero Note Added: 0024953
2010-03-02 16:07 adrianromero Note Added: 0024954
2010-03-03 17:32 hgbot Checkin
2010-03-03 17:32 hgbot Note Added: 0025019
2010-03-03 17:32 hgbot Status scheduled => resolved
2010-03-03 17:32 hgbot Resolution open => fixed
2010-03-03 17:32 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/94a406d2d299fc5c8285126694bdaf1716f16d44 [^]
2010-03-03 17:35 adrianromero Note Added: 0025020
2010-03-03 17:35 adrianromero fix_in_branch pi =>
2010-03-08 09:27 arunkumar Note Added: 0025108
2010-03-08 09:27 arunkumar Status resolved => closed
2010-03-08 09:27 arunkumar Fixed in Version => 2.50MP13
2010-03-08 16:04 jpabloae Fixed in Version 2.50MP13 => 2.50MP14
2010-03-08 16:05 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-10 17:25 anonymous sf_bug_id 0 =>
2010-03-10 18:30 anonymous sf_bug_id => 2968117
2010-03-12 22:40 hudsonbot Checkin
2010-03-12 22:40 hudsonbot Note Added: 0025385


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker