PowerSchool ERP Purchasing

Inventory Catalog Detail

The Inventory Catalog Detail report provides complete data on the stock items stored at your warehouse locations. The report is organized first by warehouse, and then by your choice between stock number or item description. The data shown for each item includes:

Warehouse Code

Requested Quantity

Price Per Unit

Warehouse Address

Back Order Quantity

Safety Point

Stock Number

Quantity Available

Reorder Point

Item Description

Quantity On Order

YTD Usage

Unit of Issue

Average Unit Cost

YTD Units Purchased

The page's criteria fields reference fields in the Inventory Catalog. The Discontinued field, which is a checkbox in the catalog, lists the following options in the report page:

N-Active Items

Selects stock items that are not marked as discontinued. This excludes all discontinued items.

Y-Discontinued Items

Selects stock items marked as discontinued. This excludes all active items.

Blank

Selects records without considering the Discontinued setting. This includes both active and discontinued items.

Menu Path:  Warehouse Inventory > Reports > Warehouse Reports > Inventory Catalog Detail

Generating the Inventory Catalog Detail report

  1. Select Warehouse Inventory > Reports > Warehouse Reports > Inventory Catalog Detail to display the Inventory Catalog Detail Report page.

  2. In the Report Sort Options section, select one of the following, and then click OK:

    Order By Stock Number

    To sort the report by warehouse and then numerically in stock number order.

    Order By Description

    To sort the report by warehouse and then alphabetically in description order.

  3. In the Report Criteria section, enter criteria identifying the records to include, and then click OK. To run an advanced search, use the Advanced button.

  4. In the Print window, specify how to generate the report, and then click OK. The report's default file name is catalogd.rpt.