Bug 766

Summary: item not transfer 000 to 029 store
Product: [01.IMIS] IMIS STORES AND INVENTORY Reporter: Om prakash <om.prakash>
Component: IMIS INVENTORY FORMS AND REPORTSAssignee: Mahender <mahender.singh>
Status: RESOLVED FIXED    
Severity: critical CC: sharad.sharma
Priority: Normal    
Version: unspecified   
Hardware: PC   
OS: Windows   
Database: DS Module ID: (PM) INTER STORE TRANSFER

Comment 5 Mahender 2019-09-18 13:17:49 IST 
INSERT INTO STOCK_TYPES (COMPANY_CODE,STORE_CODE,ITEM_CLASS,ITEM_CODE,STOCK_TYPE,STOCK_NAME,DESCRIPTION,IUOM_CODE,NET_LENGTH,NET_WEIGHT,TOT_WEIGHT,QTY_IN_PACK,QTY_IN_CASE,PACKING_TYPE,PACKING_QTY,REF_STOCK_TYPE,ITEM_LOCATION,STOCK_IT_QTY,STOCK_IT_VAL,AVERAGE_RATE,MINIMUM_LEVEL,MAXIMUM_LEVEL,REORDER_LEVEL,REORDER_QTY,ABC_CODE,VED_CODE,COMMODITY_CODE,LAST_RCPT_DATE,LAST_RCPT_QTY,LAST_ISSUE_DATE,LAST_ISSUE_QTY,AVG_ACQUIRING_COST,ANNUAL_CONSUMPTION,QC_TEMPLATE_CODE,PRICE_GROUP,REMARKS,STATUS,CREATED_BY,CREATED_ON,LAST_UPD_BY,LAST_UPD_ON,CARTON_CODE,RESERVED_QTY)

SELECT COMPANY_CODE,'000',ITEM_CLASS,ITEM_CODE,STOCK_TYPE,STOCK_NAME,DESCRIPTION,IUOM_CODE,NET_LENGTH,NET_WEIGHT,TOT_WEIGHT,QTY_IN_PACK,QTY_IN_CASE,PACKING_TYPE,PACKING_QTY,REF_STOCK_TYPE,ITEM_LOCATION,26750,0,AVERAGE_RATE,MINIMUM_LEVEL,MAXIMUM_LEVEL,REORDER_LEVEL,REORDER_QTY,ABC_CODE,VED_CODE,COMMODITY_CODE,LAST_RCPT_DATE,LAST_RCPT_QTY,LAST_ISSUE_DATE,LAST_ISSUE_QTY,AVG_ACQUIRING_COST,ANNUAL_CONSUMPTION,QC_TEMPLATE_CODE,PRICE_GROUP,REMARKS,STATUS,CREATED_BY,CREATED_ON,LAST_UPD_BY,LAST_UPD_ON,CARTON_CODE,RESERVED_QTY FROM STOCK_TYPES
WHERE COMPANY_CODE = '15' AND ITEM_CODE        =    'PM-BVG-NMW-CB-1000M'  AND STOCK_TYPE = '001' and store_code = '029'
Comment 4 Mahender 2019-08-21 16:58:41 IST 
Now Check this problem is resolved
Comment 2 Mahender 2019-08-21 16:52:25 IST 
call me 677
Comment 1 Om prakash 2019-08-21 16:30:49 IST 
(In reply to Om prakash from comment #0)
> item name = 1 Ltr c/box
> 
> imis code  = PM-BVG-NMW-CB-1000M
> 
> S/T        = 002
> 
> IMIS STOCK QTY= 8815  PCS

COMPANY   = 15
Description Om prakash 2019-08-21 16:28:42 IST 
item name = 1 Ltr c/box

imis code  = PM-BVG-NMW-CB-1000M

S/T        = 002

IMIS STOCK QTY= 8815  PCS