The Inventory Management Report enables the managing of the inventory by printing current year levels, including on hand, allocated, available, future available, and future value.

Report Setup

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

Starting and Ending Item Number .  Enter the starting item number to print.  If the report is to print for only one item, enter the item number in the starting AND ending fields.  If a range of items is to print, enter the beginning of the range in the starting item number and the end of the range in the ending item number.  If all items are to print, press Spacebar.  If Spacebar is entered, the starting and ending item number fields will be affected.  If the starting item number is not all, an item number must be entered into the ending item number field.

Include Discontinued Items.  If discontinued items are to print on this report, enter "Y".  If discontinued items are not to print, enter "N".  If ONLY discontinued items are to print, enter "O".

Items Below Reorder Point Only.  If ONLY the items below the reorder point are to print, enter "Y".  If all items selected are to print, enter "N".

Valid Status Codes.  The report may be set up to print only the items with a particular item status code or status codes.  This field will accept up to ten (10) item status codes.  If all status codes are to print, press Spacebar.

Select Quantity Sold Year.  The report can print the quantity sold for either the current year or last year.  If the current year sold is to print, enter "C".  If last year's sold quantity is to print, enter "L". 

Select Items with Usage Only .  If only the items with usage in the year selected are to print, enter "Y".  If all items are to print regardless of usage, enter "N".

Items w/Negative Availability Only.  If only those items selected that have a negative availability are to print, enter "Y".  If all items are to print regardless of the availability, enter "N".

Valuation Base.  The prompt will read Enter Valuation Base:  P=Price, C=Cost.  If the future value is to be based on price, enter "P".  If the future value is to be based on cost, enter "C".

Print Notepads.  If the item note pads are to print, enter "Y".  If the note pads are to be omitted, enter "N".

The report will print the following information:

Item Number and Description.

On Hand.  Quantity in inventory.

Allocate.  Item quantities on open selling orders.

Avail.  Available.  On Hand minus Allocate.

On Order.  Item quantities on open purchasing orders.

Future Avail.  Future Available.  On Hand minus Allocate plus On Order.

Reorder Point.  

Over/Short.  Future available minus reorder point.

YTD Quantity Sold.  The quantity sold in the current year. If the Select Quantity Sold Year field is entered "L", the quantity sold shown will be last year's quantity sold.

Consumed.  Allocated quantities plus shipped and billed quantities.

Future Value.  If the Valuation Base field is entered "C", future value is actual cost multiplied future available.  If the Valuation Base field is entered "P", future value is catalog price multiplied by future available. 

D.  Discontinued.

S.  Status Code.