Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0027879 | Openbravo ERP | 04. Warehouse management | public | 2014-10-15 16:21 | 2014-10-28 10:38 |
| 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 | 0027879: Inventory Amount seems to be creating wrong calculated backdated transactions | ||||
| Description | Inventory Amount seems to be creating wrong calculated backdated transactions | ||||
| Steps To Reproduce | Select QA Testing client. Make sure you have a costing rule pointing to an Average costing rule. Costing rule needs also to have enabled "Fixed Backdated Transactions" check. Go to Product window and create a new product named Costing F2. Go to lines tab, select "Purchase" price list and enter a unit/list price of 1230. Go to purchase order and create a new one for Spain org and the product just created. Go to lines tab and enter 185 units. Book the order. Go to goods receipt and create a new one dated on a later date than the order. Create receipt lines from the order. Complete. Go to Process Request window and execute costing background process. Go to back to the receipt and post it. Realize that value posted to the ledger is 227550 (185*1230) Go to Goods Shipment window and create a new one for Spain org and the product. Goods shipment date needs to be after receipt date. Ship an amount of 85 units. Complete. Go to Process Request window and execute costing background process. Go to back to the shipment and post it. Realize that value posted to the ledger is 104550 (85*1230) Go to Inventory Amount Update window and create a new one dated before the shipment and after the receipt. Go to lines and enter same reference date as the one enter in the header. Select the product (Costing F2) and realize that Openbravo shows below values: - Current inventory amount = 227550 - On hand qty = 185 Enter 1200 in the field "Unit Cost", therefore Inventory Amount field is automatically populated with a value of 222000 Process Inventory Amount Update. Go to Process Request window and execute costing background process. Back to Inventory Amount Update window realize that a closing and an opening inventory have been created in "Inventories" tab. Navigate to closing one and post it. Posting would look like: Debit: Inventory Loss 227550 Credit: Product Asset 227550 Navigate to Opening one and post it. Posting would look like: Debit: Product Asset 222000 Credit: Inventory Loss 222000 Navigate to Cost Adjustment window and realize that two backdated transactions cost adjustments have been created. First one adjust closing inventory (I+ -185) by removing total current inventory value. Adjustment Amount is -227550. (I think the adjustment amount of this transaction should be 0,00 because otherwise we get into a double posting: Closing inventory posting = Backdated transaction posting Debit: Inventory Loss 227550 Credit: Product Asset 227550) Second one adjust: - opening inventory (I+ 185) for an 0 adjustment, as opening inventory has already increased inventory by new inventory amount value 222000 - and the shipment (C -85), however this adjustment is not correct. Adjusted amount is 102000. This is not correct. Navigate to product window, search by the product and go to Costing tab. Realize that new cost shown is not 1200 but the sum of 1200+1230)2430 | ||||
| Proposed Solution | Adjusted amount should be the difference between 85*1200 and 85*1230 = 2550 New costing should be 1200 | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2014-10-15 16:21 | psanjuan | New Issue | |||
| 2014-10-15 16:21 | psanjuan | Assigned To | => dmiguelez | ||
| 2014-10-15 16:21 | psanjuan | Modules | => Core | ||
| 2014-10-15 16:21 | psanjuan | Triggers an Emergency Pack | => No | ||
| 2014-10-15 16:27 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6791#r6791 | ||
| 2014-10-15 16:35 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6792#r6792 | ||
| 2014-10-15 16:35 | psanjuan | Proposed Solution updated | |||
| 2014-10-15 16:50 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6793#r6793 | ||
| 2014-10-24 08:57 | psanjuan | Assigned To | dmiguelez => umartirena | ||
| 2014-10-24 14:05 | hgbot | Checkin | |||
| 2014-10-24 14:05 | hgbot | Note Added: 0071171 | |||
| 2014-10-24 14:05 | hgbot | Status | new => resolved | ||
| 2014-10-24 14:05 | hgbot | Resolution | open => fixed | ||
| 2014-10-24 14:05 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/cf6c89b67300b9aa326ee675fac42153b1e347c2 [^] | ||
| 2014-10-28 10:38 | psanjuan | Note Added: 0071212 | |||
| 2014-10-28 10:38 | psanjuan | Status | resolved => closed | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||