| Summary: | Purchase Register Required | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS PURCHASE | Reporter: | Internal Audit <internalaudit> |
| Component: | IMIS PURCHASE FORMS AND REPORTS | Assignee: | Mahender <mahender.singh> |
| Status: | RESOLVED USER TO VERIFY | ||
| Severity: | major | CC: | internalaudit, sharad.sharma |
| Priority: | High | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Database: | Module ID: | ||
| Attachments: |
Format
Format in Xls Other format IN PDF SPV detail SPV detail SPV detail SPV detail |
||
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
Still, Repetition Exists. Column - Item Description and Vendor Master Missing. Created attachment 464 [details]
SPV detail
Please check attachemnt
Created attachment 463 [details]
SPV detail
THIS IS DONE Created attachment 462 [details]
SPV detail
THIS IS DONE CHECK ATTACHEMENT
Sir this form is Pending. Please give a Deadline date for Resolve of Query. Any Status regarding Resolve of Call I have already discussed the same. Please Start Working on the call. Please discuss with Mr. Amit Created attachment 399 [details]
IN PDF
Attachment send in pdf format Created attachment 395 [details]
Other format
Attachment not open Created attachment 392 [details]
Format in Xls
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.
|
Created attachment 469 [details] SPV detail CHECK ATTACHEMENT