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'. |
Tips
Rebated Price Exc. Tax
...
- 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
For PO Details, click the PO hyperlink for the document popup for more details.
Related Settings
- To set permissions for a specific user to show/hide the pricing using PO Listing, please go to:-
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
- Select the role of the user from the list, tick/untick "hide pricing in PO listing".
Optional Report filter
- Show Transport Company Name
...
- 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:
