Mastering Inventory Reorder Points and Transaction Forms in Multi-Location Inventory

Introduction

QuickBooks Enterprise Advanced Inventory feature Multi-Location Inventory: A Game-Changer for Inventory Management. This feature is designed to help businesses track, manage, and optimize inventory across various sites with ease. From setting up inventory locations to managing transactions efficiently, it offers a suite of advanced tools tailored to meet diverse business needs.

In our previous guides, we covered Enabling Multi-Location Inventory and setting up inventory sites and transfers. Building on that foundation, this blog will focus on:

• Setting up inventory reorder points, both globally and for specific sites.
• Customizing transaction forms to include inventory site and bin location fields.

With these advanced tips, you’ll further enhance your inventory management processes and keep your business operations running smoothly.

Set Up Inventory Reorder Points in QuickBooks Enterprise

Reorder points ensure that your inventory levels never fall below the minimum required to fulfill demand.

Steps to Set Up Reorder Points:

You can set an individual inventory item reorder point Globally and/or for specific locations. To get started let’s return to the items list.

1. Double-click on the desired inventory part.
2. You can set the item’s global reorder point within the inventory information section.
3. To enter specific reorder points by site, select the "Inventory Site Info" button corresponding to that part.
4. Here, you can define the reorder point specific to this inventory part by site.
5. Input the desired reorder points.
6. Keep in mind that the individual site reorder point does not have to total an item’s global reorder point. For example, we have a global reorder point of 10 but our site reorder points do not total 10. Likewise, you can set different individual reorder points for an item at each inventory site without affecting the total global reorder point for that item. Another thing to keep in mind is that you can set a reorder point for an individual site but you cannot set a reorder point for that site’s bin location.
7. Click "OK" to save the reorder points.

Using Sites on Transaction Forms

Once you turn on the use of Inventory Sites, you may need to modify transaction templates to include inventory site and maybe even bin location fields on transactions. Let’s take a look receiving a bill form.

Steps to Modify Transaction Forms:

1. Go to receive inventory with bill.
2. You can see that it has added the site and bin location on the form.
3. Where you may have to customize the form is within a sales order or invoice. Let’s take a look at an invoice.
4. Go to create invoices.
5. Click on Formatting.
6. Click on customize data layout.
7. Go to columns.
8. Click inventory site and bin location and whether to show on screen and print.
9. Click ok once finished.
10. Repeat this on any form that doesn’t show the fields.

By tailoring transaction forms, you ensure smooth data entry and accurate reporting.

Conclusion:

Efficient inventory management is at the heart of successful business operations. With QuickBooks Enterprise’s Multi-Location Inventory, you can:

• Set up and manage inventory locations and reorder points with precision.
• Customize transaction forms to capture critical site and bin details.

If you’re just starting with Multi-Location Inventory, refer to our earlier guides:

• Blog 1: Step-by-Step Guide to Set Up Multi-Location Inventory in QuickBooks Enterprise
• Blog 2: Setting Up Locations and Transferring Inventory in QuickBooks Enterprise

By implementing these advanced features, your business can maintain optimal inventory levels, reduce errors, and improve efficiency across all locations.