Table of Contents
- Part 1. Generating Count Sheets, Downloading Your Inventory and Syncing the Scanners
- Part 2. The Scanning Process
- Part 3. Checking For Discrepancies
- Part 4. Uploading and Posting Your Sheets
Generating Count Sheets, Downloading Your Inventory and Syncing the Scanners
Step 1 - Creating Count Sheets. Log-in to DealerTrack DMS and then navigate to the Physical Inventory section.
On the bottom of the screen, click on the "Add" button.
Insure that the following items are correct before adding the Sheets to your DMS.
Type of Inventory: From Bin*FIRST to Bin *LAST
Include Parts List*: Leave Blank
Bin Page Break Positions: All need to be checked
Sort Sequence: 1 Mfr, 2 Group, 3 Sort Part No, and leave Part Number Blank
Check Mark Left Justify Bin for Sort, Print Quantity On Hand, and Assign New Bin Location
Output Type*: None
It should look like the following:
You will see the sheets added, similar to this:
then exit out of the Physical Inventory Section.
Step 2 - Downloading The Physical Inventory Sheets. Click on the Download button on PartsWizard, and choose "Download From DMS".
Select the option for Inventory, and click on the check box for physical inventory sheets, with today's date. Click OK.
The Download Wizard should look like the following:
Step 3 - Synchronizing your Scanners. Because the download performs a synchronization right after downloading, the first scanner is already done. You will need to take each rented scanner and one-by-one place them into the charging cradle that is connected to the computer. Once the scanners are connected click on the "Sync Scanner" button,
wait for the Download Status box to disappear. Once it does, remove the scanner from the cradle and do the same for each rented scanner until they have all been synchronized.
The Scanning Process
Step 4 - Scanning Inventory. Once the scanners have been synchronized we will start scanning the inventory. Simply hold down the red power button located on the bottom left of the keypad until the scanners turn off. Once they turn off let go of the power button and they should turn back on, and take you to the PartsWizard menu page. Click on the button that says "inventory"
You should then see the following:
Explanation of Each Field:
Top Left: Bin Location
Top Right: Quantity Field
Right Blow: Part Number Field
Exp Bin: Bin location according to DealerTrack
Scan Bin: Bin that the Part was Scanned in
Scan Qty: How many of those parts were scanned
OnHand: How many parts there are according to DealerTrack
PNC: Part Number Change( simply used to see if there are any other part numbers used to reference this part)
Manufacturer: Maker of the Part
Red Percentage Number: Battery Life
Start by scanning the bin location first, then scanning the part number. The quantity field will have a 1 there automatically; you can leave it there and scan more items, or type in a custom quantity amount and then hit the "ENT" key on the bottom right of the scanner keypad. If it's a bad scan, type in a 0 in that QTY field, and then hit enter. Continue scanning until you've accounted for every part number inside of that bin physically.
When you scan the last part number in a bin, hit the "ENT" key, and then scan the next location.
When you've scanned for about 20-30minutes, you will want to move the scans from the scanner, and onto the computer. To do so, simply place the scanner back into the charging cradle connected to the computer, and then click on the Sync Scanner button again. This will remove the scanned items from the scanner, and put them into your physical inventory report. Continue this process until you have scanned your entire inventory.
Repeat the steps above until you're finished with your inventory.
Checking For Discrepancies, Mixed Bins, and Yellow Pad
Step 5 - Viewing Your Reports. Clicking on the Reports Button then Physical Inventory button will display several tabs that allow you to examine the results of the scanning operations.
The list of sheets are color coded. If the sheet number is “Green” then all the parts for that sheet balance out with what was on the sheet vs what was scanned. “Red” indicates some issue on that sheet or line.
Clicking on a sheet will then display the details for that sheet or Bin location depending on which tab you are reviewing.
Tab Explanation -
Sheets: Allows you to view your inventory according to their sheet number
Bins: Allows you to view your inventory according to their bin location
Discrepancies: Allows you to view your inventory discrepancies *Parts with no discrepancies will not show up here.
Yellow Pad: Allows you to see Part Numbers scanned that we did not download from your DMS
Raw Sheets: This will display your entire inventory
Step 5 - Making Adjustments. Right clicking on a part number will display different options you can choose from, in order to make adjustments.
- Selecting Zero Selected Scan Counts will reset the count to 0 for all selected lines.
- Selecting Change Scan Count will display the following:
You may type in the desired new scan quantity, or simply make the scan count match the On Hand Count by clicking on the check box on the left. Selecting Okay will refresh the reports, and you will see any changes made show in the "Changed" column.
Step 6 - Adjusting with your -1 Sheet. There is a special sheet number that you may see at the top of the sheet report(-1 Sheet). Any items that have been scanned that cannot be matched up to a sheet number and line number will be placed on the -1 sheet. Furthermore part numbers that have been scanned in a bin location that doesn't match with the DMS records will shown here as well. Clicking on this sheet number will display a list of these scans.
- The Write ins tab display any part number that may not have been downloaded from your DMS. These will be part numbers that you will have to manually write in, after uploading the inventory sheets to DealerTrack DMS.
- The Mixed Bins tab will display part numbers that were scanned in a bin that didn't match your records in the DMS. You will have a few options in order to make sure they are where you want them to be. First click on the -1 sheet, and then click on the Mixed Bins tab.
Then click the " + " box to the left of sheet number, you will see 4 check boxes describing actions to do to the part number. The checkboxes represent the action above it.
- Yellow Pad will move the part number over to the write in tab.
- Discard will remove the scan from inventory.
- MoveToScannedBin will move the part number, as well as upload it to your DMS when the sheets are uploaded, to the bin that you scanned it in.
- MoveToOriginalBin will keep the part number in the same bin that it is in, inside the DMS.
The column header "Bin" represents the bin that the part number was scanned in
The column header "ExpectedBin" represents the bin that that part number is in, inside the DMS.
After checking the desired action, click on apply changes to submit your changes.
Continue to make these changes until you are finished with adjusting your inventory.
Uploading and Posting Your Sheets
Step 7 - Uploading Your Sheets. Once you've finished adjusting, simply click the "Start Posting" button on the top of PartsWizard. You will get a selection box, select "Upload Inventory Sheets" and then click "OK"
Step 8 - Yellow Padding and Posting your Inventory. Your sheets will get automatically uploaded and will be ready for review inside the Physical Inventory category on DealerTrack. Once the sheets are uploaded, you will need to check all of the 'out standing sheets'. This is normal, and all you have to do is write down the outstanding sheet numbers, then navigate to each sheet and click Ok. Afterward you will need to manually add in parts that were unknown, and showed up in the yellow pad, or write ins, list.
When you are finished with yellow pads, you can review your variance, and finally post your sheets.
Congratulations, you're finished with your Physical Inventory.