Inventory Listing Instructions
Use the Inventory Listing to view inventory details for the specified inventory items at the locations. This report includes item location, bin, description, quantities on hand, quantities on order and quantities committed as well as dates purchased and sold.
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 Inventory Listing Instructions, click More.
Choosing the Selections for the report, click More.
Inventory Listing Prompts Tips: To see more information about a field, click the hyperlink for the field name. Inventory Listing Parameters can saved and then, loaded after being saved. For information, see Reporting Toolbar. |
|
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 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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
To specify a range of bins to include in the report, enter the lower/beginning bin. To specify the ending range, enter the upper range of the bin. Note: To include all bins in the report, leave the lower and upper range blank for All. |
|
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 location, and then by item. Notes:
|
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 Cancel . |
Report Sample(s), click More.