Articles in this section

[ANDROID SCANNERS]How-To: Perform Full Physical Inventory with Wireless Scanning

Elton
  • Updated
Follow

 

 

Please note that you will have to schedule a Physical Inventory through our reservation page and Dealertracks's supplies site. Please follow this guide if you need help in doing either of those. 

 

 

If you need to do bin checks and not a full physical inventory with sheets, then please refer to our Inventory guide which can be found here. 

 

Table of Contents

 

Generating Count Sheets, Downloading Your Inventory and Syncing the Scanners

Step 1 - Creating Count Sheets.

  1. dealerTrackPartsTab.pngLog-in to DealerTrack DMS and then navigate to the Physical Inventory section.
  2. dealerTrackPhysicalInventoryTab.pngOn the bottom of the screen, click on the "Add" button.
  3. Insure that the following items are correct before adding the Sheets to your DMS.
    1.     Type of Inventory: From Bin*FIRST to Bin *LAST
          Manufacturer: All
          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
          Printer: QPRINT
          Copies: 1
          Output Type*: None
  4. DealerTrack_Sheet_Settings.pngThe physical inventory selection options should look like the image above
  5. Click Ok
  6. dealerTrackSheetsCreated.pngYou will see the sheets added, similar to above
  7. Click exit to exit out of the Physical Inventory Section.

Step 2 - Setting Up The Scanners For Syncing

  1. Launch into the scan wizard app on the scanner
  2. Click on the Done Scanning button
  3. Verify that the screen displays Waiting on Command
    1. If the scanner just displays connecting, or something else, give your support representative a call

Step 3 - Downloading The Physical Inventory Sheets.

  1. DownloadFromDMS.pngClick on the Download button on PartsWizard, and choose "Download From DMS".
  2. DownloadWizard.png
    Select the option for Inventory, and click on the check box for physical inventory sheets, with today's date. Click OK.
  3. This download can take a few moments to finish as it will be grabbing your inventory from the DMS and the sheets we've created. 
  4. Once the download has finished, Partswizard will begin to automatically synchronize each scanner that is displaying the "Waiting on Command" screen. Once the Download Status box has disappeared you will be ready to very your sheets and bins.

Step 4 - Verifying Sheets and Bins Downloaded Properly

  1. Ensure that the sheets tabs do not have duplicate parts
  2. Ensure that the bins tabs do not have duplicate parts 
  3. If you have duplicates in either the sheets or bins please give your support representative a call

The Scanning Process

  1. Click on the inventory button on the scanner.
  2. Scan the bin location first.
  3. Scan the part numbers inside the bins. You can adjust the quantity in the QTY field, by manually typing in the number and hitting enter on the virtual keypad.
  4. Delete bad scans by typing 0 in the QTY field and hitting Okay on the confirmation pop up.
  5. The scanner will have audible ques:
    1. Wrong Bin – This means that according to the DMS the bin selected does not match the bin it was in, on the DMS.
    2. Unknown – This means that you’ve scanned a bad part number, or we do not have a record of this part and will need to be written in on Dealertrack as a yellow pad part.

Checking For Discrepancies, Mixed Bins, and Yellow Pad

Step 1 - Overview

This guide outlines the 6 reports in Parts Wizard to manage your physical inventory:

  1. Sheets: a report table that displays your inventory separated by each sheet.
  2. Bins: a report table that displays your inventory separated by each bin.
  3. Discrepancies: a report table that displays every part that has a variance in the scan count vs on hand count.
  4. Yellow Pad: a report table that displays scanned parts that do not have a sheet and will need to be entered into Dealertrack as a yellow pad part.
  5. Mixed Bins: a report table that displays parts that have been scanned in a bin location that differs from what Dealertrack has on file.
  6. Raw Sheets: a report table that is unfiltered and displays everything downloaded and everything scanned.

These reports aid in validating scans and ensuring inventory sheets are posted correctly.

Step 2 - Standard Workflow

        1. Scan inventory to populate reports, ensuring scan count accuracy and proper bin location for part numbers.
        2. Use reports to validate scan counts and desired bin locations for parts scanned.
        3. Review variances in any report; 'Sheets' and 'Bins' reports have checkboxes to mark completed reviews for assistance in reviewing every bin and/or sheet.
          1. Sheets and Bin Reports contain two panels. Consider the one on the left the Information Panel, which list your sheet numbers or bin locations in order
          2. Consider the panel on the right your Action Panel as you're enabled to perform a multitude of actions to adjust scans and more.
        4. Address 'Mixed Bins' report to update bin locations in Dealertrack; consider this your DMS update tool for selected part numbers and place the part numbers in the bins you’d like them to belong too.
        5. At a minimum you should manually verify each bin in the 'Bins' report. Confirm scan counts and part’s bin locations, marking each bin as reviewed once verified by checking the check box.

Keep in mind any scan updates to a bin will result in the removal of a check mark if one has been made to the same bin location on the report.

Step 3 - In-Depth View of Reports

Sheets

The Sheets Tab arranges each sheet numerically, comprising two main panels: the Information Panel on the left and the larger Action Panel on the right.

Information Panel:

            1. Here you'll find several fields and options:
              1. Checkbox: Indicates whether the sheet has been reviewed.
              2. Sheet #: The number of the sheet.
              3. Scanned Items: Number of items scanned in that specific sheet.
              4. Variance: Difference between scanned items and what the DMS reports as the on-hand count and its unit cost.
            2. Color Codes:
              1. Red: Indicates a variance.
              2. Green: Indicates no variance.
            3. Right-Click Options: If you right click in the information panel you will get the following options:
              1. Print Sheets: Prints the selected entire sheets.
              2. Print Sheet Variances: Prints only the variances within the selected sheets.
              3. You can select multiple sheets and print them at the same time by clicking on the sheet you want, holding that click and dragging down until all the sheets you wish to print are highlighted.

Action Panel:

The Action Panel contains detailed information about the parts that belong to your selected sheet.

            1. The fields include:
              1. Line #: The line number for the part within the sheet.
              2. Bin Location: Where the item was physically scanned.
              3. Expected Bin: The bin where the item is supposed to be located according to the DMS.
              4. Part Number
              5. Description: Detailed information about the part number.
              6. OH (On Hand): The count of items on hand.
              7. SC (Scan Count): The count of scanned items.
              8. Error: Any errors or discrepancies.
              9. Unit Cost: The cost of a single unit of the item.
              10. Posted: Whether the item has been posted in the system.
              11. Changed: Indicates if there have been any recent changes to the part’s details and what those changes were
              12. Mfg (Manufacturer): The manufacturer of the part.
            2. Right-Click Options in Action Panel:
              1. Find Part Number [Shortcut: Ctrl-P]: Pops up a box showing you where each instance of this part number is found within the entire sheets, downloaded from the DMS.
              2. Zero Selected Scan Counts [Shortcut: Ctrl-Z]:  Will set the scan count [SC] entry to 0 for the parts selected.
              3. Change Scan Count [Shortcut: Ctrl-S]: Will set the scan count entry to the new number you type in for the selected parts.
              4. Change Bin Location [Shortcut: Ctrl-B]: Will change the scanned bin location [BIN column] to a bin of your choosing. Think of this as the bin you want your part to be in when we post the inventory later.
              5. Repost: Will post any update to bin location or scan count for the part selected. This will be for the sheet number & line number location for the part and where you would refer too on the sheets table on the DMS to verify the correct changes. This will only repost for the parts highlighted
              6. Copy Part Number [Shortcut: Ctrl-C]: Will copy the part number selected

Bin Tabs

This tab also includes two main panels, the Information Panel and the Action Panel, similar to the Sheets Tab.

Information Panel:

        1. Checkbox: Indicates whether the sheet has been reviewed.
        2. Bin #: The bin location.
        3. Scanned Items: Number of items scanned in that specific sheet.
        4. Variance: Difference between scanned items and what the DMS reports as the on-hand count and its unit cost.
        5. Color Codes:
          1. Red: Indicates a variance.
          2. Green: Indicates no variance.
        6. Right-Click Options: If you right click in the information panel you will get the following options:
          1. Print Bins: Prints the selected entire sheets.
          2. Print Bin Variances: Prints only the variances within the selected bins.

You can select multiple bins and print them at the same time by clicking on the bin you want, holding that click and dragging down until all the bins you wish to print are highlighted

Action Panel:

The Action Panel contains detailed information about the parts that belong to your selected bin.

      1. The fields include:
        1. Sheet #: The sheet number for the part within the bin
        2. Line #: The line number for the part within the sheet.
        3. Expected Bin: The bin where the item is supposed to be located according to the DMS.
        4. Part Number
        5. Description: Detailed information about the part.
        6. OH (On Hand): The count of items on hand.
        7. SC (Scan Count): The count of scanned items.
        8. Error: Any errors or discrepancies.
        9. Unit Cost: The cost of a single unit of the item.
        10. Posted: Whether the item has been posted in the system.
        11. Changed: Indicates if there have been any recent changes to the part’s details and what those changes were
        12. Mfg (Manufacturer): The manufacturer of the part.
      2. Right-Click Options in Action Panel:
        1. Find Part Number [Shortcut: Ctrl-P]: Pops up a box showing you where each instance of this part number is found within the entire sheets we downloaded from the DMS.
        2. Zero Selected Scan Counts [Shortcut: Ctrl-Z]:  Will set the scan count [SC] entry to 0 for the parts selected.
        3. Change Scan Count [Shortcut: Ctrl-S]: Will set the scan count entry to the new number you type in for the selected parts.
        4. Change Bin Location [Shortcut: Ctrl-B]: Will change the scanned bin location [BIN column] to a bin of your choosing. Think of this as the bin you want your part to be in when we post the inventory later.
        5. Repost: Will post any update to bin location or scan count for the part selected. This will be for the sheet number & line number location for the part and where you would refer too on the sheets table on the DMS to verify the correct changes. This will only repost for the parts highlighted
        6. Copy Part Number [Shortcut: Ctrl-C]: Will copy the part number selected
      3. When a bin has been scanned in, manually review the bin report, account for any discrepancies using the various options available, such as changing the scan count.
      4. When you are satisfied with each line in the bin, check mark the bin in the information pane by clicking on the checkbox.
      5. Repeat this process until you have reviewed every bin

Discrepancies

The Discrepancies Tab is designed to highlight every part that shows a variance between the on-hand count and the scanned count.

Information Displayed:

        1. Line Count: Shows the total number of items that have a variance.
        2. Discrepancy Report Table - A detailed table displaying information for each part with discrepancies, line by line:
          1. Sheet #: The sheet number for the part within the expected bin location
          2. Line #: The line number for the part within the sheet.
          3. Expected Bin: The bin where the item is supposed to be located according to the DMS.
          4. BIN: The bin location where the part was physically scanned at
          5. Part Number
          6. Description: Detailed information about the part.
          7. OH (On Hand): The count of items on hand.
          8. SC (Scan Count): The count of scanned items.
          9. Error: Any errors or discrepancies.
          10. Unit Cost: The cost of a single unit of the item.
          11. Posted: Whether the item has been posted in the system.
          12. Mfg (Manufacturer): The manufacturer of the part.

Actions Available

          1. Print:
            1. This will print the entire discrepancy report to a printer of your choosing
          2. Right-Click Options:
            1. Find Part Number [Shortcut: Ctrl-P]: Pops up a box showing you where each instance of this part number is found within the entire sheets we downloaded from the DMS.
            2. Zero Selected Scan Counts [Shortcut: Ctrl-Z]:  Will set the scan count [SC] entry to 0 for the parts selected.
            3. Change Scan Count [Shortcut: Ctrl-S]: Will set the scan count entry to the new number you type in for the selected parts.
            4. Change Bin Location [Shortcut: Ctrl-B]: Will change the scanned bin location [BIN column] to a bin of your choosing. Think of this as the bin you want your part to be in when we post the inventory later.
            5. Repost: Will post any update to bin location or scan count for the part selected. This will be for the sheet number & line number location for the part and where you would refer too on the sheets table on the DMS to verify the correct changes. This will only repost for the parts highlighted.
            6. Copy Part Number [Shortcut: Ctrl-C]: Will copy the part number selected

Yellow Pad

Displays all part numbers that were scanned but are not yet in Dealertrack, meaning they lack bin location or other crucial information.

  1. Input the required information: Bin, Manufacturer, Unit Cost, and Description per part 
  2. Check the box on the left side of each part to mark them as ready for upload
  3. You can upload these parts individually by right clicking on the part and choosing "Repost" or check all of the parts with the required information, and upload the sheets at the very end. The upload will include all yellow pad items checked as well. 

Information Displayed:

        1. Total Line Count: Displays the total line count for yellow pad items.
        2. Unknown Part Table: A table detailing each unregistered part's information:
          1. Expected Bin: The bin where the item is supposed to be located according to the DMS.
          2. BIN: The bin location where the part was physically scanned at
          3. Part Number
          4. Description: Detailed information about the part.
          5. OH (On Hand): The count of items on hand.
          6. SC (Scan Count): The count of scanned items.
          7. Error: Any errors or discrepancies.
          8. Unit Cost: The cost of a single unit of the item.
          9. Posted: Whether the item has been posted in the system.
          10. Mfg (Manufacturer): The manufacturer of the part.
          11. StkGr: Stock group this part may belong too
          12. Error Message: Any error message that has been received from Dealertrack after attempting to upload the part as a yellow pad item

Right-Click Options:

        1. Find Part Number [Shortcut: Ctrl-P]: Pops up a box showing you where each instance of this part number is found within the entire sheets we downloaded from the DMS.
        2. Zero Selected Scan Counts [Shortcut: Ctrl-Z]:  Will set the scan count [SC] entry to 0 for the parts selected.
        3. Change Scan Count [Shortcut: Ctrl-S]: Will set the scan count entry to the new number you type in for the selected parts.
        4. Change Bin Location [Shortcut: Ctrl-B]: Will change the scanned bin location [BIN column] to a bin of your choosing. Think of this as the bin you want your part to be in when we post the inventory later.
        5. Repost: Will post any update to bin location or scan count for the part selected. This will be for the sheet number & line number location for the part and where you would refer too on the sheets table on the DMS to verify the correct changes. This will only repost for the parts highlighted
        6. Copy Part Number [Shortcut: Ctrl-C]: Will copy the part number selected
        7. Check Selected: Marks the selected parts as ready for upload
        8. Check All: Marks all parts as checked and ready for upload
        9. Uncheck Selected: Unmarks the selected parts.
        10. Uncheck All: Unmarks all parts.

 

Mixed Bins

Displays all the parts that have been scanned in different bin locations than what DealerTrack reflects. This is where you can clear up any bin discrepancies and place parts in their proper locations.

        1. Total Line Count: Displays a cumulative line count for each part number that has been scanned into a varying bin location.
        2. Mixed Bin Part Number Table: Provides a comprehensive table detailing each part's information:
          1. Sheet Number: The sheet where the part is listed.
          2. Line Number: Specific line on the sheet where the part can be found.
          3. Bin: The bin where the item was physically scanned.
          4. Expected Bin: The bin location according to the DMS.
          5. Part Number
          6. Description: Detailed information about the part.
          7. On Hand: The current on-hand count as per the DMS.
          8. Scanned: The count of the item as per the latest scanning activity.
          9. Error: Shows any discrepancies between the expected and actual counts.
          10. Manufacturer: The company that produced the part.

Actionable Options:

Hitting the expand button will display the Move to Scanned Bin and Move to Expected Bin options, additionally inputting the hotkey will select the correlating option without expanding:

        1. Yellow Pad [Ctrl-Y]: Moves the selected items to the Yellow Pad Tab for further inspection or action.
        2. Discard [Ctrl-D]: Deletes the selected items from the Mixed Bins Tab.
        3. Move to Scanned Bin [Ctrl-S]: Moves the selected parts to the bin location where they were physically scanned.
        4. Move to Expected Bin [Ctrl-O]: Moves the selected parts to their expected bin location according to the DMS.

Select the desired option, and then click apply changes. This will move the part to the selected bin, or discard that part, or add that part to the yellow pad list.

Do this for all lines in the mixed bin report

 

Raw Sheets

The Raw Sheets Tab serves as a comprehensive platform to display all sheets and their individual lines that have been downloaded into the system. This tab offers an unfiltered view into the state of the inventory.

Information Panel:

        1. Line Count: Shows a count of all part numbers on a line-by-line basis, offering a high-resolution look at inventory.
        2. Inventory Table: A table that contains in-depth information about each part number:
          1. Sheet Number: Identifies the sheet where the part number is listed.
          2. Line Number: The specific line within the sheet where the part number appears.
          3. Bin Location: Where the part is or should be stored.
          4. Part Number: The identifier for the part.
          5. Description: Additional details or clarification about the part.
          6. On Hand: The quantity that should be available, as per the system.
          7. Scanned Count: Actual counted quantity during the scan.
          8. Error: Displays discrepancies between "On Hand" and "Scanned Count."
          9. Unit Cost: The cost per unit of the part.
          10. Posted: Indicates whether the data has been posted to the database.
          11. Changed: Flags if there have been any changes to the data since it was posted.
          12. Manufacturer (Mfg): Identifies who made the part.
          13. Error Message: Displays any system or operational errors associated with the part.

Action Panel:

        1. Find Part Number: Searches for a specific part number within the tab.
        2. Zero Selected Scan Counts: Resets the scanned count for selected items to zero.
        3. Change Scan Count: Allows you to manually update the scanned count of a part.
        4. Change Bin Location: Enables changing the bin location for a selected part.
        5. Repost: Allows for the reposting of updated data to the database.
        6. Copy Part Number: Copies the part number to the clipboard for use in other applications.
        7. Reconcile: Matches the scanned counts with the system counts, updating any discrepancies.

Posting Your Sheets, Yellow Pad Items and Optional Yellow Pad Entry via Dealertrack

Step 1. Uploading Sheets

When uploading sheets, you will be updating Dealertrack with the sheets, and their count numbers. Do this once you have manually reviewed your variances and are satisfied with accurate counts.

    1. Click on the Post button on Parts Wizard
    2. Click on the upload count sheets button
      1. uploadingCountSheets.png
    3. Wait for the upload to finish, you will get a final pop up notifying what sheets and yellow pad items(only those with proper information inputted in the yellow pad tab) got uploaded 

Step 2. [Optional] Adding Yellow Pad Items via Dealertrack

If you have yellow pad items that you would like to upload to Dealertrack(Parts that are not yet entered into the DMS)and do not want to use our software to upload yellow pad items you can do so afterwards through the DMS

    1. Click on the yellow pad option on the physical inventory screen on Dealertrack
    2. yellowpadAddHighlight.jpgClick on Add
    3. Type in the part number, input a bin location, description, and unit cost. Click Ok when done
    4. Repeat for each part that needs to be entered on yellow pad

Step 3 - Fixing the Outstanding Sheets

Click exit to get out of the yellow pad screen. Go back to the PI category and this time choose the 1st option, Enter Count.

You'll See a screen like this:

mceclip2.png

 

To fix these sheets, type the sheet number, for this example that would be 98,195,292,389,486) and one by one type them into the sheet number field, click ok, and then click Ok.

OutstandingSheetOverview.jpg

On the next screen

mceclip3.png

Then click Ok. Do this for all the remaining sheets, then click cancel to get out of that page. 

 

Step 3. Checking the unit variance

click on the drop down arrow and select the option for unit variance, the click enter.

You will see this screen:

mceclip4.png

This will be the final review, ensure that this unite variance is good with you before proceeding with posting and finalizing the PI.

Count < Computer is the physical count that is less than the computer count(DT)

Count > Computer is the physical count that is bigger than the computer count(DT)

If you wish to print, or email, a specific part of the unit variance then simply hit the drop down arrow and select either option. 

To email, select the print option and hit enter:

mceclip5.png

Then choose the output type. Typically this will be CSV. Click Ok

mceclip6.png

Now type in the emails, and hit send.

Step 5. Posting Your Sheets

Now we are ready to post these sheets to do so, go back into the Physical Inventory Category by clicking exit. 

Click on the drop down arrow next to the sheets you created and scroll down and choose the option 9 for posting:

mceclip7.png

Click enter, and you'll be given this prompt:

mceclip8.png

Press Enter to finalize the sheets. It will take a couple of minutes but after its finished the prompt will disappear and you will no longer see the sheets:

mceclip9.png

Related articles

Comments

0 comments

Article is closed for comments.