Bug 6453

Summary: Request for Query
Product: [01.IMIS] IMIS PURCHASE Reporter: Shilpa Srivastava <shilpa.srivastava>
Component: IMIS PURCHASE FORMS AND REPORTSAssignee: anushree.pandey
Status: RESOLVED USER TO VERIFY    
Severity: enhancement CC: amit.madaan, sharad.sharma
Priority: ---    
Version: unspecified   
Hardware: PC   
OS: Windows   
Database: Module ID:
Attachments: GENERAL
RAW
ENG
PACKING

Comment 5 anushree.pandey 2021-06-16 12:03:13 IST
Please check
Comment 4 anushree.pandey 2021-06-16 12:01:50 IST
Created attachment 1962 [details]
PACKING
Comment 3 anushree.pandey 2021-06-16 12:00:01 IST
Created attachment 1961 [details]
ENG
Comment 2 anushree.pandey 2021-06-16 11:59:27 IST
Created attachment 1960 [details]
RAW
Comment 1 anushree.pandey 2021-06-16 11:58:21 IST
Created attachment 1959 [details]
GENERAL

ATTACHED
Description Shilpa Srivastava 2021-05-23 16:11:23 IST
Dear Madam,

As discussed, we require a query that how many numbers of an active user has made the GRN of the following items during the specific period. 

•	General items
•	Packing Material
•	Raw Material

These details would be required in the following format:-
•	Company code.
•	Company Name. 
•	GRN type (i.e. Creation of GRN of General items, Packing material items, raw material items)
•	User Code. 
•	User name. 
•	User Department. 
•	No’s of GRN created. 

Note :- Further, query will be required for approval of GRN ( Raw, Packing, General Items)

This query is required to withdraw the rights of those users whose having a right of preparation of GRN but don’t make any entry of creation of GRN in IMIS.



Regards!
Amit madaan