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

How to Reconcile Inventory After a Promotion Where the Promotional Items Recorded as Sold Were Not for the Same "Flavor" Though They Were Sold as the Same "Flavor" at the POS

Tip

Take a physical inventory with the HHT to correct quantities of the promotional items by scanning those items and entering the number found.

At the HHT, fetch a reference file for a department range of 2.00 through 99.99.  Scan only your promotional items.  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.  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.  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.  Clear 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.

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!

Past Tips of the Month...

May 2006: Reordering the Correct Number of Items

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