Physical Inventory Tally Sheet Maintenance

Menu Path: Warehouse Management $Images\bluerarw.gif$ Inventory Management $Images\bluerarw.gif$ Physical Inventory $Images\bluerarw.gif$ Tally Sheets $Images\bluerarw.gif$ Physical Inventory Tally Sheet Maintenance

Purpose

Enter, view, edit, or delete physical inventory tally sheets.

Overview

Use Physical Inventory Tally Sheet Maintenance to define and maintain physical inventory tally sheets. For information on consolidating tally sheets, see Physical Inventory Entry.

Creating Tally Sheets

To create a tally sheet:

Enter a location prefix or name for which to create a tally sheet in the Location Prefix or Location Name field.
Enter a physical inventory ID for which to create a tally sheet in the Physical Inventory ID field.
Click the New button in the ribbon.
Enter an ID for the tally sheet in the Tally Sheet ID field.
Enter the user that counted inventory for the tally sheet in the Count By field.
Enter the user that recounted inventory for the tally sheet in the Recount By field (if applicable).
Enter any notes for the tally sheet in the Notes field.
Enter inventory data for a counted product, and click the Enter button. Repeat for all products you want to include on the tally sheet.
Click the OK button in the ribbon. The tally sheet is created.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Physical Inventory Tally Sheet Maintenance window.
New	Click this button to create a new physical inventory tally sheet.
Update	Click this button to update the selected physical inventory tally sheet. You can only update tally sheets if the associated physical inventory ID has not yet been adjusted.
Delete	Click this button to delete the selected physical inventory tally sheet.
OK	Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
Cancel	Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
First	Click this button to display the first physical inventory tally sheet for the selected physical inventory ID.
Prev	Click this button to display the previous physical inventory tally sheet for the selected physical inventory ID.
Next	Click this button to display the next physical inventory tally sheet for the selected physical inventory ID.
Last	Click this button to display the last physical inventory tally sheet for the selected physical inventory ID.
History	Click this button to display Tally Sheet Audit, which allows you to view an audit trail of changes for a selected tally sheet.
Attachments	Click this button to display Attachment Entry, which allows you to view and enter attachments for the selected contact.
Notes	Click this button to display Notes Entry, which allows you to view and enter notes for the selected contact.
Unlock Tally Sheet Utility	Click this button to display Unlock Tally Sheet Utility, which allows you to unlock tally sheets.

Fields and Buttons

Field or Button	Description
Location Prefix	Enter a location prefix, or click the Lookup button to select a location prefix. This defaults to the default shipping location prefix for your user ID.
Location Name	Enter a location name, or click the Lookup button to select a location name. This defaults to the default shipping location name for your user ID.
Physical Inventory ID	Enter a physical inventory ID, or click the Lookup button to select a physical inventory ID.

Main Tab Fields and Buttons

Field or Button	Description
Tally Sheet Code	Enter an existing tally sheet code, or click the Lookup button to select an existing tally sheet code. When you create a new tally sheet, this field is disabled, and the tally sheet code is automatically assigned.
Tally Sheet ID	Enter an ID for the tally sheet, such as an identification number from a preprinted count form. This must be unique for the physical inventory ID.
Count By	Enter the user ID or name of the user that performed the inventory count for the tally sheet, or click the Lookup button to select a user ID. This does not have to be an Apprise user ID.
Retain (Count By)	Select this check box to retain the user ID in the Count By field after saving the current tally sheet. This allows you to enter multiple tally sheets for the same user.
Recount By	Enter the user ID or name of the user that recounted inventory for the tally sheet, or click the Lookup button to select a user ID. This does not have to be an Apprise user ID.
Retain (Recount By)	Select this check box to retain the user ID in the Recount By field after saving the current tally sheet. This allows you to enter multiple tally sheets for the same user.
Deleted	This check box is selected if the displayed tally sheet was deleted.
Processed	This check box is selected if the displayed tally sheet was processed. A tally sheet is marked as processed after all data for the tally sheet is consolidated in the associated physical inventory entry record. This check box is cleared if you edit a previously reconciled tally sheet.
Notes (Tally Sheet)	Enter notes you want to associate with the tally sheet.
Retain (Tally Sheet Notes)	Select this check box to retain the notes in the Notes field after saving the current tally sheet. This allows you to enter multiple tally sheets with the same notes.
Line #	This field displays the line item number if you select an existing line item for a tally sheet.
Product Code	Enter the product code of the product counted for the tally sheet, or click the Lookup button to select a product code. You can also enter a UPC or GTIN in this field to identify the counted product.
Retain (Product Code)	Select this check box to retain the product code in the Product Code field after entering the line item. This allows you to enter multiple line items with the same product code.
Product Name	Enter the product name of the product counted for the tally sheet, or click the Lookup button to select a product name.
Unit of Measure	Enter the unit of measure of the product counted for the tally sheet, or click the Lookup button to select a unit of measure. This defaults to the appropriate unit of measure if you entered a UPC or GTIN in the Product Code field that is associated with a specific unit of measure, or if only a single unit of measure set up for the product.
Retain (Unit of Measure)	Select this check box to retain the unit of measure in the Unit of Measure field after entering the line item. This allows you to enter multiple line items with the same unit of measure.
Bin	Enter the bin that contains the product counted for the tally sheet, or click the Lookup button to select a bin.
Retain (Bin)	Select this check box to retain the bin in the Bin field after entering the line item. This allows you to enter multiple line items with the same bin.
Lot	Enter the lot of the product counted for the tally sheet, or click the Lookup button to select a lot. This field is only enabled if you enter a lot-tracked product code or name in the Product Code or Product Name field.
Retain (Lot)	Select this check box to retain the lot in the Lot field after entering the line item. This allows you to enter multiple line items with the same lot. This check box is only enabled if you enter a lot-tracked product code or name in the Product Code or Product Name field.
Serial #	Enter the serial number of the product counted for the tally sheet, or click the Lookup button to select a serial number. This field is only enabled if you enter a product code or name in the Product Code or Product Name field for a product that is tracked by serial number.
Quantity	Enter the quantity of the product counted for the tally sheet.
Retain (Quantity)	Select this check box to retain the quantity in the Quantity field after entering the line item. This allows you to enter multiple line items with the same quantity.
Notes (Product)	Enter notes you want to associate with the product inventory record for the tally sheet.
Retain (Product Notes)	Select this check box to retain the notes in the Notes field after entering the line item. This allows you to enter multiple line items with the same notes.
Enter	Click this button to finish entering the line item for the tally sheet.
Update	Click this button to save changes made to a tally sheet line item.
Clear	Click this button to clear all fields for the tally sheet line item.
Remove	Click this button to remove the selected tally sheet line item in the Line Items grid from the tally sheet.
Line Items	This grid displays line items for the tally sheet. If you are creating or updating a tally sheet, double-click a line item to edit it.