Search Site     
HOME >> TIP OF THE MONTH     
Back Office
Home Office
Central Price Book
POS Interfaces
Hand-held Scanning
EDI Conversion
Fuel Distribution
Work Orders/ALLDATA
Work Orders/Mitchell 1
Sunray - ASP
Digital Dispatch
Training
Support
System Administration
POS Conversion
General Information
Employment
Sales
Support
Tip of the Month
Press Releases
Product Versions
Trade Shows
Tip of the Month

Adjusting Inventory with the Hand-Held on a Daily or Weekly Basis

Tip

How to Adjust Inventory with the Hand-Held Terminal on a Daily or Weekly Basis

Taking a count of your physical inventory and comparing it to your book values so that you may update your book inventory values to reflect reality while keeping your inventory reports accurate can be done for any day. Some users may be unable to dedicate an entire day once a month to process adjustments. These users may find that taking a physical inventory of a different department range each business day accomplishes the same goal even though it doesn't take place on the first or last day of a calendar month.

In addition, taking a physical inventory on a daily basis helps make the process part of your normal routine and helps ensure it gets done consistently. Users that put off taking a physical inventory for several months may miss the chance to identify the reasons for shrink expenses such as theft, breakage, spoilage, or incorrect booking of sales or purchases.

If you plan on scanning a different department each day, then you will cover five departments per week or about 25 departments per month which may be all the departments that you use for inventory purposes. If not, you may find that scanning two departments per day will cover your entire store each month.

Fetch a reference file for the department range you are going to scan. Items inside this range which are not scanned because they are not physically present have a physical quantity found of zero that can then be adjusted to zero in CDB. Items outside the range which are not scanned will not be adjusted. To do this make sure you select the Adjust unscanned items to zero check box in the HDP application.

Scan all the items which belong to the reference file's selected department range.

Send the Physical Inventory data back to the PC.

Print the Exceptions report and post the adjustments against the CDB date that corresponds to the day you counted the inventory. If possible, process the day's regular paperwork in a separate shift from your physical inventory adjustments to separate the COGS and GP adjustments from your regular Daily Book Reports.

After you have finished tagging the adjustments and have ended the shift, you may also delete items which have a zero quantity-on-hand to remove them from your inventory list.

This is an overview. Each of the steps above are explained in detail in the Hand-Held Data Processing User's Guide.

Past Tips of the Month...

May 2007: Scanning Direct Store Delivery Invoices Without Affecting Retail Prices in CDBWin

April 2007: Restricting Duplicate Invoice Numbers

March 2007: Profit & Loss

February 2007: Fuel Manager Reports

January 2007: How to Buy Coffee Supplies and Expense Them

December 2006: How to Get a PLU Report without Bar Coded Items

November 2006: How to Create a Reorder Using the Hand-Held Terminal (HHT)

October 2006: Reorder Items in Selected Department Range

September 2006: Reorder Quantities Based on Minimum Purchase Quantity

August 2006: Reorder Quantities Based on Sales History

July 2006: How to Reconcile Inventory

June 2006: How to Reconcile Inventory After a Promotion...

May 2006: Reordering the Correct Number of Items

Home  |  About Us  |  Products  |  Services  |  What's New?  |  Contact Us