How to Reconcile Inventory
Tip
Take a physical
inventory with the HHT to correct quantities.
Each time you want to take a physical inventory to report on variances between
Book and Physical quantities, at the HHT, fetch a reference
file with the department range of the items you will count. It is recommended that
you take a physical inventory of a different department each day of the month until
you have found all items.
For example, today fetch a
department range of 2.00 through 2.99, tomorrow fetch a department range of 3.00
through 3.99, etc. With the Inventory option in the HHT, today, scan all
the items which belong in departments 2.00 through 2.99; tomorrow, scan all the
items which belong in departments 3.00 through 3.99; etc.
Send the Physical Inventory files from the HHT.
When your books catch up to the date you took your inventory, create two shifts.
Process your regular work in shift 1. In shift 2, from HDP, click
Physical Inventory. Select your physical inventory session for the day
you are processing. The
sessions are listed in the order they were received from the HHT with the latest
at the top. The department range fetched for your physical inventory
session is also listed.
For example, if you took an
inventory of department 2 on July 10, process July 10's normal work in shift 1
and you will want to post the adjustments for July 10 in shift 2.
Leave the Processing Date box with the
default value unless your CDB Shift Header Date has passed the date of the
physical inventory. When the date has passed, select the date you took the
inventory so the system can calculate what the book date was when comparing the
book quantities with the physical quantities. Select the Adjust
unscanned items to 0 in CDB check box. Click Post Selections.
If prompted with a discrepancy window, select or clear the check box to correct
or not correct multi-pack relationships in the CDB. Click Close.
Click Physical Inventory
Reporting. Select the same physical inventory session. In the
Processing Date box, select the same value as you did when you posted the
adjustment. Click Print. Click Close. Click
Exit.
From CDBWin, on the Daily Work
menu, click Sales/Receivables.
On the File menu, click Open. Select the adjustment
transaction you posted. Click Tag. Click OK. On
the File menu, click Close.
Back up, end the shift, and
change the Shift # to 1 of 1 if there are no adjustments to be made in
this next day's books.
Please submit your ideas for Tip of the Month
Do you have a question, comment, or idea for Tip of the Month? Please complete
this quick web form and we might use your submission for future updates!
 | 
