The Quantity on Hand Audit Report will give you a record of the changes made to the Quantity on Hand through "Change Quantity on Hand" (5.6.1.1).

If selecting by Beginning and Ending Effective Date to Print, two addtional prompts are available to select Beginning & Ending Time. This will be useful if you want to start changing QOH at a particular time but not include transactions earlier or later in the day.

You may select by Beginning and Ending Part Number or Beginning and Ending Bin Location. You may also sort by Bin Location. If you use multiple Bin Locations, the data in this report can be broken down by Bin Location. Also, warehouse (average) cost is stored in the file when the change to QOH is made, therefore this report can be used to tie to the General Ledger.

You may select a specific Saleslperson Code or All Salesperson Codes.

You may Summarize into 1 line, all entries for each part on the report. The Salesperson, Reason, Old Quantity on Hand will print for the first change date encountered. The new Quantity on Hand will print for the last change date encountered. It will also display the first Old Cost and the last New Cost.

You may filter the report to show only those items above the Manufacturer’s Variances. This will give you a smaller report of what has changed so you can investigate the reasons. The variance must exceed both the cost and percentage to be on the report. The Cost Variance is a change in the cost of part number. The Percentage Cost Variance is the percentage change in the cost of a part number.

Example: The Cost Variance is $10 and the Percentage Cost Variance is 35%. The cost of an item was $50 and is now $25. This is a change of $25 and a percentage change of 50%. Since it falls within both criteria, it will be listed on the report. If the Cost of an item was $1020 and now is $1000, it will match the Cost Variance of $10 but not the Percentage Cost Variance of 35% so it will not be listed on the report.

Variances are entered in “Manufacturer Entry” (5.1.11.1).

When selecting "Sort by Bin Location" <Y>, two options will be available at the "Use Mfr Variances" prompt:

The <Y> option shows individual bin variances. The <T> option will suppress printing units of measure in which the Total Unit of Measure variance for all bins are within acceptable Mfr Variances. This prevents items from appearing on the report that are not actually out of variance overall, but maybe simply in different areas of the warehouse.

The Variance Override prompt is available when responding with either <Y> or <T> at the "Use MFR Variances" option. The Entry Options are: Enter Variance Amount or Percentage to use instead of the MFR Variance(s), or Leave Blank to use MFR Variance(s).

The user can replace the variances found in the MFR with a single input of either a dollar amount or percentage variance, for the purposes of running the report. Note that while the MFR file contains both a dollar and percentage variance, this prompt will override BOTH settings in the MFR file.

Also the Help in the "Summarize into 1 line" prompt is used to reflect whether the report will be summarized by, Part/Unit or by Bin, based on the response to "Sort By Bin Location".

A Recount line is a blank line printed so you may use this report as a count sheet.

You have the option of printing a Detail, Summary or Total report. A Detail Report will print all parts. The Summary will print the Manufacturer subtotals and grand totals only. The Total report will only print grand totals.

You may view on the screen or print this report.

       

The view screen function requires an AccuTerm© station or terminal capable of viewing 132 columns. Update fields 13, 14, and 16 in “Port Entry” in POINT OF SALE (1.10) to enable this function.

After the report is displayed to the screen you also have the option of entering a <D> to download the report to your local hard drive. When downloading the file, the path defaults to C:\TEMP but will use the setup in “Port Entry” (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example: ORDER.RPT10.TXT, where 10 is the port number or ORDER.RPT10TAB.TXT for the TAB Delimited file name.

After selecting the Print or Screen option you will be prompted with the option to Sort by location and Print subtotal for each location.