Printing Count Sheets for Reporting Purposes

In addition to counting inventory, use the Generate Control File and Print Count Sheet programs for reporting purposes. By generating count control files and then printing them in the form of count sheets, you can view where your inventory is located as recorded in the system. Depending on the sorting option you use to print the report, you can review your inventory by price line, location, product description, sell group, or control number.

To print count sheets for reporting purposes:

From the Phys menu, select Generate Control File to display the Generate Control File screen.

Generate a count control file for the inventory on which to report.
From the Physical menu, select Print Count Sheets to display the Print Count Sheets screen.

In the Count ID# field, enter the ID of the count control file.

The system populates the following fields:

Field	Description
Title	Title assigned to the selected count control file.
Branch	Branch for which the report is being generated.
Last Control #	Last control number assigned to product in the count control file. When you create multiple generations of a count control file, this number increases as more items are added with each generation.

In the Sort By field, press F10 and select one of the following sorting options:

Option	Description
Ctrl #	Sorts by count control number. Use this option when you do not have warehouse locations set up for each product and your warehouse is not arranged by price line.
Price Line By Description	Sorts first by price line and then by product description. Use this option when your warehouse is arranged by price line.
Location By Ctrl #	Sorts first by product location and then by count control number within each location. Use this option when your warehouse is not arranged by price line.
Location By PLine By Desc	Sorts first by product, then by price line within each location, and finally by product description within each price line. Use this option when your warehouse is arranged with price lines assigned to warehouse locations.
Location By PLine By SellGroup	Sorts first by price line and then by sell group. Use this option when your warehouse is arranged by price line and discount class assigned to warehouse locations.
Location By Description	Sorts first by product location and then by product description. Use this option when you have warehouse locations assigned to each product.

Note: When printing multiple generations of a count control file, use the same Sort By selection each time you print count sheets.

In the Start Control # and End Control # fields, enter the range of count control numbers to print on the count sheets.
In the Print Sheets or Cards field, press F10 and select Sheets.
In the Page Break on field, press F10 and select one of the following:
No Page Breaks - Prints the selected range of count control numbers without page breaks.
Line - Inserts a page break after each price line.
Row, Section, or Shelf - Inserts a page break after each row, section, or shelf.

Set options, if needed, and generate the report.