Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Menu PathProcurement > 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'.

Image Removed

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.

Report will be displayed upon clicking on Generate Report Now button.
User can view the following information regarding respective PO and may export the data if they wish. Image RemovedImage Added

  • 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

Image Added

  • 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 OptionsShow Last Cost, Show Average Cost and Show Transport Company Name

Image Added

  • 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:

Image Added

Image Added