Skip to main content
April 22, 2024
Question

Default bin location

  • April 22, 2024
  • 1 reply
  • 0 views

None of our inventory was previously assigned a bin location. It was all under "unassigned" for a bin location. I went through and added default bin locations to many of the items. How can I transfer the items from "unassigned" to their respective default bin locations? Also, is there a report that will show what the default bin locations are for each item that has one, or will it only show the current location the items are in?

1 reply

April 22, 2024

You're on the right track, @dmk475. Let me help you transfer the items from unassigned to the default bin location in QuickBooks Desktop (QDBT).

 

To assign a bin location to an item, you can use the Transfer Inventory feature to transfer your inventory from one bin to another bin location. You can follow these simple steps:

 

  1. Go to Inventory.
  2. Select Transfer Inventory.
  3. Fill in all the information needed, such as the DateReference No.ClassTransfer From, and To
  4. Note: You must select the same site in the Transfer From and To fields since you are about to specify a bin location for your inventory items.
  5. Choose all the inventory items you need to transfer.
  6. Enter the transfer details as appropriate.
  7. Select Save & Close.

 

Once done, you can run the Items by Bin Location report and customize it to add the bin location column. This way, you can see where the product was invoiced from. 

 

Follow these steps:

 

  1. Click the Reports menu at the top.
  2. Choose Inventory and select Items by Bin Location.
  3. Click the Customize Report button.
  4. Go to the Display tab. Then, checkmark the Bin Location.
  5. Click OK.

 

I've added an article that'll help you track your inventory at different locations in QuickBooks: Multiple Inventory Sites.

 

For additional information on how to customize the data, delete columns, and add or remove information on the header/footer, refer to this article: Customize reports in QuickBooks Desktop.

 

If you need further assistance in managing your inventory, please don't hesitate to let me know by commenting below. I am always happy to assist you, @dmk475. Have a great day!

dmk475Author
April 22, 2024

Ok. Thanks! How do I assigned default sales and purchase bins? I went into add/edit multiple items and added the needed columns. But I can't do anything with those two cells. There's a drop down arrow in the cells, but it doesn't do anything. I can't type anything in them either.

dmk475Author
April 22, 2024

Sorry! I got it. I didn't have the site selected.