Show TOC

Procedure documentationEntering New On-Hand Quantities

Procedure

Once you create a PLU list, you can open it and adjust the on-hand quantities of the items in it. For information about creating a PLU list, see Creating an Inventory Count PLU List.

The Physical Inventory Maintenance window displays the expected on-hand quantities of each item in the PLU list. You can compare these amounts to the actual amount that you count in your store. The on-hand quantities in the Store Manager are not updated until you complete the adjustment transaction.

To enter new on-hand quantities:

  1. On the Main Menu, click Inventory.

  2. Click Physical Inventory.

  3. Click Display All. All of the count PLU lists appear.

  4. Click the list that you want to open, and then click Open. The Physical Inventory Maintenance window appears with the PLU list displayed.

    Note Note

    You can add items to the PLU list after it has been generated by clicking New in the Physical Inventory Maintenance window.

    End of the note.
  5. Complete the following fields, where appropriate:

    • The Txn Number field defines the unique number that identifies the inventory transaction. The inventory transaction number sequence is also used for purchase orders, receiving transactions, and transfers. No action required. Store Manager automatically completes this field when you click Save.

    • The Status field indicates the current status of the transaction. No action required. Store Manager automatically completes this field.

    • The Txn. Date field defines the date the inventory transaction is created. The transaction date can differ from the inventory date. No action required. Store Manager completes this field with the computer’s system date on which the Store Manager is running.

    • The Doc. Number field defines the unique number that identifies the transaction. You can modify the document number if you click Modify PO/Doc Number in the Inventory Parameters Maintenance window. Store Manager automatically completes this field, but you can edit the information in it. Type a number into the field.

    • The Inv. Bucket field shows the bucket in which the inventory item is assigned to. No action required. Store Manager completes this field.

    • The Reason field defines the reason the inventory count is being performed. You must complete this drop-down list if you click Physical Inventory Reason Required in the Inventory Parameters Maintenance window. You can define the selection of reasons that appear in this drop-down list in the Code Table Maintenance window. Click the drop-down list and select a reason from the list.

    • The Department field defines the department to which the items in the list belong. The department field is not related to the Department table that you define as part of the product hierarchy. Type an alphanumeric string, up to 14 characters long, into the field.

    • The Location field defines the location of the items in the store. You can define the selection of locations that appear in this drop-down list in the Code Table Maintenance window. Click the drop-down list and select a location from the list.

    • The Inv. Date field defines the inventory count date. Store Manager automatically completes this field, but you can edit the information in it. Click the button beside the field to open the pop-up calendar window. Click a date and click OK. Alternatively, type a date into the field.

    • The Required by field represents the date by which the physical inventory count must be completed. Click the button beside the field to open the pop-up calendar window. Click a date and click OK. Alternatively, type a date into the field.

    • The Note field defines any notes regarding the transaction. You can enter any information about the adjustment up to 20 characters. The information is displayed in the Inventory Adjustment Report.

    • The Origin field indicates the origin of the transaction (electronic document, manual). No action required. Store Manager automatically completes this field.

    • The PLU/XREF field defines the unique number that identifies the item. Type a number into the field.

    • The Description field defines the item’s description. No action required. Store Manager automatically completes this field.

    • The Retail Price field indicates the item’s retail price. You define the retail price in the Retail Price field in the PLU Page 1 tab of the PLU Maintenance window. No action required. Store Manager automatically completes this field.

    • The Qty. Actual field defines the quantity of the item you actually count in your store. Type a number into the field.

    • The Qty. Current field defines the quantity of the item the Store Manager expects to be in the store. No action required. Store Manager automatically completes this field.

    • The Qty. Variance field defines the difference between the quantity on-hand that the Store Manager expects, and the quantity that you actually count in your store. The variance is based on the values in the Quantity and Amount fields in this window. No action required. Store Manager automatically completes this field.

    • The Extended Variance field defines the total retail price of the number of items in the variance. The amount is based on the values in the Retail and the Variance fields in this window. No action required. Store Manager completes this field.

  6. To add a blank line to the bottom of the list of selections that you can use to add a PLU to the PLU list, click New.

  7. To view information about the item in the transaction line that you highlighted, click Inventory Information. The item in the highlighted line must be inventory controlled. For more information about the Inventory Information window, see Viewing Inventory Information.

  8. To complete the transaction and implement the changes to the on-hand quantities of the items click Complete. To modify the on-hand quantity of an item after you complete the transaction, you must create a new transaction. The transaction’s status is complete.

  9. Click Yes. The on-hand inventory amounts in the Store Manager change.

  10. If you want to generates the Physical Inventory Count Sheet and the Physical Inventory reports, click Report. The Physical Inventory Count Sheet report contains the same list of PLUs as shown in the Physical Inventory Maintenance window. You can generate the Physical Inventory report by clicking View Physical Inventory Report on the Report window. The Physical Inventory report contains the information displayed in the Physical Inventory Maintenance window. You can use the report template designer to alter the appearance and layout of both the reports.