Inventory Results Report

After inventory adjustments have been entered in Update Inventory Worksheet this Inventory Results Report can print out the products by adjustment value or by the new dollar value, prior to posting.
This utility can be accessed by clicking on the RESULTS button on the Inventory Count Console.

The report prints in either descending value, or in descending discrepancy value order, or in the same order as the original worksheet.
A cut off dollar amount can be selected for the descending sequences.
It is a useful tool in checking and confirming these product quantity and value changes, before the new product quantities are accepted and posted to the inventory file.

The report prints the product number, description, bin #, the old quantity, new quantity, and the change in quantity. It prints the old value, the new value, and the change in value.
The prompts are:

LOCATION

Enter a location for the report or select one from the window.
The location and permission to change it, default for the operator as defined in Operators.

All classes previously printed on the worksheet for this location will also be included in this report.

SORT BY

Select one of the following sort options for the report:

• Select Descending $ Value Discrepancy to print the report by descending dollar value of the discrepancy or the change in the product value.

• Select Descending $ Value to print the report in descending order of the new dollar value of the products.

• Select Original Sequence to print the report in the same sequence as the original worksheet, that was printed from the Inventory Count Console.

CUT-OFF VALUE

Enter the cutoff value.

• If the Descending $ Value Discrepancy sort option was selected, products with a discrepancy or a change in value of less than this amount, will be omitted from the report.

  Note: The report uses the Absolute Value, of the dollar amount difference. It ignores the plus and minus signs, and sorts/prints the dollar difference by the absolute number value, picking up both + and - discrepancies.

• If the Descending $ Value sort option was selected, enter the new product value cutoff amount so products with a new value of less than this amount will be omitted from the report.

• This field does not apply if the sort option Original Sequence was selected.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click the ACCEPT button to begin printing the report, or CANCEL to abort.