Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Multiple Inventory Locations

Multiple Inventory Locations tracks inventory you store at different sites (warehouses), bin locations (rows, shelves, or bins), or both.

You can:

  • Keep track of how much inventory (number of units and dollar value) you store at each site (warehouse)

    QuickBooks provides 4 reports to help you keep track of your inventory at different locations.

    To run these reports, choose Reports > Inventory and one of the following:

    • Quantity on Hand by Site

    • Inventory Valuation Summary by Site

    • Inventory Stock Status by Site

    • Items by Bin Location (only if you track bin locations)

  • Set site-specific reorder points so you know when to reorder inventory at each site (warehouse)

  • Assign items you purchase to a specific location

    After you turn on Multiple Inventory Locations, QuickBooks:

    • Adds inventory sites to the list of Ship To addresses on purchase orders. If you track bin locations, QuickBooks also adds a Location column to the purchase order. You can create purchase orders for only 1 site at a time.

    • Adds a Site column to the Items tab on bills, checks, and credit card charges. If you track bin locations, QuickBooks also adds a Location column to the form. You can purchase items for multiple locations on these forms.

  • Sell items from a specific location

    After you turn on Multiple Inventory Locations, QuickBooks:

    • Adds a Site column to sales orders, invoices, and sales receipts. If you track bin locations, QuickBooks also adds a Location column. You can sell items from multiple locations on 1 sales form.

    • Adds a Site field to statement charges. If you track bin locations, you must enter the bin location in the Site field.

  • Transfer items between sites

  • Build assemblies using parts from different locations

    After you turn on Multiple Inventory Locations, QuickBooks:

    • Adds inventory site information to each assembly. Use this window to specify Quantity on Hand (QOH) and build points for each site.

    • Adds Finished Assembly Inventory and Assembly Location fields to the Build Assembly window. Use these fields to specify the site and bin location (if you track bin locations) where you store the finished assembly.

    • Adds a Site column to the components needed to build the assembly. If you track bin locations, QuickBooks also adds a Location column to the form. You can use components from different sites to build assemblies.

  • Run site-specific reports

    To access site-specific reports:

    • Choose Reports > Inventory and one of the following:

      • Quantity on Hand by Site

      • Inventory Valuation Summary by Site

      • Inventory Stock Status by Site

      • Pending Builds by Site

      • Items by Bin Location

    • Choose Reports > Sales > Inventory Sales by Site

    • Choose Reports > List > Inventory Site Listing

Start using Multiple Inventory Locations

Turn on Multiple Inventory Locations

  1. Choose Edit > Preferences.

  2. On the left of the Preferences window, choose Items & Inventory.

  3. Click the Company Preferences tab.

    Make sure the Inventory and purchase orders are active checkbox is selected.

  4. Click the Advanced Inventory Settings button.

  5. Select the Multiple Inventory Sites is enabled checkbox.

  6. To track bin locations, select Track Locations within Inventory Sites (row, shelf, or bin).

    Note: If you want to track bin locations only, you still have to set up 1 site.

Complete 4 setup steps

These steps automatically appear when you turn on Multiple Inventory Locations, so you don't need to remember or print them now.

  1. Create inventory locations.

  2. (Optional) Convert from your previous method of tracking multiple inventory sites (warehouses).

  3. Set reorder points for each site (warehouse).

  4. Transfer opening quantities of items to each location.

After you turn on Multiple Inventory Locations, tracking multiple locations becomes part of your everyday transactions in QuickBooks. Sales and purchase forms display a site column (and a location column if you track bin locations) that you must use when you buy or sell inventory. Also, it's easy to transfer inventory between locations.

Common Questions:

  • Does QuickBooks calculate a separate average cost for each location?

    No. QuickBooks keeps track of the average cost across all locations.

  • Can you adjust inventory at each location?

    You can adjust inventory quantities at each location. However, you can't adjust inventory value for each site (warehouse). QuickBooks maintains the average cost across all your sites (warehouses). After you turn on Multiple Inventory Locations, QuickBooks displays an inventory site (and location, if necessary) in the Adjust Quantity/Value on Hand window.

  • Can you track overhead and other expenses by site (warehouse)?

    No. Multiple Inventory Locations doesn't replace class tracking. If you use classes to track locations, you should continue using classes for all noninventory-related transactions.

  • What site (warehouse) should you use for drop shipments?

    If you sell inventory that is shipped directly from your vendor, use the Drop Ship site. QuickBooks creates this site automatically.

  • How does QuickBooks handle drop shipments?

    On purchase transactions:

    When you enter a Purchase Order and select a customer as the ship to address, QuickBooks automatically assigns the Drop Ship inventory site behind the scenes.

    When you receive the bill against the PO, QuickBooks automatically assigns the Drop Ship site. If you don't create a PO first, you must assign the Drop Ship site on the purchase transaction.

    On sales transactions (sales orders, invoices, and so on), make sure to enter Drop Ship in the site column when you sell items that are drop shipped.

See also

KB ID# H_MULTI_INVENTORYSITE_OVERVIEW
12/18/2014 2:28:56 AM
PPRDQSSWS406 9102 Pro 2013 f4e2bf