0030105: Completed quantity in the Work Requirement is not updated under some circumstancies

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0030105

Openbravo ERP

05. Production management

public

2015-05-28 10:10

2015-06-05 10:05

Reporter

VictorVillar

Assigned To

jorge-garcia

Priority

immediate

Severity

critical

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0PR15Q1.5

Fixed in Version

Merge Request Status

Review Assigned To

vmromanos

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

33059

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0030105: 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;

Additional Information