Bug 637

Summary: Make procedure Stock qty not going negtive
Product: [01.IMIS] IMIS STORES AND INVENTORY Reporter: Mahender <mahender.singh>
Component: IMIS INVENTORY FORMS AND REPORTSAssignee: Mahender <mahender.singh>
Status: RESOLVED FIXED    
Severity: normal CC: sharad.sharma
Priority: Normal    
Version: unspecified   
Hardware: PC   
OS: Windows   
Database: DPPC, DS Module ID: Make procedure

Comment 2 Mahender 2019-09-24 12:51:03 IST 
THIS IS DONE
Comment 1 Mahender 2019-08-12 15:32:16 IST 
SELECT
	 COMPANY_CODE
	,STORE_CODE
	,ITEM_CODE
	,STOCK_TYPE
	,PKG_IC.GET_STOCK_NAME(ITEM_CODE ,STOCK_TYPE) STOCK_NAME
	,SUM(NVL(STOCK_DR_PKS,0)- NVL(STOCK_CR_PKS,0)) PKS_BALANCE
	,SUM(NVL(STOCK_DR_QTY,0)- NVL(STOCK_CR_QTY,0)) QTY_BALANCE
 FROM VW_IC_STOCK_DETAIL
 GROUP BY
 	 COMPANY_CODE
	,STORE_CODE
	,ITEM_CODE
	,STOCK_TYPE
HAVING (SUM(NVL(STOCK_DR_PKS,0)- NVL(STOCK_CR_PKS,0)) <0 OR SUM(NVL(STOCK_DR_QTY,0)- NVL(STOCK_CR_QTY,0)) <0)
ORDER BY
	 COMPANY_CODE
	,STORE_CODE
	,ITEM_CODE
	,STOCK_TYPE
Description Mahender 2019-08-12 15:30:46 IST 
Make procedure stock qty not going negative run on daily basis