One feature in Advanced Inventory is the option to use bins in QuickBooks Enterprise. Bins are a great option to help organize inventory in your warehouse.
What are bins? QuickBooks defines these as rows, shelves or bins within a warehouse. Each warehouse can have a unique set of bins.
Setting up Bins in QuickBooks Enterprise
First, bin location tracking must be selected in Preferences. From the Edit Menu, select Preferences, and from the Company Preferences tab (at the top) select Items & Inventory (at the left). You will need to be in single user mode to do this. Then select “Advanced Inventory Settings” at the bottom of the screen.
You will then see the following screen.
Select the Multiple Inventory Locations tab and click “Track Bin Locations within Inventory Sites”. You have now activated bins in QuickBooks Enterprise.
Creating Bin Locations
Bins are considered locations within a warehouse. As such, they can be considered a sub-location or sub-warehouse. From the main menu, select Lists > Inventory Site List. Warehouses are listed first and bins are listed below each warehouse.
Bins appear as indented locations, since they act as a “sub-warehouse”. Click on the “Inventory Site” button at the bottom left of the Inventory Site List to create a new bin. You will see the following window:
Make sure to click the option “is a bin within site”. That lets QuickBooks know that you want to create a bin and not a warehouse. Enter the new bin name on the first line. The bin name can be alpha / numeric, can contain special characters and be 31 characters long. On the second line select the warehouse from the list. Add any description for the bin that you like. Select “OK” and you have created a new bin in QuickBooks Enterprise.
Bins are considered locations within a warehouse. As such, they can be considered a sub-location or sub-warehouse.
Using Bins in QuickBooks Enterprise
So now what? You will now see bin locations on both purchase and sales forms. Let’s look at an example. We are going to use a Purchase Order to order some inventory.
You must first select a warehouse in the “Ship To” field at the upper right hand corner. You cannot select a bin until after you have selected a warehouse in the “Ship To” field. Not sure which bin to select? From this screen you can actually see a count per bin for that item within the warehouse you selected. In the bin field, select the drop down arrow.
We now see a window which shows us that Quantity on hand for that item by bin location.
Also note that if you do not see all the the bins for the selected warehouse, you may have to click “Show All” at the top. From this window, you can also select “Add New” and create a new bin without having to leave the purchase order form.
When you receive the inventory, the Item Receipt includes the bin you selected on the Purchase Order. Also, there is a new print option in the Receive Inventory window: Sorted Stock List. You will see this option after you have received the inventory.
An example of this report is shown below.
This allows you to sort by bin. In our warehouse, Bin #2 is actually the first bin, so we sort in that order. This option is also available on Sales Orders where you can print a Sorted Pick List.
Assigning more than one item to a Bin
When assigning inventory to bins, it would be unusual to put more than one type of item in a bin. You might have 50 of the same size bolt in the same bin, but less likely to have a mixture of sizes in the same bin. QuickBooks will allow either, but will give you a message:
Selling Inventory from Bins
Sales forms such as Estimates, Sales Orders, Invoices, Sales Receipts and even Statement Charges all include the option to sell inventory from a particular bin. So QuickBooks will update the inventory count in each bin when a sale is made. Here is an example of an invoice with a column for bins.
Reports using Bin Locations
There are several ways to see information for bins in QuickBooks Enterprise. If you customize the columns on Items List, you can add “Bin Location” to the view.
Click on the Activities button at the bottom of the Items list and you will see an option to show Current Availability.
After clicking this option you will see the following window listing Quantity on Hand for each location. You can select any inventory item by using the drop down option at the top.
From the Reports menu, select Inventory and you will see a new report “Items By Bin Location”. Here is an example.
If you need to move your inventory to a new bin, simply select “Transfer Inventory” from the Inventory menu. Then fill out the transfer form and include the bins being changed.
Setting Default Bins
Is there a way to set default bins in QuickBooks? This can be done from the Items list by selecting “Add / Edit Multiple Items”. If you customize the columns on the screen, you will see the option to add default columns. Make sure to select a Warehouse at the top.
Interested in Learning More? Call Today to Schedule an Appointment with a Certified QuickBooks ProAdvisor
We provide both local and remote support.