Enjoying what you’re reading? Sign up now.

Subscribe
Search

Speed Up Your Physical Inventory with Bin Location Reports

Article Highlights:

  • Use Dynamic Reporting to help the inventory process run smoother.
  • Learn how to get relevant part inventory details.

It’s that time of year – physical inventories. To help the process go much smoother, a quick list of the bin locations and the parts associated with each bin in your parts department definitely comes in handy.

Using Dynamic Reporting, you can create a Bin Listing and Detail Report. This report provides general bin information that can be expanded to individual part details within each bin (To see how to create the report within Dynamic Reporting, click here).

How to Run the Bin Listing and Detail Report

After creating the report in Dynamic Reporting, go to the Search Dynamic Reporting screen (Retail Management Intelligence > Dynamic Reporting). Use the Search Criteria at the top of the screen to find the report.

Once the report displays in the Results Found section, highlight it and press F10 or double-click it to run the report.

When the report runs, it will initially give you a listing of each bin, as well as the total amounts and quantities for the bin.

sed_Dynamic-Reporting_600x400

Get the Details

You can select the expand icon to the left of the bin names to see individual part details for each bin. You can also right-click the expand icon and select Expand All to display the part detail for all bins at once. This displays a list of all individual parts within each bin, as well as their relevant value and quantity information.

sed_Dynamic-Reporting-breakdown_600x400

Save Time During Physical Inventory

Running this report prior to physical inventory time will:

  • Allow you to correct the bin location on parts that have been noted incorrectly.
  • Reduce count sheets for bin locations that do not exist.
  • Eliminate searching for bin locations that do not exist.

For more inventory and other training opportunities, check out Reynolds Software Education for upcoming webinars and classes.

Share this Article

Software Education, Reynolds and Reynolds

Jennifer McReynolds has worked in Software Education over 15 years. In addition to overseeing the training of her instructors, Jennifer reviews and updates course materials to match recent software changes.

Related Articles:

In the first of this three-part series on utilizing Contact Management, I discussed distribution rules and options to ensure all leads are going to the right place.

Without the first cup of coffee, starting the day off at work can be hard, especially for a manager. With voicemails, emails, customers coming in

In this three-part series on Contact Management, I’m going to discuss topics that we frequently work with customers to solve. The first is Prospect Leads.

How will you make profit in other areas of your dealership if vehicle sales decline? This is a question you need to ask every day. Now is