Bug 10019

Summary:	Implement of making quality report through ERP
Product:	[01.IMIS] IMIS FORMS AND REPORTS	Reporter:	HARISH YADAV <harish.yadav>
Component:	IMIS FORMS AND REPORTS	Assignee:	Sharad <sharad.sharma>
Status:	RESOLVED USER TO VERIFY
Severity:	normal	CC:	mahender.singh, sharad.sharma
Priority:	Normal
Version:	unspecified
Hardware:	PC
OS:	Windows
Database:		Module ID:
Attachments:	qc report qc report

Comment 19 HARISH YADAV 2023-02-17 11:07:20 IST

Also required grand total ( material and inspected quantity )in a monthly report

Comment 18 Sharad 2023-02-17 10:55:18 IST

Done


Please change name of the monthly report (QCMR0150) to Monthly packaging material
inspection report (QCMR0150).

Comment 17 HARISH YADAV 2023-02-17 10:46:49 IST

Please change name of the monthly report to Monthly packaging material inspection report.

Comment 16 Sharad 2023-01-30 13:30:28 IST

Done 

Kindly check & confirm.

Comment 15 anushree.pandey 2023-01-30 11:22:06 IST

Rights Given..

Comment 11 anushree.pandey 2023-01-25 12:57:22 IST

rights Given..

Comment 7 Sharad 2023-01-25 10:37:18 IST

working...

Comment 6 Mahender 2023-01-13 11:15:32 IST

DROP TABLE QUALITY_ITEM_MASTER;
CREATE TABLE QUALITY_ITEM_MASTER (ITEM_CODE 	VARCHAR2(30)
								 ,STOCK_TYPE	VARCHAR2(10)
								 ,DESCRIPTION 	VARCHAR2(250)
								 ,STATUS		VARCHAR2(1)
								 ,CREATED_BY	VARCHAR2(10)
								 ,CREATED_ON	DATE
								 ,LAST_UPD_BY	VARCHAR2(10)
								 ,LAST_UPD_ON	DATE,
CONSTRAINT QUALITY_PK PRIMARY KEY (ITEM_CODE,STOCK_TYPE));

DROP TABLE QUALITY_INSPECTION_PARAM;
CREATE TABLE QUALITY_INSPECTION_PARAM (ITEM_CODE 			VARCHAR2(20)
									  ,INSPECTION_CODE 		VARCHAR(20)
									  ,VISUAL_DESCRIPTION 	VARCHAR2(250)
									  ,SUPP_DESCRIPTION 	VARCHAR2(250)
									  ,STATUS				VARCHAR2(1)
								 	  ,CREATED_BY			VARCHAR2(10)
								 	  ,CREATED_ON			DATE
								 	  ,LAST_UPD_BY			VARCHAR2(10)
								 	  ,LAST_UPD_ON			DATE,
CONSTRAINT QUALITY_INSP_PARAM_PK PRIMARY KEY (ITEM_CODE,INSPECTION_CODE));

DROP TABLE QUALITY_INSPECTION;
CREATE TABLE QUALITY_INSPECTION(QUALITY_INSP_RECID	NUMBER(16) NOT NULL
								,DOCUMENT_DATE		DATE
								,DOCUMENT_TYPE		VARCHAR2(2)
								,DOCUMENT_SERIES	VARCHAR2(4)
								,DOCUMENT_NUMBER	NUMBER(9)
								,ENTRY_NUMBER		NUMBER(16)
								,ITEM_CODE			VARCHAR2(20)
								,SUPPLIER_CODE		VARCHAR2(20)
								,LOT_SIZE			NUMBER(6)
								,SAMPLE_SIZE		NUMBER(6)
								,BILL_NO			VARCHAR2(50)
								,BILL_DATE			DATE
								,STATUS				VARCHAR2(1)
								,CREATED_BY			VARCHAR2(10)
								,CREATED_ON			DATE
								,LAST_UPD_BY		VARCHAR2(10)
								,LAST_UPD_ON		DATE,
CONSTRAINT QUALITY_INSP_PK PRIMARY KEY (QUALITY_INSP_RECID));

DROP TABLE QUALITY_INSPECTION_TRANSACTION;
CREATE TABLE QUALITY_INSPECTION_TRANSACTION(QUALITY_INP_TRNS_RECID 	NUMBER(16) NOT NULL
											,QUALITY_INSP_RECID		NUMBER(16) NOT NULL
            			                    ,INSPECTION_CODE 		VARCHAR(20)
                        			        ,OBSERVATION			VARCHAR2(255)
                        			        ,REMARKS				VARCHAR2(255),
CONSTRAINT QUALITY_INSP_TRNS_PK PRIMARY KEY (QUALITY_INP_TRNS_RECID,QUALITY_INSP_RECID));

Comment 2 HARISH YADAV 2023-01-05 16:32:29 IST

Created attachment 3235 [details]
qc report

sample report attached

Comment 1 HARISH YADAV 2023-01-05 16:31:11 IST

Created attachment 3234 [details]
qc report

format of QC report attached for your reference

Description HARISH YADAV 2023-01-02 17:22:28 IST

I need to incorporate quality reports through the ERP system. So, please do the needful action from your end to implement quality reports through ERP.