0036681: Insufficient stock in Create Standards Process of Work Effort - Production Run tab if decimal quantities are consumed

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0036681

Openbravo ERP

05. Production management

public

2017-08-21 15:07

2017-09-21 16:49

Reporter

ngarcia

Assigned To

markmm82

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR17Q4

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

47839

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0036681: Insufficient stock in Create Standards Process of Work Effort - Production Run tab if decimal quantities are consumed

Description

Insufficient stock in Create Standards Process of Work Effort - Production Run tab if decimal quantities are consumed and the stock is not in the same locator

The problem is that in M_GET_STOCK_PARAM function v_Quantity variable does not accept decimals:

v_Quantity NUMERIC(10);

and the next records from M_STOCK_PROPOSED table are deleted in the following piece of code:

      IF (v_qtyaux <= 0) THEN
        DELETE FROM m_stock_proposed
        WHERE ad_pinstance_id = p_uuid
          AND (priority > cur_warehouse.priority
              OR isfinal = 'N');
        EXIT;
      END IF;

Steps To Reproduce

As group admin role:
   Create a new warehouse for F&B España Region Norte
   Add a locator to it
   Increase its Relative Priority to 100
   Assign it as on hand warehouse to F&B España Region Norte organization

   Create a new product: consumed
   Set it as production
   Add 4 units of it in Region Norte warehouse
   Add more units of it in the new created warehouse

   Create a new product: produced
   Set it as production
   Create a record in Manufacturing tab for España Norte org and any locator

   Create an Activity
   Create a Process Plan, Version and Operation
   Set Create Standards to 'N'
   Add 4.4 units of the previously created product to be consumed (P-)
   Add 1 unit of the previously created product to be produced (P+)

   Create a Work Requirement for that Process Plan and process it (Quantity: 1)
   Create Work Effort
   Go to Work Effort - Production Run tab, set Completed Quantity to 1 and Create Standards
   You will get the following error:
      Insufficient stock:: <productName>

Proposed Solution

Additional Information