QuickBooks HelpQuickBooksHelpIntuit

Set up and use the Warehouse Manager in QuickBooks Desktop mobile

by Intuit Updated 1 year ago

Get help with setting up and using the Warehouse Manager, so you can stay on top of your inventory movement.

Warehouse Manager integrates seamlessly with QuickBooks Enterprise Advanced Inventory. It helps you efficiently receive items from purchase orders, or pick and pack items collected from a warehouse to complete sales orders.

There are several supported mobile barcode scanner devices:

  • Zebra TC20
  • Zebra TC25
  • Zebra TC51
  • Zebra MC40 (discontinued by the manufacturer but still supported)

Download and install the QuickBooks Desktop mobile app

When installed, the app can receive picklists, scan barcodes to match items in the picklists, and send updated picklists back to QuickBooks Enterprise.

Step 1. Prepare the scanner

  1. Set up an internet connection on your scanner and enable WiFi.
    Note: This is required to set up and use the mobile scanner device.
  2. Set up the scanner according to the user instructions. If needed, you can download a user manual from the Internet.
  3. Use the power cord to fully charge the device before use.
  4. Turn on the device.

Step 2. Install the Android Application Package (APK)

Download and install the APK to make the QuickBooks Desktop mobile app work on your mobile barcode scanner.

  1. Download and install the app to your mobile barcode scanner.
  2. If you see this message: "We're sorry, this file format is not supported", select Download.
  3. Select the download complete notification to start the install. If you see an "Install Blocked" message, select Settings on the message.
  4. Open QuickBooks Desktop Warehouse App.

When installed on an Android phone, the app can receive a picklist and send an updated picklist back to QuickBooks Enterprise. It can't do barcode scanning.

  1. Visit the app's page in Google Play. Sign in with the same Google account that you use for Google Play on your Android device.
  2. Select Install.
  3. Select the device you want to use. The app should download and install shortly.

Pair the device to your QuickBooks company file

Note: You should be logged in to QuickBooks. If there is a prompt to sign in, enter your login credentials.
  1. In the QuickBooks Edit menu, select Preferences.
  2. Select Items & Inventory, then go to the Company Preferences tab.
  3. Select Advanced Inventory Settings.
  4. On the Site Operations tab, select Add. QuickBooks gives you a passcode.
  5. On your mobile device, open the scanner/app, then enter the passcode.
  6. Select Link, then Yes.
  7. A success message appears indicating that the scanner is now linked to the QuickBooks company file.
  8. Select Next.

Add Warehouse users

Each sales order contains inventory items. The warehouse worker who fills that order by collecting those items in the warehouse for packing and shipping is called a Picker. If the warehouse manager (or equivalent) has a sales order that needs to be filled, they create a Picklist and assign a warehouse user.

Note: With Advanced Inventory, you can assign a picklist to a warehouse user, then send it to a mobile barcode scanner, (if you have one).

Once assigned, the warehouse user will:

  • Go around the warehouse to collect all of the items that are on the Picklist.
  • Scan the items using the mobile barcode scanner.
  • Pack the items in a box for shipping.

To add a warehouse user, you must create the warehouse user as a Vendor with the Type field set as Warehouse user.

Warehouse user can only be a Vendor.

Note: To turn on the Warehouse user option in the drop-down list, check View Balances in the user’s role settings.

Enable Warehouse User

  1. From the QuickBooks Company menu, select Users, then Set up Users and Roles.
  2. On the Role list tab, select the Role of the user, then Edit.
  3. Under Areas and Activities, select Centers and then select Vendor Center.
  4. Under Activity Access Level, check View Balance.

Add a Warehouse user

  1. Under the Vendors menu, go to Vendor Center.
  2. From the New Vendor drop-down list, select New Vendor.
  3. In the Vendor name field, enter the name of the warehouse user.
  4. Select the Additional Info tab.
  5. From the Vendor Type drop-down list, select Warehouse user and select OK.

The names of all the warehouse users added in QuickBooks will appear on the scanner.

To update or remove a warehouse user, update or remove a Vendor.

A Picklist is a list of items to be collected from the warehouse to fill a sales order.

Note: To use the new sales order fulfillment flow and a mobile barcode scanner with QuickBooks, enable the appropriate Advanced Items and Inventory preference. Get more help with customizing user roles.
  1. From the QuickBooks Customers menu, select Sales Order Fulfillment Worksheet.
  2. Select the order you want to fulfill, then Next. The Items List window includes all items with inventory details on the sales order that are required for picking.
  3. Select the details for the Picklist.

Field
Description
ITEMSSelect the items you want to be picked for this order. All of the items that can be sent for picking are selected by default, but you can clear any checkboxes you don't want to fulfill right now. The following items are NOT selected by default:
  • The item isn't in stock (FULFILL QTY is 0). The FULFILL QTY field is prefilled with Ordered or Available quantities, whichever is less. You can only select this item if the quantity is greater than 0. To override this value, enter a number in the FULFILL QTY field for the item.
  • The item is a part of another open Picklist.
  • The item doesn't have a warehouse assigned to it. Note: To select this item, assign a warehouse. In the bottom left of the window, you can see X items of Y selected. This indicates the number of items you selected out of the items in the order, which is useful if you have a large number of items.
ITEM DESCRIPTIONNon-editable. A description of the item as listed in the inventory centre.
ORDEREDNon-editable. The quantity of items that have been ordered for that item. You can use this information to determine if there are more items incoming in case the item is out of stock.
INVOICEDNon-editable. The number of items that are invoiced. You don't have to fulfill this quantity as it's already been picked.
OPENNon-editable. The number of items that still need to be fulfilled. This value is calculated by subtracting the number of items invoiced from the number of items ordered. (OPEN = ORDERED - INVOICED)
AVAILABLENon-editable. The quantity of an item that is available in stock across all warehouses. To check the quantity of the item in different warehouses, select the stock icon next to the quantity.
AMOUNTNon-editable. The sale price of the item multiplied by the open quantity
STATUSPicked status of individual items:
  • Sent for picking: The item has been sent for picking.
  • Pick in progress: The warehouse user is in the process of picking the item. The status changes from “Sent for picking” to “Pick in progress” when the first item is picked.
  • Picked: The warehouse user has picked the complete quantity of the item. (Warehouse user's task is complete and information is sent to QuickBooks.)
  • Partially picked: The warehouse user has picked some quantity of that specific item. In this case, the warehouse user can write a note stating the reason. (Warehouse user's task is complete and information is sent to QuickBooks.)
  • Not picked: When the warehouse user has started with picking but the item is not available for picking. In this case, the warehouse user can write a note stating the reason. (Warehouse user's task is complete and information is sent to QuickBooks.)
  • Completed: The Picklist has been completed and the sales order has been updated (Done by the warehouse manager in QuickBooks). Non-editable. Indicates the current pick status of the item.
TO FULFILL QTYEditable. The number of items to pick for this order. This value is pre-filled with the Open quantity or the Available quantity in the selected warehouse, whichever is less. You can change this number if needed. However, the warehouse user can only pick the quantity that's physically available in the warehouse. In this case, the order is partially picked and you have to create another Picklist later to finish filling the order.
SITEYou can see this column if you enabled multiple sites in your company preferences. Only active warehouses will be listed.
Editable. Mandatory field. The warehouse where the item will be picked from.
This field can be filled for a given item or sales order when the sales order is being created, or it can be filled before the sales order is selected in the previous screen. You must fill this in to include the item in the Picklist. The Fulfillability field will change based on the availability of the item in the selected site.
BINYou can see this column if you track bin locations (rows, shelves, or bins) in QuickBooks.
Editable. Optional. The bin name in the warehouse where this item is located. If you have a default bin location set up for purchasing and sales, this field is filled in each time you select a site. You can enter or update a bin number on this field.
The warehouse user will pick from the specified bin. If there’s no bin specified, the warehouse user knows where the items should be picked from.
FULFILLABLENon-editable. Indicates whether the item is available to fill the sales order in its entirety. This will depend on the quantity available at the selected SITE and may change if the SITE field changes.
  • Green (Yes): All items are available at the selected site

  • Red (No): No Items are available at the selected site

  • Orange (Partial): Some items are available at the selected site

  • Other (with Grey status): No site was selected. Select a site to change this status.
  1. After you select the items to be picked for the given sales order, select Next.
  2. The Picklist creation window appears. Complete the following fields:
FieldDescription
Picklist nameQuickBooks will generate a default name for your Picklist.
This is based on the sales order and ensures that each Picklist created for your company file has a unique name. You can change it if needed, but we recommend that you keep the default name unless your sales order fulfillment process requires a name in a different format. NOTE: QuickBooks doesn't flag a duplicate name.
Warehouse user's nameChoose the warehouse user from the drop-down. You must assign a warehouse user before you print or send the Picklist to a scanner. The warehouse user must be in the list. If they aren't in the list, add them to QuickBooks.
Add note for Warehouse userOptional. 70 character limit. If you have a specific message you want the warehouse user to know about the order (example: This is needed urgently, use Priority shipping), add it here. Any notes sent to or from the warehouse user are saved as part of sales order Notes.
  1. On the scanner, check that you can access the Picklist:
    1. Open the QuickBooks Warehouse app.
    2. Select your name from the list.
    3. Select the Picklist you just created.

      Note: If you can’t see the warehouse user or the Picklist, close and reopen the Sales Order Fulfillment Worksheet or scan an item from the Picklist.

  2. Select one of the following options for each Picklist:
    • Create & Send: Create the Picklist and send it to all mobile barcode scanners linked to the company file for picking. Note that the scanner must be linked and ready for use before sending the Picklist. A message will appear if the Picklist is sent successfully.
    • Create & Print: Create the Picklist and print it out. You can choose this option if you don't have a mobile barcode scanner, or if all the scanners are already in use.
  3. Follow the picking progress. Once the Picklist is created, the Create & Send button changes to a View Progress. Select View Progress to see the progress of the pick. This also opens the Picklist so you can see all the details. As the picker updates the Picklist on their scanner, you can select the Refresh icon in the top right corner to update your view and follow their progress.
  4. Complete the Picklist. You can view the Picklist and select Update Sales Order. QuickBooks saves completed Picklists for 30 days.

Having some trouble with your app? Here's how to troubleshoot the Warehouse Manager for QuickBooks Desktop mobile.

Want to know more about Pick, Pack, Express pack, Cycle count, and purchase order management sheet? See here:

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this