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

Anonymous | Login

Project:

View Revisions: Issue #36681		[ All Revisions ] [ Back to Issue ]
Summary	0036681: Insufficient stock in Create Standards Process of Work Effort - Production Run tab if decimal quantities are consumed

Revision	2017-08-21 15:09 by ngarcia
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;

Revision	2017-08-21 15:07 by ngarcia
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);