Valuation Report Instructions

Use the Valuation Report to list the item quantity on hand and the values of those items.  This information can help you determine the value of the on hand inventory.  You can use the report to generate item value information for quick reference and to provide information about the amount of cash currently tied up in inventory.  The report offers options for generating subtotals for both items and locations as well as accumulating grand totals for the average value, standard value and last value for the items reported.

Tips:

• This report is also referred to as the Item Valuation Report.

• 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 Valuation Report Instructions, click More.

   

  1.  Click Reports from the Menu.

  2.  Click Valuation Report.

   

  Valuation Report Window Example:

  

   

• Choosing the Selections for the report, click More.

   

  Valuation Report Instructions Prompts Tips:   To see more information about a field, click the hyperlink for the field name. Valuation Report Parameters can saved and then, loaded after being saved.  For information, see Reporting Toolbar.
  Item ID	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.
  Average Cost	To specify a range of average costs to include in the report, enter the lower/beginning average cost.  To specify the ending range, enter the upper range average cost. Note:  To include all average costs in the report, leave the lower and upper range blank for All. Or, to only include a specific average cost, enter the specific average cost as the lower range.
  Standard Cost	To specify a range of standard costs to include in the report, enter the lower/beginning standard cost.  To specify the ending range, enter the upper range standard cost. Note:  To include all standard costs in the report, leave the lower and upper range blank for All. Or, to only include a specific standard cost, enter the specific standard cost as the lower range.
  Last Cost	To specify a range of last costs to include in the report, enter the lower/beginning last cost.  To specify the ending range, enter the upper range last cost. Note:  To include all last costs in the report, leave the lower and upper range blank for All. Or, to only include a specific last cost, enter the specific last cost as the lower range.
  Location ID	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.
  On Hand	To specify a range of on hand items to include in the report, enter the lower/beginning on hand item.  To specify the ending range, enter the upper range on hand. Note:  To include all on hand items in the report, leave the lower and upper range blank for All. Or, to only include a specific on hand item, enter the specific on hand item as the lower range.
  Cycle Code	To specify a range of cycle codes to include in the report, enter the lower/beginning cycle code.  To specify the ending range, enter the upper range cycle code. Note:  To include all cycle codes in the report, leave the lower and upper range blank for All. Or, to only include a specific cycle code, enter the specific cycle code as the lower range.
  Sort Parameters
  Sort	To specify the report 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 average cost, 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.
  Option Parameters
  Options	To specify the report options, click Options .  The following screen displays:
  Show Item Subtotals	To include item subtotals on the report, click to check this box. To omit displaying item subtotals on the report, leave this box unchecked.
  Show Location Totals	To include location totals at the end of the report, click to check this box. To omit displaying location totals at the end of the report, leave this box unchecked.
  Show Grand Totals	To include grand totals at the end of the report, click to check this box. To omit displaying grand totals at the end of the report, 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 Valuation Report Sample.