Menu Path: Procurement > Report > Report > Purchase Order Detailed Listing
| Panel |
|---|
This report allow user to trace and audit on the purchase order (PO) details status for 'All' ,'Outstanding', 'Delivered' and 'Closed'. |
Filter Criteria
- Branch;
- PO Status;
- Approval Status;
- Date Range;
- Item Code Fuzzy Search;
- Item Code Range;
- Item Category;
- Item Status;
- Item Type;
- Order Type;
- Supplier.
...
Tips
...
- Key in Specific PO Number or click on PO Number for search Function, and click Submit
- Select PO Status and click Submit → to generate ALL PO with specific status
- Key in PO Reference Number and click Submit→ if any
- Select Branch
- Select PO Status and Approval Status
- Key in Date Range
- Key in Item Code Fuzzy Search → tick to seach by desciption
- Select Item Category and Item Code Range
- Select Item Type → deselect will generate All Types
- Select Order By→ if any, Blank means All
- Tick Options→ Show Last Cost, Show Average Cost and Show Transport Company Name
- Key in Specific Supplier ID or click Select for search function
- Click on Printable Page → to print current table
- Click on Export Excel or CSV → to export current table
NOTES:
- For Rebated Price Exc. Tax, the formula is (PO Price - Rebate Price) / PO Price
- and showed as Percentage (eg. 100%, 50%, 25%, etc.)
- Refer to Set the Rebate Amount when create PO and Auto reset price after GRN
- Click on PO number for document pop up
- Average cost and Pricing at PO Listing are guided by permission. Please go to System Admin > Manage Users > Configure Role Permissions > Procurement > Hide Pricing
- Sort by functions are available by clicking several column title → Item Code, Item Name, Branch, Supplier, Transport Company Name, PO Number, PO Date, Item
- For Purchase Order in Approved State, with No GRN, you can export and auto create via Upload GRN , refer : How to Export from Purchase Order and Upload GRN
Sort by Sample:
