Bug 637 - Make procedure Stock qty not going negtive
Summary: Make procedure Stock qty not going negtive
Status: RESOLVED FIXED
Alias: None
Product: IMIS STORES AND INVENTORY
Classification: 01.IMIS
Component: IMIS INVENTORY FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: Normal normal
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2019-08-12 15:30 IST by Mahender
Modified: 2019-09-24 12:51 IST (History)
1 user (show)

See Also:
Database: DPPC, DS
Module ID: Make procedure

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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