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'
Now Check this problem is resolved
call me 677
(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
item name = 1 Ltr c/box imis code = PM-BVG-NMW-CB-1000M S/T = 002 IMIS STOCK QTY= 8815 PCS