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 |
...
Go Procurement > Report > Purchase Order Listing
1. If user have received the stock by PO by GRN , then there will be a related GRN number as a reference
2. If PO needs approval, higher level staff can approve the PO in this report by ticking the POs and click 'Approve'
3. If there is any outstanding PO, user can click "Receive" to receive the stocks
4. If the PO is cancelled, user can close the PO in this report.
5. The yellow colour indicate that the PO only partially fulfilled, while purple is to highlight those POs that already fully fulfilled.
...
'All' ,'Outstanding', 'Delivered' and 'Closed'. |
- 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:
