Talk to Sales: 877-683-3280

Hours

Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST

Product support & help

Need help signing in?

Question

Physical inventory worksheet by BIN

Forum|Forum|5 years ago
June 10, 2021
5 replies
43 views

I can't find a report or a way to build a report where it shows me inventory by BIN.

I've seen a report were it tells me XXX item is in Bin A, Bin B and Bin C, and YYY Item is in BIN C and BIN X.

But to do an easier physical inventory, I'd wish a report that'd tell me:
Bin A should have: 10 items A, 5 items C, 5 Items E. etc.

Bin B should have: 5 Items A, 7 Items F, 3 Items L, etc.

That way I can verify my physical inventory 1 bin at a time (not 1 item at a time), and not have to be jumping from Bin to Bin.

I've got enterprise. So not sure if advanced reporting might show me this report.

Level 6

Hi there, 940alex.

Let me provide you some helpful features that you can use in managing your inventory.

You can purchase or subscribe to Advanced Inventory which allows you to use bin or lot tracking if you're using QuickBooks Desktop Enterprise.

To turn on Advanced Inventory:

From the Edit menu, select Preferences.
On the left pane, choose Items & Inventory then go to the Company Preferences tab.
Check the Inventory and Purchase Orders are Active box.
Select the Advanced Inventory Settings button.

You can run a report for actual quantities on hand after you turn on the advanced inventory. Let me share with you the steps on how to check it.

Select Reports and then Inventory.
To check your product’s value, select the Inventory Valuation Summary.
To check your product’s quantity, select the Inventory Stock Status by Item.

After you turn on the Advance Inventory feature, you can Set up Advanced Inventory to make sure your quantity on hand by the site is accurate.

For additional insight, you may check out this article: Turn on Advanced Inventory

I've also added this article that you can use in the future: Use the Sales Order Fulfillment Worksheet

If you have additional questions with the Advance Inventory, don't hesitate to let me know. I'll do my best to answer them for you.

I do have QB Enterprise and do use Advanced Inventory.

But how to I get a report of inventory by BIN? (not by item)

QuickBooks Team

QuickBooks Team

Hello there, @940alex.

Thanks for dropping by the QuickBooks Community. I'd be glad to help set up the inventory, so you can efficiently track the items.

You’re on the right track with setting up the Advanced Inventory. Since there isn’t a direct way of making the bay locations as sub-item to the aisle, you can use the Inventory Site field as the aisle and the Bin column as the bay.

For detailed instructions, follow the steps below.

To set up the aisle:

Go to Inventory at the top menu bar.
Select Adjust Quantity/Value on Hand.
Click on the Inventory Site drop-down, and select Add New.
On the New Inventory Site window, enter Aisle 1 in the Name field.
Fill in the necessary fields.
Once done, click on OK.

To create a bay:

From the Adjust Quantity/Value on Hand window, go to the Bin column.
Then click on the drop-down and select Add new.
In the New Inventory Site window, enter the bay name. For example, Bay 1.
Fill in the necessary fields.
Click on OK.

I've added a screenshot of how the aisle and bay look like after following the steps. Check out this link to give more insights about Advanced Inventory.

If you need further assistance with any of the steps, let me know by posting a comment below. I'll be around to help.