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:
On the Main Menu, click Inventory
.
Click Physical Inventory
.
Click Display All
. All of the count PLU lists appear.
Click the list that you want to open, and then click Open
. The Physical Inventory Maintenance
window appears with the PLU list displayed.
Note
You can add items to the PLU list after it has been generated by clicking New
in the Physical Inventory Maintenance
window.
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.
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
.
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.
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.
Click Yes
. The on-hand inventory amounts in the Store Manager change.
If you want to generates the Physical Inventory Count Shee
t 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.