Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010749 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | minor | always | 2009-09-24 17:44 | 2009-10-27 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | gorkaion | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | f12253b7af5c | ||||
| Projection | none | ETA | none | Target Version | 2.40MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP6 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010749: Generate average cost does not calculate properly end date | |||||||
| Description | End dates are not properly calculated when generate average cost is executed. In our scenario a permanent cost is introduced. Then a purchase order + good receipt is created. After executing it, end dates are the same. Also it happens if more purchase orders + good receipts are created. Please, see attached file | |||||||
| Steps To Reproduce | Go to Master Data Management > Product. Create a new one and select Average as Cost type. Go to Costing tab and generate a new record. Select Permanent, and Manual. Enter as Starting date, quantity and price. Go to Procurement management > Transactions > Purchase Order. Create a new one with this product. Process it. Go to Procurement management > Transactions > Good Receipt. Create a new one with same partner. Use "Create lines from" button to enter its lines. Select the previous Order to select it line. Complete it. Go to Warehouse Management > Transactions > Generate average cost. Execute it. Go back to Costing tab, in Product window. See end dates. They are wrong. | |||||||
| Tags | 250MP8, main | |||||||
| Attached Files |  Pantallazo.png [^] (222,655 bytes) 2009-09-24 17:44
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0020346) networkb (developer) 2009-09-24 17:45 |
It also has been tested in MP9, and also it fails |
|
(0020347) hgbot (developer) 2009-09-24 19:13 |
Repository: erp/devel/pi Changeset: f12253b7af5cbcf024bea1456e607c36cd646616 Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Thu Sep 24 19:11:57 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^] Fixed issue 10749. Changed the initial dateTo calculation. --- M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml --- |
|
(0020511) hgbot (developer) 2009-09-29 14:18 |
Repository: erp/devel/pi-pageddatagrid Changeset: f12253b7af5cbcf024bea1456e607c36cd646616 Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Thu Sep 24 19:11:57 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^] Fixed issue 10749. Changed the initial dateTo calculation. --- M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml --- |
|
(0020814) sureshbabu (reporter) 2009-10-07 09:48 edited on: 2009-10-08 08:59 |
Hi Gorka, Kindly let me know what is the fix here, since i am not finding any difference to the one reported by the user. |
|
(0021094) networkb (developer) 2009-10-16 09:38 |
Please, reopen the issue because the solution provided is not right. |
|
(0021122) gorkaion (developer) 2009-10-16 17:10 |
Hi, suresh, to reproduce the issue you have the date of the first fixed cost has to be later than the firs receipt. good receipt 2009-09-10 fixed cost 2009-10-10 good receipt 2009-11-10 the solution to the issue described is right so I won't open this one. Please open a new one in order to study why it is still failing. |
|
(0021123) networkb (developer) 2009-10-16 17:15 |
Function fails when products were created with ad_client_id = 0, and are used in diferent clients. |
|
(0021240) arunkumar (reporter) 2009-10-21 08:36 edited on: 2009-10-21 08:41 |
Still I see the end dates are 31-12-9999 for the created Goods Receipt.I do not find the fix here. |
|
(0021363) gorkaion (developer) 2009-10-23 14:02 |
Go to Master Data Management > Product. Create a new one and select Average as Cost type. Go to Costing tab and generate a new record. Select Permanent, and Manual. Enter as Starting date=01-10-2009, quantity=10, price=10 and cost=10. Go to Procurement management > Transactions > Purchase Order. Create a new one with this product with date ordered 01-09-2009. Process it. Go to Procurement management > Transactions > Good Receipt. Create a new one with same partner with date 01-09-2009. Use "Create lines from" button to enter its lines. Select the previous Order to select it line. Complete it. Create a new order and receipt following previous steps with date 01-11-2009. Go to Warehouse Management > Transactions > Generate average cost. Execute it. Go back to Costing tab, in Product window to check the results. Expected results are: good receipt. datefrom 01-09-2009 dateto 01-10-2009 fixed cost datefrom 01-10-2009 dateto 01-11-2009 good receipt datefrom 01-11-2009 dateto 31-12-9999 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-24 17:44 | networkb | New Issue | |
| 2009-09-24 17:44 | networkb | Assigned To | => rafaroda |
| 2009-09-24 17:44 | networkb | File Added: Pantallazo.png | |
| 2009-09-24 17:45 | networkb | Target Version | => 2.40MP11 |
| 2009-09-24 17:45 | networkb | Note Added: 0020346 | |
| 2009-09-24 18:04 | psarobe | Status | new => scheduled |
| 2009-09-24 18:04 | psarobe | Assigned To | rafaroda => gorkaion |
| 2009-09-24 18:04 | psarobe | fix_in_branch | => pi |
| 2009-09-24 19:13 | hgbot | Checkin | |
| 2009-09-24 19:13 | hgbot | Note Added: 0020347 | |
| 2009-09-24 19:13 | hgbot | Status | scheduled => resolved |
| 2009-09-24 19:13 | hgbot | Resolution | open => fixed |
| 2009-09-24 19:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^] |
| 2009-09-25 07:05 | rafaroda | Priority | immediate => high |
| 2009-09-25 07:05 | rafaroda | fix_in_branch | pi => |
| 2009-09-29 14:18 | hgbot | Checkin | |
| 2009-09-29 14:18 | hgbot | Note Added: 0020511 | |
| 2009-09-29 14:18 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^] |
| 2009-10-07 09:48 | sureshbabu | Note Added: 0020814 | |
| 2009-10-08 08:59 | sureshbabu | Note Edited: 0020814 | |
| 2009-10-16 09:38 | networkb | Note Added: 0021094 | |
| 2009-10-16 17:10 | gorkaion | Note Added: 0021122 | |
| 2009-10-16 17:15 | networkb | Note Added: 0021123 | |
| 2009-10-16 17:47 | gorkaion | Relationship added | related to 0011020 |
| 2009-10-21 08:36 | arunkumar | Note Added: 0021240 | |
| 2009-10-21 08:41 | sureshbabu | Note Edited: 0021240 | |
| 2009-10-22 19:26 | psarobe | Tag Attached: main | |
| 2009-10-22 19:33 | psarobe | Tag Attached: 250MP8 | |
| 2009-10-23 14:02 | gorkaion | Note Added: 0021363 | |
| 2009-10-26 11:41 | plujan | Status | resolved => closed |
| 2009-10-27 00:00 | anonymous | sf_bug_id | 0 => 2886771 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |