Cycle Count

670605214 · ‎March 31, 2023

Looking for simplest way to do a physical count of inventory using QB. Our business has 10 inventory locations and each location has bins within the location. Some of these locations have hundreds of bins within their sites. We sell juice that is stored in containers and stashed away on a shelves with a specific numbering system. Because there are so many bin locations within these sites (around 500 total) QB doesn't seem to do a good job with cycle count filtering. I am unable to filter a cycle count with bin locations. Our bins are numbered in order so a physical inventory count includes beginning with 1-A-1, 1-A-2, 1-A-3 and so on. It seems the only filtering that can be done in the cycle count is by item alphabetically. This is no help. I need to be able to do cycle counts starting from A-Z rather than going item to item within 500 bin locations and constantly scrambling back and forth within the inventory location to find each specific bin.

Not sure if anyone can make sense of this but it is extremely frustrating that I cannot seem to find a way to do a physical count in QB starting from A-Z. I need to be able to filter bin locations from start to finish that would replicate the direction a physical count would be done within our inventory sites.

Angelyn_T · ‎March 31, 2023

Thank you for posting the details of your concern, @670605214. I'm can share some insights about filtering cycle count in QuickBooks Desktop (QBDT).

I understand how important filtering a cycle count with bin locations in QBDT is for you and your business. This way, you can track your inventory easily without going to each item. While the option is unavailable, I recommend sending a feature request directly to our product developers. This way, they can determine what enhancements and improvements are needed to make our product more effective and convenient for our users. Rest assured they're working nonstop to enhance the product and deliver the best experiences for all QuickBooks users.

Here's how:

Open your QBDT file.
Go to the Help menu, then click on Send Feedback Online.
Tap on Product Suggestion.
Enter your feedback, then Send Feedback.

For now, you can skim through the resources from these links for more tips while managing your advanced inventory in our system:

Please feel free to get back to me in the comment section below if you have follow-up questions. I'm always here to help. Have a good one!

JasonB17 · ‎February 28, 2024

Has there been any update regarding the concern? Our warehouse is set up similar and there is no way to start at one shelf and continue until that section is complete. We try and cycle count weekly but physically typing ever part is tedious and quite frankly a waste of man hours.

670605214 · ‎February 28, 2024

No updates unfortunately! You are still limited to only sorting by item in the cycle count which seems stupid to me. We have been recording every transfer and build as accurately as possible and are still recording physical counts withing an excel spreadsheet and then comparing to QB inventory rather than using cycle counts which i would love to start using......

JasonB17 · ‎February 28, 2024

Shocking, it seems every commonsense problem posted on here is replied to with... Our engineers haven't gotten to it yet, make a suggestion. I'd believe QB is big enough to have more than 2 engineers working on issues.

Topics

Training

Community

Resources

Cycle Count

Cycle Count

Cycle Count

Cycle Count

Cycle Count

Need to get in touch?