The Inventory Stock Status Report lists, by program, item number, description, on hand, allocated and available quantities, reorder point, and inventory value.  The report also summarizes YTD, year to date, number or orders, quantity purchased and quantity sold by item.

Report Setup

Program ID.  Enter the program ID of the program to print.  If all programs are to print, press Spacebar.  If the program ID is not known, enter "?" to display the Active Programs window.  Select a program by entering the sequence number to the left of the program ID.

Item Status Codes.  The report can be filtered to print only the status codes entered.  This field will accept up to ten (10) status codes.  If all status codes are to print, press Spacebar.

Sort by Vendor.  The report can be set to sort the items by the vendor entered on line 4 of Inventory Item Maintenance on the IFM menu.  If no sorting is needed, enter "N".

Vendor Name.  The prompt will read Enter Vendor ID to Sort By, ?=Display, Spacebar=All, F4=All.  If only one vendor's items are to print, enter the vendor number of the vendor to print.  If the vendor number is not known, enter "?" to display the Vendor window.  Select the vendor number by entering the sequence number to the left of the vendor number.

Print ONLY the Items At or Below the Reorder Point? (Y/N).  This is a bottom of the screen prompt that does not have a field for entry.  This report can be set to print only those items that are at or below the reorder point.  If the report is to print only those items at or below the reorder point, enter "Y".  If all items are to print, enter "N".

Report Format.  Q=YTD Qty Info, P=Purchasing Info.  If the report is to print the stock status based on sales quantities, enter "Q".  If the report is to print based on purchasing quantities, enter "P".

The report prints the following information:

Q=YTD Qty Info

Item Number and Description .

On Hand.  Quantity in inventory.

Allocated.  Quantity on open selling orders.

Available.  On Hand minus Allocated.

Reorder Point.

On Order.  Quantity on open purchasing orders.

YTD # of Orders.  Number of closed orders this current year.

YTD Qty Purchased.  Quantity purchased this current year.

YTD Qty Sold.  Quantity sold this current year.

Value On Hand.  Average cost multiplied by the On Hand quantity.