Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0026789 | Openbravo ERP | 04. Warehouse management | public | 2014-06-04 19:03 | 2014-10-01 16:49 |
| Reporter | VictorVillar | ||||
| Assigned To | caristu | ||||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | 3.0PR14Q3 | Fixed in Version | |||
| Merge Request Status | |||||
| Review Assigned To | VictorVillar | ||||
| OBNetwork customer | OBPS | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | 28653 | ||||
| Regression level | Production - Confirmed Stable | ||||
| Regression date | 2013-09-13 | ||||
| Regression introduced in release | 3.0MP28 | ||||
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/668effe90d34780551c9f1de1285022fc505ec66 [^] | ||||
| Triggers an Emergency Pack | Yes | ||||
| Summary | 0026789: It is not possible to migrate to the new costing server under some circumstancies | ||||
| Description | It is not possible to migrate to the new costing server under some circumstancies, if you are using second unit of measure (and you have stock) and the main uom is 0. | ||||
| Steps To Reproduce | It is not possible to migrate to the new costing server under some circumstancies, if you are using second unit of measure (and you have stock) and the main uom is 0. You will receive a Null Pointer Exception after launching the Costing Background Process. The reason is that the product will be taken into account in the closing inventories but after processing it, the transaction will no be created because the following statement in the inventorycountprocess.java: insert.append(" and e." + InventoryCountLine.PROPERTY_QUANTITYCOUNT + " != e." + InventoryCountLine.PROPERTY_BOOKQUANTITY); so when the process tries to calculate the cost for the opening inventory, it will not find any transaction. | ||||
| Proposed Solution | The reason is that the product will be taken into account in the closing inventories but after processing it, the transaction will no be created because the following statement in the inventorycountprocess.java: insert.append(" and e." + InventoryCountLine.PROPERTY_QUANTITYCOUNT + " != e." + InventoryCountLine.PROPERTY_BOOKQUANTITY); Also, it should be added the following statement in the processInventory() method as a restriction: insert.append(" and (e." + InventoryCountLine.PROPERTY_QUANTITYCOUNT + " != e." + InventoryCountLine.PROPERTY_BOOKQUANTITY); insert.append(" or e." + InventoryCountLine.PROPERTY_ORDERQUANTITY + " != e." + InventoryCountLine.PROPERTY_QUANTITYORDERBOOK+")"); | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2014-06-04 19:03 | VictorVillar | New Issue | |||
| 2014-06-04 19:03 | VictorVillar | Assigned To | => caristu | ||
| 2014-06-04 19:03 | VictorVillar | Modules | => Core | ||
| 2014-06-04 19:03 | VictorVillar | OBNetwork customer | => Yes | ||
| 2014-06-04 19:03 | VictorVillar | Support ticket | => 28653 | ||
| 2014-06-04 19:03 | VictorVillar | Triggers an Emergency Pack | => No | ||
| 2014-06-04 19:04 | VictorVillar | Issue Monitored: networkb | |||
| 2014-06-04 19:07 | VictorVillar | Regression level | => Production - Confirmed Stable | ||
| 2014-06-04 19:07 | VictorVillar | Regression date | => 2013-09-13 | ||
| 2014-06-04 19:07 | VictorVillar | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/668effe90d34780551c9f1de1285022fc505ec66 [^] | ||
| 2014-06-04 19:07 | VictorVillar | Triggers an Emergency Pack | No => Yes | ||
| 2014-06-04 19:08 | VictorVillar | Proposed Solution updated | |||
| 2014-06-06 08:46 | VictorVillar | Proposed Solution updated | |||
| 2014-06-09 09:24 | VictorVillar | Proposed Solution updated | |||
| 2014-06-09 10:33 | hgbot | Checkin | |||
| 2014-06-09 10:33 | hgbot | Note Added: 0067818 | |||
| 2014-06-09 10:33 | hgbot | Status | new => resolved | ||
| 2014-06-09 10:33 | hgbot | Resolution | open => fixed | ||
| 2014-06-09 10:33 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e7a946efecef3532f4188fa3bf70a4cab386a670 [^] | ||
| 2014-06-09 10:38 | VictorVillar | Review Assigned To | => VictorVillar | ||
| 2014-06-09 10:38 | VictorVillar | Note Added: 0067819 | |||
| 2014-06-09 10:38 | VictorVillar | Status | resolved => closed | ||
| 2014-06-10 22:24 | hudsonbot | Checkin | |||
| 2014-06-10 22:24 | hudsonbot | Note Added: 0067890 | |||
| 2014-10-01 16:49 | plujan | Regression introduced in release | => 3.0MP28 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||