Bug 8945 - Required:- PO dump in IMIS
Summary: Required:- PO dump in IMIS
Status: RESOLVED USER TO VERIFY
Alias: None
Product: IMIS FORMS AND REPORTS
Classification: 01.IMIS
Component: IMIS FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: Normal normal
Assignee: anushree.pandey
URL:
Depends on:
Blocks:
 
Reported: 2022-06-02 10:29 IST by Shilpa Srivastava
Modified: 2022-06-02 13:02 IST (History)
2 users (show)

See Also:
Database:
Module ID:

Attachments
Format of PO dump in excel (11.33 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-06-02 10:29 IST, Shilpa Srivastava 		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 2 anushree.pandey 2022-06-02 13:02:43 IST 
done..
Comment 1 anushree.pandey 2022-06-02 12:56:22 IST 
SELECT
A.COMPANY
,PKG_CONTROLS.GET_COMPANY_INFO(A.COMPANY, 'SHORT_NAME') COMPANY_NAME
,A.PO_NO
,A.PO_DATE
,A.SUPPLIER_CODE
,A.SUPP_NAME
,A.QUOTATION_DETAIL
,A.TYPE_OF_PURCHASE
,A.PRICE_TERMS
,A.TAX_TYPE
,A.REMARKS
,A.PO_AMOUNT
,A.PO_AMOUNT_LOCAL
,B.INVENTORY_ITEM_CODE
,B.ITEM_STOCK_TYPE
,B.UM
,B.ITEM_DESCRIPTION
,B.EXCISE_TARIFF
,B.PO_UM_QTY
,B.LIST_PRICE
,B.TAX_PERCENT
,B.TAX_AMOUNT
,B.ITEM_TOTAL_AMOUNT
,A.COST_OF_GOOD
,B.DISCOUNT_AMOUNT
,B.ITEM_QTY_RCVD
,A.DELIVERY_PLACE
,A.DELIVERY_ADDRESS
,A.DELIVERY_DATE
,A.DELIVERY_MODE
,A.LATE_PENALTY_CLAUSE
,A.PAYMENT_TERM_DESCRIPTION
,A.CREATED_BY
,A.CREATED_ON
,A.LAST_UPD_BY
,A.LAST_UPD_ON
,A.STATUS
 FROM PO A , PO_ITEMS B
WHERE A.COMPANY = B.COMPANY
AND A.PO_RECID = B.PO_RECID
--AND PO_DATE >= '01/04/2021'
ORDER BY A.PO_DATE
Description Shilpa Srivastava 2022-06-02 10:29:11 IST 
Created attachment 2814 [details]
Format of PO dump in excel

Dear Team,

Kindly share the PO dump in excel and share the query.

Also, i have attached the format of PO dump in excel format for your ready reference.




Thanks and Regards,
Shilpa Srivastava
Internal audit executive
Ext. No.-226