cancel
Showing results for 
Search instead for 
Did you mean: 
durgiles
Level 1

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

What is the link I have the same problem tsk

Fiat Lux - ASIA
Level 15

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

@durgiles 

There are many inventory management app in the market. You may start from these options to explore:

http://www.primaseller.com/?utm_source=Affiliate&fp_ref=primaseller

https://go.tradegecko.com/register?code=fiat-lux

 

Hope it helps.

SweetBlend Consulting08030963897
Level 1

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

It is possible to track inventory in a multi warehousing environment on QBKS:

i. Click on the gear sign at the top right-hand side of your screen

ii Click on Account settings.

iii. Advanced

iv. on Categories, Turn on track classes and Location by clicking on the pencil sign.

V. Go to bill, you will see the location, Add the various warehouses as the locations where your inventories are domiciled.

Then when you receive stock in your system, you link it to the loacation which it relates.

vpcontroller
Level 11

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

@SweetBlend Consulting08030963897 

 

No, IT'S NOT POSSIBLE to track inventory for multiple warehouses that carry the same things using QBO.

Your steps are just to enable locations feature (mainly for recording income and expenses) but that has nothing to with inventory tracking for multiple warehouses. 

I suggest you TRY IT first.

SweetBlend Consulting08030963897
Level 1

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

@vpcontroller  I actually have been able to set up and run my inventory report as per warehouse for a multi warehouse environment using the Location settings. 

It is possible using the Location work around.

vpcontroller
Level 11

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

@SweetBlend Consulting08030963897 

 

Can you share with us the name of inventory report, you're able to run for multiple warehouses in QBO?

In QBO, they currently have mainly two inventory reports:

1) Inventory Valuation Detail

2) Inventory Valuation Summary

And they also have Physical Inventory Worksheet. 

 

You can run the Transaction Report for Inventory Asset account and group it by Location but that's not really an inventory report, it would not give inventory valuation (qty on hand and dollar amount) report. 

 

 

SweetBlend Consulting08030963897
Level 1

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

Go to  setting> All List> Location.

You will see all the warehouses you created. 

select the particular warehouse you wish to run report on.

When the report displays, click on the gear sign on the top right hand side of the report and select the fields you want displayed on the report.

Please note that this is just a work around. I used it to solve my needs. Yours may be quite different though.

vpcontroller
Level 11

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

Once again, tracking of inventory for multiple warehouses that carry the same things is still not available in QBO.  QBO inventory module is not designed for tracking multiple warehouses at this time. They still have two main standard inventory reports which will not track inventory by location.

 

QBO users always come up with a workaround for their own purpose to stay with QuickBooks. But that's no way a permanent solution. And the reports, in the long run, would not be accurate either.

 

Note: The best workable solution I experienced so far is to use the Product category as location. But you will still need to create inventory item by category for the same item for multiple locations. But I don't recommend this either.

 

 

product item category as location.PNG

 

 

 

Regina_Lend_A_Hand_Accounting
Level 9

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

I agree with @vpcontroller and feel that an earlier notation suggesting a third-party app solution with QuickBooks Online is the best option at this time. While there are many "workarounds" that will help with "tagging" your inventory in QBO, there is limited reporting and there are better inventory applications that can be utilized in this situation.

NorthStar10
Level 1

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

Why don't you recommend using Categories?   What are the cons?

GlinetteC
Moderator

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

Thanks for joining this thread, NorthStar10.

 

Let me share an additional idea of why we don't recommend using categories when tracking inventory for multiple warehouses in QuickBooks Online. Here are some reasons as mentioned by the previous replies.

  • Unable to run a Valuation report by Category
  • Unable to run a report by Item that includes Category
  • You're unable to know how much of an item or total you have in all locations

In the meantime, you may consider looking for a third-party app to track your inventory for multiple locations. 

 

I can see how this feature would be helpful for you and your business. Rest assured that I'll pass along your feedback to our product developers. They're always looking for ideas from users on how to improve QuickBooks Online (QBO). They might consider adding this in their future product enhancements.

 

If you have any other questions, please let me know by adding a comment below. I'll be around to help.

Watersaver
Level 1

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

Hi -

Any updates to QBO Advances since last year as it relates to being able to print an inventory report by warehouse location?  Last year's posts suggested using Categories, but wanted to see if there are any better options now.  Thanks!

ReyJohn_D
Moderator

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

This looks like a good addition to the program, @Watersaver.

 

While printing an inventory report for multiple locations isn't available in QuickBooks Online, I recommend looking for a third-party app. This way, you can integrate it QuickBooks and begin tracking your inventories for various warehouses. Let me guide you how:

 

  1. Go to this website: apps.intuit.com.
  2. You can also go to the Apps menu at the left pane, and then search the desired apps. You can use the Browse category drop-down ▼  to narrow down your search.

    d262.PNG
  3. One of our Community backers, @Fiat Lux - ASIA may be able to suggest the best app to use in this case.

Also, I encourage visiting our QuickBooks Blog page to keep up with the latest news and product enhancements. All details are laid down there so you can check it from time to time.

 

Meanwhile, you can use some inventory-related reports to check the inventory status and performance. This way, you'll know the best sellers and you can reorder anything that’s running low or out of stock. For more details, please check out this article: Use reports to see sales and inventory status.

 

I'm here to lend a hand if you have more questions about managing your inventories in QuickBooks Online. Take care and have a great day, @Watersaver.

Fiat Lux - ASIA
Level 15

Best way to keep track of inventory for multiple warehouses that carry the same things. Using QBO. I don't think it's possible.

@Watersaver 

Company has acquired an inventory management app as their family member recently. You may find the Sales Order and Multi warehouse features in it to integrate with your QBO account.

https:// go.tradegecko.com/register?code=fiat-lux

 

Need to get in touch?

Contact us