Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0027884 | Openbravo ERP | 04. Warehouse management | public | 2014-10-16 10:59 | 2014-12-30 23:23 |
| Reporter | psanjuan | ||||
| Assigned To | umartirena | ||||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | Ubuntu 8.04.1 | |
| Product Version | |||||
| Target Version | 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 | 0027884: New lines created in costing tab which should not be there | ||||
| Description | New lines created in costing tab which should not be there | ||||
| Steps To Reproduce | In QA testing Client, go to Product window and create a new one named "Costing V11". Go to Price tab, select purchase price list and enter a unit/list price of 20. Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000. Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000. Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders and select first order, enter a storage bin. Repeat the process with second order. Above means to receipt all quantity, that is 300 units. Complete the receipt. Go to process request window and run costing background process. Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 15 Quantity 200. Total Qty 200. Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 100. Total Qty 300. Ending date 31-12-9999 Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units). Go to goods shipment window and create a new one dated on 25/10/2014 for Spain and product Costing V11, for a total amount of 150 units. Complete shipment. Go to process request window and run costing background process. Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67). Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are three lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300 Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150. Ending date 31-12-9999 (this is not correct) Correct should be: Line 1 - inventory transaction V+ 20/10/2014 Cost 15 Quantity 200. Total Qty 200. Line 2 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 300. Ending date 31-12-9999 Go to purchase invoice window and create a new invoice dated on 24/10/2014 for Spain org. Create lines from order dated on 15/10/2014, that means 200 units at 15 €/unit. Change the price to 20 €/unit. Complete and Post the invoice. Go to process request window and run price correction background process. Go to product window, search the product and go to "Costing" tab. Realize that there are four lines as explained below: Line 1 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 100. Total Qty 100 Line 2 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 200. Total Qty 300 Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150. Line 4 - no inventory transaction Cost 21.67 Total movement quantity 150. Ending date 31-12-2014 (this is not correct) Correct should be: Line 1 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 200. Total Qty 200. Line 2 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 100. Total Qty 300. Ending date 31-12-9999 | ||||
| Proposed Solution | See above. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2014-10-16 10:59 | psanjuan | New Issue | |||
| 2014-10-16 10:59 | psanjuan | Assigned To | => dmiguelez | ||
| 2014-10-16 10:59 | psanjuan | Modules | => Core | ||
| 2014-10-16 10:59 | psanjuan | Triggers an Emergency Pack | => No | ||
| 2014-10-16 11:06 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6801#r6801 | ||
| 2014-10-16 11:18 | psanjuan | Assigned To | dmiguelez => umartirena | ||
| 2014-10-16 11:18 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6802#r6802 | ||
| 2014-10-16 11:24 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6803#r6803 | ||
| 2014-10-16 11:26 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6804#r6804 | ||
| 2014-10-16 11:36 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6805#r6805 | ||
| 2014-10-16 12:05 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6809#r6809 | ||
| 2014-10-16 12:10 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6810#r6810 | ||
| 2014-10-16 12:10 | psanjuan | Proposed Solution updated | |||
| 2014-10-16 12:13 | psanjuan | Note Added: 0070989 | |||
| 2014-10-20 17:56 | hgbot | Checkin | |||
| 2014-10-20 17:56 | hgbot | Note Added: 0071058 | |||
| 2014-10-20 17:56 | hgbot | Status | new => resolved | ||
| 2014-10-20 17:56 | hgbot | Resolution | open => fixed | ||
| 2014-10-20 17:56 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/25c3153c137c66d01ed33051b8cdec206870f233 [^] | ||
| 2014-10-21 12:00 | psanjuan | Note Added: 0071076 | |||
| 2014-10-21 12:00 | psanjuan | Status | resolved => closed | ||
| 2014-10-23 08:46 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6878#r6878 | ||
| 2014-12-30 23:23 | hudsonbot | Checkin | |||
| 2014-12-30 23:23 | hudsonbot | Note Added: 0072952 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||