Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0010749 | Openbravo ERP | 04. Warehouse management | public | 2009-09-24 17:44 | 2009-10-27 00:00 |
|
| Reporter | networkb | |
| Assigned To | gorkaion | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.40MP6 | |
| Target Version | 2.40MP11 | Fixed in Version | | |
| 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 | 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.
|
| Proposed Solution | |
| Additional Information | |
| Tags | 250MP8, main |
| Relationships | | depends on | backport | 0010751 | 2.40MP11 | closed | gorkaion | Generate average cost does not calculate properly end date | | related to | defect | 0011020 | 2.40MP11 | closed | gorkaion | Generate Average cost does not work properly if products have ad_client_id = 0 |
|
| Attached Files |  Pantallazo.png (222,655) 2009-09-24 17:44
https://issues.openbravo.com/file_download.php?file_id=1783&type=bug
|
|
| 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 |
|
Notes |
|
|
|
|
It also has been tested in MP9, and also it fails |
|
|
|
(0020347)
|
|
hgbot
|
|
2009-09-24 19:13
|
|
|
|
|
(0020511)
|
|
hgbot
|
|
2009-09-29 14:18
|
|
|
|
|
(0020814)
|
|
sureshbabu
|
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.
|
|
|
|
|
|
Please, reopen the issue because the solution provided is not right. |
|
|
|
|
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. |
|
|
|
|
|
Function fails when products were created with ad_client_id = 0, and are used in diferent clients. |
|
|
|
(0021240)
|
|
arunkumar
|
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.
|
|
|
|
|
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 |
|