Available Inventory Report Instructions

Use the Available Inventory Report to generate a summary report of inventory items that includes the date on-order items are expected to arrive.  This report includes an option to exclude items with a zero on hand quantity, allowing you to only view the items that are in stock at a location.  

Tips:

• For more information about running reports, see Print View.

• For more information about the buttons on the toolbar, see the Reporting Toolbar.

Directions:

To see directions for...

• Opening the Available Inventory Report, click More.

   

  1.  Click Reports from the Menu.

  2.  Click Available Inventory Report.

   

  Available Inventory Report Instructions Window Example:

  

   

• Choosing the Selections for the report, click More.

   

  Available Inventory Report Prompts Tips:   To see more information about a field, click the hyperlink for the field name. Available Inventory Report Parameters can saved and loaded.  For information, see Reporting Toolbar.
  Item	To specify a range of items to include in the report, click to select the lower range/beginning item.  To specify the ending range, click to select the upper range item. Notes:   To include all items in the report, leave the lower and upper range blank for All.   Or, to only include a specific item, enter the item as the lower range. To search for an item, click in the lower or upper range and then press [Ctrl + f].
  Location	To specify a range of locations to include in the report, click to select the lower/beginning location.  To specify the ending range, click to select the upper range location. Note:  To include all locations in the report, leave the lower and upper range blank for All. Or, to only include a specific location, click to select the specific location as the lower range.
  Quantity On-hand	To specify a range of quantities on hand to include in the report, enter the lower/beginning on hand quantity.  To specify the ending range, enter the upper range of the quantity on hand. Note:  To include all quantities in the report, leave the lower and upper range blank for All.   Or, to only include a specific quantity on hand, enter the quantity on hand as the lower range.
  Quantity On Order	To specify a range of quantities on order to include in the report, enter the lower/beginning on order number.  To specify the ending range, enter the upper range of the quantity on order. Note:  To include all quantities in the report, leave the lower and upper range blank for All.   Or, to only include a specific quantity on order, enter the quantity on order as the lower range.
  Quantity Committed	To specify a range of quantities committed to include in the report, enter the lower/beginning committed number.  To specify the ending range, enter the upper range of the quantity committed. Note:  To include all quantities in the report, leave the lower and upper range blank for All.   Or, to only include a specific quantity committed, enter the quantity committed as the lower range.
  Product Category	To specify a range of product categories to include in the report, click to select the lower/beginning product category.  To specify the ending range, click to select the upper range product category. Note:  To include all product categories in the report, leave the lower and upper range blank for All. Or, to only include a specific product category, click to select the specific product category as the lower range.
  Sort Parameters
  Sort	To specify the Sort parameters, click Sort .
  Order	To specify the fields to sort the report by, enter any positive number into the Order field.  A value of 1 means sort by this field first, 2 means sort by this field second and so on.  The numbers do not need to be sequential but they must be greater than zero.  In the example above, inventory is sorted first by location, and then by item. Notes: Two sorts with the same number will get sorted before others with larger numbers and after those with smaller numbers, but the actual order for those two sorts is indeterminate. To remove a sort order for a field, delete the value in the Order field.
  Ascending	To sort in an ascending manner, click to select the Ascending checkbox.  Or, leave the Ascending checkbox blank to sort in descending order.
  Active	The Active flag must to set to enable the field to be sorted.  To set the Active flag, click to check the corresponding checkbox.  Important:  If Active is unchecked, the field will not be used for sorting even if there is a Order value entered for the field.
  Options Parameters
  Options	To select the report options, click Options and the following displays.
  Hide Items Without On Hand Inventory	To report items even when their on hand quantity is zero, leave this box unchecked. To omit reporting items with zero on hand quantity, click to check this box.
  Show Pricing Information	To report last cost, standard cost and list price on a second line for each item, click to check this box. To omit this information for each item, leave this box unchecked.
  	To begin printing to the Windows® default printer, click Print, or press [ENTER]. Or, to print to the Print View window, click Print View . Or, to escape from the print routine, click Cancel .

   

• Report Sample(s), click More.

   

  To see an example of the report, click Available Inventory Report Sample.