Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0030104 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 05. Production management | critical | always | 2015-05-28 10:10 | 2015-06-05 11:42 | |||
| Reporter | VictorVillar | View Status | public | |||||
| Assigned To | jorge-garcia | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 1220b2019c52 | ||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q2.2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | vmromanos | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0030104: Completed quantity in the Work Requirement is not updated under some circumstancies | |||||||
| Description | Completed quantity in the Work Requirement is not updated under some circumstancies | |||||||
| Steps To Reproduce | As group Admin role, Navigate to Product window: Check Production = YES for Cerverza Ale Cerveza Lager For Cerveza Ale go to Manufacturing Tab: create a new register: Organization España Región Norte Storage Bin: RN-0-0-0 Cerveza Lager should not have any register in the Manufacturing tab. Go to Process Plan window: Organization: * Name: Test Version tab: Starting Date: 01-01-2014 Ending Date: 31-10-9999 Operation tab: Name: sec Activity: Actividad I/O Products tab New register: P+ Cerveza Ale, Qty: 1 New register: P- Cerveza Lager Qty: 1 Go to Work Requirement window, Starting Date: Today Ending Date: today Process Plan: Test Organization: España Región Norte Qty: 5 Click on Process Work Requirement button Realise that the Operation and Products have been populated with the Process Plan data Go to Operation tab and edit the register (grid view). DO NOT save the register. Keep it in 'editing' status. Go to Work Effort window: Organization: España Región Norte Starting time: 2 Ending Time: 3 Go to Production Run tab: Select the Work Requirement Phase created before Completed Qty: 1 Click on Create Standards button and validate the Work Effort. Go to Work Requirement window | operation tab again, and save the register. Realise that the Completed qty is not updated. It is still showing 0. The problem is that there is not detection when you are going to save the register that this record has been changed. the ma_workeffort_validate function is not updating the 'updated' column of the ma_wrphase table. | |||||||
| Proposed Solution | Possible solution: FOR Cur_ProductionPlan IN (SELECT * FROM M_PRODUCTIONPLAN pp WHERE pp.M_PRODUCTION_ID=v_Record_ID) LOOP UPDATE MA_WRPHASE SET DONEQUANTITY=DONEQUANTITY + Cur_ProductionPlan.PRODUCTIONQTY, RUNTIME=Cur_ProductionPlan.RUNTIME, +++++++++ UPDATED = NOW() WHERE MA_WRPhase_ID=Cur_ProductionPlan.MA_WRPHASE_ID; | |||||||
| Tags | Approved | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0078117) hgbot (developer) 2015-06-05 11:42 |
Repository: erp/backports/3.0PR15Q2.2 Changeset: 1220b2019c52bf8b92324a33292413c0ec31b040 Author: Jorge Garcia <jorge.garcia <at> openbravo.com> Date: Tue Jun 02 09:06:32 2015 +0200 URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.2/rev/1220b2019c52bf8b92324a33292413c0ec31b040 [^] Fixed issue 30104: Completed quantity in the Work Requirement is not updated Completed quantity in the Work Requirement is not updated under some circumstances. The problem was that the ma_workeffort_validate wasn't updated the UPDATED column of the ma_wrpahse table and you can save even if the line had changed in the work effort window. The solution is to update the column with the actual date. Now, when you try to save it, a error appears in the grid and the save is canceled. --- M src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml --- |
|
(0078118) hgbot (developer) 2015-06-05 11:42 |
Repository: erp/backports/3.0PR15Q2.2 Changeset: fd3e0e612ca4714d10af14d29badf35f7e3fbd65 Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Thu Jun 04 17:02:09 2015 +0200 URL: http://code.openbravo.com/erp/backports/3.0PR15Q2.2/rev/fd3e0e612ca4714d10af14d29badf35f7e3fbd65 [^] Related to issue 30104: updated copyright --- M src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml --- |
|
(0078119) vmromanos (manager) 2015-06-05 11:42 |
Code review + testing OK |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-06-05 09:35 | vmromanos | Type | defect => backport |
| 2015-06-05 09:35 | vmromanos | Target Version | 3.0PR15Q3 => 3.0PR15Q2.2 |
| 2015-06-05 09:42 | vmromanos | Tag Attached: Approved | |
| 2015-06-05 11:42 | hgbot | Checkin | |
| 2015-06-05 11:42 | hgbot | Note Added: 0078117 | |
| 2015-06-05 11:42 | hgbot | Status | scheduled => resolved |
| 2015-06-05 11:42 | hgbot | Resolution | open => fixed |
| 2015-06-05 11:42 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/1fe773745b2d0adaf31912c6d7e8372bb1c97d65 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q2.2/rev/1220b2019c52bf8b92324a33292413c0ec31b040 [^] |
| 2015-06-05 11:42 | hgbot | Checkin | |
| 2015-06-05 11:42 | hgbot | Note Added: 0078118 | |
| 2015-06-05 11:42 | vmromanos | Note Added: 0078119 | |
| 2015-06-05 11:42 | vmromanos | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |