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 second of our two part series on the transition to Dynamic Reporting, I want to shift the focus to functionality. One of the

The end of the year for most people involves spending time with family and gift-giving. But for those working in the office, it means something

By now, you’ve probably started making the change from Report Generator to Dynamic Reporting. We are committed to helping you make that change. In the

The average vehicle makes 2.7 service visits per year with an average bill of $178 per visit. Franchise dealers are only getting 30 percent of these visits—missing