Bug 1587 - Purchase Register Required
Summary: Purchase Register Required
Status: RESOLVED USER TO VERIFY
Alias: None
Product: IMIS PURCHASE
Classification: 01.IMIS
Component: IMIS PURCHASE FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: All All
: High major
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2019-10-16 17:49 IST by Internal Audit
Modified: 2019-11-05 18:11 IST (History)
2 users (show)

See Also:
Database:
Module ID:

Attachments
Format (9.59 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-10-16 17:49 IST, Internal Audit 		Details
Format in Xls (26.50 KB, application/vnd.ms-excel)
2019-10-16 18:04 IST, Internal Audit 		Details
Other format (9.38 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-10-17 11:14 IST, Internal Audit 		Details
IN PDF (69.18 KB, application/pdf)
2019-10-17 15:32 IST, Internal Audit 		Details
SPV detail (2.80 MB, application/x-rar)
2019-11-05 12:01 IST, Mahender 		Details
SPV detail (473.23 KB, application/vnd.ms-excel)
2019-11-05 12:48 IST, Mahender 		Details
SPV detail (6.22 MB, application/vnd.ms-excel)
2019-11-05 14:42 IST, Mahender 		Details
SPV detail (2.54 MB, application/x-rar)
2019-11-05 18:11 IST, Mahender 		Details
View All 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 19 Mahender 2019-11-05 18:11:01 IST 
Created attachment 469 [details]
SPV detail

CHECK ATTACHEMENT
Comment 17 Mahender 2019-11-05 17:45:02 IST 
SELECT 	 G.COMPANY_CODE
		,G.GATE_ENTRY_NUMBER
        ,G.GATE_ENTRY_DATE
        ,G.DOCUMENT_DATE
        ,G.DOCUMENT_TYPE
        ,G.DOCUMENT_SERIES
        ,G.DOCUMENT_NUMBER
        ,G.ENTRY_NUMBER
        ,G.PO_STRING
        ,P.PO_DATE
        ,P.ITEM_TOTAL_AMOUNT
        ,P.PO_INDENT_TYPE_REF
        ,P.PO_INDENT_SERIES_REF
        ,P.PO_INDENT_NO_REF
        ,P.PO_INDENT_SEQ_NO
        ,G.AREF_NUMBER Invoice_No
        ,G.AREF_DATE   Invoice_Date
        ,G.BILL_AMOUNT
        --,S.SPV_DATE
        --,S.SPV_TYPE
        --,S.SPV_SERIES
        --,S.SPV_NO
        ,G.SUPPLIER_CODE
		--,A.SUPPLIER_NAME
		,G.ITEM_CODE
		,G.STOCK_TYPE
		,G.IUOM_CODE
		--,ST.STOCK_NAME
		,G.QUANTITY
		,ROUND(G.ITEM_VALUE / G.QUANTITY,2) RATE
		,G.ITEM_VALUE
		,G.COST_AMOUNT
		,G.DUTY_AMOUNT
		,G.STAX_AMOUNT
		,G.CESS_AMOUNT
		,G.OTHR_AMOUNT
		,G.MVAT_AMOUNT
		,G.OVAT_AMOUNT
FROM VW_GOODS_PURCHASED G, PO_ITEMS P , SP_VOUCHERS S , ALL_SUPPLIERS A , ALL_STOCK_TYPES ST
WHERE G.PO_REF_TYPE 	= P.PO_TYPE
AND   G.PO_REF_SERIES	= P.PO_SERIES
AND   G.PO_REF_NUMBER	= P.PO_NO
AND   G.COMPANY_CODE	= P.COMPANY
AND   G.ITEM_CODE		= P.INVENTORY_ITEM_CODE
AND   G.STOCK_TYPE		= P.ITEM_STOCK_TYPE
AND   G.COMPANY_CODE	= S.COMPANY
AND   G.PB_REF_TYPE     = S.SPV_TYPE
AND   G.PB_REF_SERIES   = S.SPV_SERIES
AND   G.PB_REF_NUMBER   = S.SPV_NO
AND   G.SUPPLIER_CODE	= A.SUPPLIER_CODE
AND   G.ITEM_CODE		= ST.ITEM_CODE
AND   G.STOCK_TYPE 		= ST.STOCK_TYPE
AND   G.QUANTITY		> 0
AND   G.DOCUMENT_DATE   >='01/04/2019'
--AND   G.COMPANY_CODE    = '02'
--AND   G.ENTRY_NUMBER	= 9549
ORDER BY COMPANY_CODE,DOCUMENT_DATE
Comment 16 Internal Audit 2019-11-05 16:36:12 IST 
Still, Repetition Exists.
Column - Item Description and Vendor Master Missing.
Comment 15 Mahender 2019-11-05 14:42:39 IST 
Created attachment 464 [details]
SPV detail

Please check attachemnt
Comment 13 Mahender 2019-11-05 12:48:38 IST 
Created attachment 463 [details]
SPV detail
Comment 12 Mahender 2019-11-05 12:01:49 IST 
THIS IS DONE
Comment 11 Mahender 2019-11-05 12:01:26 IST 
Created attachment 462 [details]
SPV detail

THIS IS DONE CHECK ATTACHEMENT
Comment 9 Internal Audit 2019-10-31 11:07:15 IST 
Sir this form is Pending. Please give a Deadline date for Resolve of Query.
Comment 8 Internal Audit 2019-10-19 16:43:31 IST 
Any Status regarding Resolve of Call
Comment 7 Internal Audit 2019-10-18 15:07:18 IST 
I have already discussed the same.
Please Start Working on the call.
Comment 6 Mahender 2019-10-18 12:49:01 IST 
Please discuss with Mr. Amit
Comment 5 Internal Audit 2019-10-17 15:32:32 IST 
Created attachment 399 [details]
IN PDF
Comment 4 Mahender 2019-10-17 14:36:08 IST 
Attachment send in pdf format
Comment 3 Internal Audit 2019-10-17 11:14:51 IST 
Created attachment 395 [details]
Other format
Comment 2 Mahender 2019-10-17 11:04:25 IST 
Attachment not open
Comment 1 Internal Audit 2019-10-16 18:04:30 IST 
Created attachment 392 [details]
Format in Xls
Description Internal Audit 2019-10-16 17:49:58 IST 
Created attachment 390 [details]
Format

Please provide the Purchase Register in Attached Format for DPPC Limited (Apr'19 to Sept19)
Packing Material
Stores & Spares
General Items.