Item Listing Instructions

Use the Item Listing to generate a list of items that includes item information such as the description, Product Category, stock UOM, associated costs and list price.

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 Item Listing, click More.

   

  1.  Click Listings from the Menu.

  2.  Click Item Listing.

   

  Item Listing Window Example:

  

   

• Choosing the Selections for the report, click More.

   

  Item Listing Prompts Tips:   To see more information about a field, click the hyperlink for the field name. Item Listing Parameters can saved and then, loaded after being saved.  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].
  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.
  Description	To specify a range of descriptions to include in the report, enter the lower/beginning description.  To specify the ending range, enter the upper range of the description. Note:  To include all descriptions in the report, leave the lower and upper range blank for All.   Or, to only include a specific description, enter the description as the lower range.
  GL Category	To specify a range of GL categories to include in the report, click to select the lower/beginning GL category.  To specify the ending range, click to select the upper range GL category. Note:  To include all GL categories in the report, leave the lower and upper range blank for All. Or, to only include a specific GL category, click to select the specific GL category as the lower range.
  Item Type	To specify a range of item types to include in the report, click to select the lower/beginning item type.  To specify the ending range, click to select the upper range item type. Note:  To include all item type in the report, leave the lower and upper range blank for All. Or, to only include a specific item type, click to select the specific item type as the lower range.
  Taxable	To include both taxable and non-taxable items in the report, leave the lower and upper range blank for All. Or, to only include either taxable or non-taxable, click to select the specific type of taxable as the lower range.
  List Price Type	To specify a range of item list price types to include in the report, click to select the lower/beginning list price type.  To specify the ending range, click to select the upper range item type. To include all list price types in the report, leave the lower and upper range blank for All. Or, to only include a specific list price type, click to select the specific item type as the lower range.
  Sort Parameters
  Sort	To specify the sort parameters, click Sort and the following screen displays.
  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 product category, 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.
  	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 Cance l.

   

• Report Sample(s), click More.

   

  To see an example of the report, click Item Listing Sample.