Menu Path: Warehouse Management Inventory Management Physical Inventory Physical Inventory Count Sheet Print
Generate inventory count sheets for physical inventory IDs.
Use Physical Inventory Count Sheet Print to create an Inventory Count Sheet for a physical inventory ID. The count sheet can list the current on-hand quantities for products, or it can be blank (for a blind count). After you print count sheets, you are in a state of counting, and you cannot perform any inventory-related transactions in the system, such as stock adjustments.
To output an inventory count sheet:
Enter a physical inventory ID in the Physical Inventory ID field.
Make the appropriate selections for displaying computer counts on the count sheet, printing an error report, setting page breaks by bin, displaying zero product quantities on the count sheet, and defaulting the physical inventory to the system quantity on hand.
Click the Print Options tab.
Select a processing option and an output option for the count sheet.
Click the Print button in the ribbon to output the count sheet based on the selected process and output options. If the Print Error Report check box is selected, and there are unconfirmed pick demands, or confirmed pick demands/work orders that were not inventory adjusted, the Inventory Count Sheet Errors Report outputs. If this report is output, you must resolve the pick demands or work orders listed on the report. After the pick demands have been adjusted for inventory (or cancelled), you must re-output the count sheet.
The Inventory Count Sheet outputs for the specified physical inventory ID. You can now enter physically counted quantities in the count column and verify and recount, if necessary.
Button |
Description |
Exit |
Click this button to close the Physical Inventory Count Sheet Print window. |
|
Click this button to display, output, email, or print the inventory count sheet. |
Field or Button |
Description |
Enter a physical inventory ID, or click the Lookup button to select a physical inventory ID. For information on creating physical inventory ID's, see Physical Inventory Select. |
|
Select whether to sort products by product code or name. |
|
Select this check box to display the current on-hand quantity on the count sheet. This setting indicates whether you want a blind count. |
|
Select this check box to output the Inventory Count Sheet Errors Report, which will output if there are confirmed or unconfirmed pick demands for products in the selected physical inventory ID. If there are errors, a dialog appears, and informs you that there are pick demands that have not had inventory adjusted at the location for the physical inventory ID. You must resolve the items listed on the report to continue with the next step of Physical Inventory Entry. |
|
Select this check box to insert a page break after each bin on the count sheet. |
|
Select this check box to display products with a current on-hand quantity of zero on the count sheet. |
|
Select this check box to copy the current on-hand quantity to the physical count. This is done typically in a paper count so that only the exception counts need to be entered in the system. If this check box is cleared, you will need to enter all the physical counts. Note This generally works in conjunction with the Show Computer Count on Count Sheet check box. If you are showing counts, you probably only want to enter the physical count differences. |
Field or Button |
Description |
Select one of the following output options:
|
|
Save Report File |
Select this check box to save the Crystal Reports report (.rpt) file for the report to the folder entered in the Report Working Directory field for your user ID in User Profile Maintenance. You can use the report file to customize the report. For more information, see Crystal Reports FAQ. This check box is only available if you select the Screen radio button. |
Save Access Database File |
Select this check box to save the Access database (.mdb) file for the report to the folder entered in the Report Working Directory field for your user ID in User Profile Maintenance. You can use the Access database file to customize the report. For more information, see Crystal Reports FAQ. This check box is only available if you select the Screen radio button. |
Output File Type |
|
Select this check box to specify the file name of the output count sheet. This check box is only available if you select the File radio button. |
|
Output Directory |
Enter the location for the output count sheet, or click the Lookup button to navigate to and select a location. This field is only available if the Specify File Name check box is cleared. |
Enter a location and file name for the output count sheet, or click the Lookup button to navigate to and select a location and file name. This field is only available if you select the Specify File Name check box. |
|
Excel Format Name |
|
Format Maintenance |
Click this button to display Excel Format Maintenance, which allows you to set up Excel formats. This button is only available if you select the Excel radio button. |
Save As Type |
|
Include header |
|
Delimiter |
|
Enclosing Character |
|
Printer |
|
Select this check box to include the entire heading from the first page of the count sheet on all pages of the count sheet. This check box is cleared by default, and only enabled if you select the Screen, File, Printer, or Email radio button. |
|
Select this check box to include the count sheet title, page number, and printed date/time on all pages of the count sheet. This check box is selected by default and only enabled if you select the Screen, File, Printer, or Email radio button, and if the Print Full Heading on All Pages check box is cleared. |
|
Enter the first language for the count sheet, or click the Lookup button to select a language. |
|
Enter the second language for the count sheet, or click the Lookup button to select a language. If you enter a language in this field, the count sheet is printed in this language and the language entered in the Report Language 1 field. |
|
Select this check box to include horizontal shading on alternate lines of the count sheet to make it easier to read the data. This check box is cleared by default, and is only enabled if you select the Screen, File, Printer, or Email radio button. |
|
Collate |
Select this check box to collate the printed copies of the report (if you are printing multiple copies of the report). This check box is cleared by default, and is only enabled if you select the Printer radio button and enter a value greater than 1 in the Number of Copies field. Example You are printing five copies of a 20 page report to distribute to five different people. Leave this check box selected, so that pages 1-20 of the first copy prints, then pages 1-20 of the second copy, etc. If you clear this check box, five copies of page 1 prints, then five copies of page 2, etc. |
Click the Lookup button to select the color of horizontal shading on the count sheet. This Lookup button is only enabled if you select the Horizontal Shading radio button. |
|
Enter the number of copies of the count sheet to print. This field is only enabled if you select the Printer radio button. |
|
Select whether the count sheet is run now or run by Scheduling Assistant. If you select the Schedule radio button, you can specify when the process occurs. These radio buttons are only enabled if the Disable Scheduling Assistant check box is cleared for your user ID in User Profile Maintenance. Note If you select the Schedule radio button, you cannot output to the screen. |
|
Time |
|
Date |
|
Task Occurs |
Select one of the following options:
These radio buttons are only enabled if you select the Schedule radio button. |
Frequency |
These radio buttons are only available if you select the Every radio button. |
Day of Week |
|
Repeat Every X Days |
|
Repeat On |
|
Repeat Every X Minutes |
|
Triggering Task Id |
|
Triggering Task Name |
|
Triggering Task Description |
|
Task Description |
|
Scheduling Assistant Queue |
Enter an active Scheduling Assistant queue for the task, or click the Lookup button to select a Scheduling Assistant queue. This defaults to the default queue for your user ID. This field is only enabled if you select the Schedule radio button, and you are assigned to a queue other than the Default queue. |
External Email |
|
Screen Alert |
|
Internal Email |
|
This grid displays report files set up for the count sheet, and is only available if report files are set up for the program in Report File Maintenance. This grid includes the following columns:
|