| Summary: | Required:- PO dump in IMIS | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS FORMS AND REPORTS | Reporter: | Shilpa Srivastava <shilpa.srivastava> |
| Component: | IMIS FORMS AND REPORTS | Assignee: | anushree.pandey |
| Status: | RESOLVED USER TO VERIFY | ||
| Severity: | normal | CC: | amit.madaan, sharad.sharma |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | PC | ||
| OS: | Windows | ||
| Database: | Module ID: | ||
| Attachments: | Format of PO dump in excel | ||
|
Comment 2
anushree.pandey
2022-06-02 13:02:43 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 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
|