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

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #36681		[ 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-25 12:01 by aferraz
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>

Revision	2017-08-22 13:00 by ngarcia
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 Assign a locator to it in the Manufacturing tab 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>

Revision	2017-08-22 12:58 by ngarcia
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 Assign a locator to it in the Manufacturing tab Create an Actity Create a Process Plan, Version and Operatio 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>

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);