Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0012505 | Openbravo ERP | 04. Warehouse management | public | 2010-03-01 12:32 | 2010-03-12 22:40 |
|
| Reporter | networkb | |
| Assigned To | adrianromero | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.50MP11 | |
| Target Version | 2.50MP14 | Fixed in Version | 2.50MP14 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0012505: m_generate_average_costs when there is no pricelist associated |
| Description | You 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 Reproduce | 1. 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 |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| 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 | |
|
Notes |
|
|
|
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. |
|
|
|
|
|
In the solution of the issue, the warning message must show the business partner and the product. |
|
|
|
(0025019)
|
|
hgbot
|
|
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
---
|
|
|
|
|
|
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. |
|
|
|
|
|
|
|
|
|