Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We have two inventory sites. Both sites have items that need to be reordered. There is a surplus of some of those items at the other site. What is the easiest way to identify which items they are and how many to transfer?
The stock status by site report identifies which items need to be reordered and their quantities. It does not have a surplus column. I can easily export both site reports to excel and create a surplus column. Unfortunately the items listed in one site report differ from the other. It's very difficult to match up the reorder qty and surplus qty of each item across both sites.
Solved! Go to Solution.
Here are the directions for how to create a list of overstocked items that can be transferred to a site that needs them:
I have a report that you can pull, which shows the quantity on hand available per site, @PoolHero1.
To start with, when it comes to the Stock Status by Site report that you've pulled up, make sure that the date range is correct. Know that any future dated transactions may affect the quantity of the items on hand. This can be the reason why the report may differ from the other.
Moreover, I'd recommend pulling up the Inventory Valuation Summary by Site so you can see the quantities of the items available per site. This way, you can export it to Excel then compare and match the surplus.
To do that:
From there, you can gather the data indicating the surplus of the items per site. You can manually create a report for them.
I'm also including this reference to help you in managing your stock valuation in the system, in case you need it in the future: Balance Sheet and Inventory/Stock Valuation reports.
Please keep me posted on how this work for you, @ PoolHero1. I'll make sure you're all set.
Thanks @BettyJaneB
I am unable to tell what the surplus is or what needs to be ordered on that report. It doesn't display the reorder points or max.
You're welcome, @PoolHero1.
Yes, you're right. The Inventory Valuation Summary by Site report won't show the reorder points or surplus of your items. You're on the right track in exporting the Inventory Stock Status by Site report to Excel instead. From there, you can add the surplus column manually.
I'd agree that having the said filter or option will make your inventory comparison easy. For now, you can follow Step 5 from my peer's answer above to export the Inventory Stock Status report to Excel. This time, ensure to select the said report and choose the correct date filter to get accurate data.
By the way, I've got another idea on how to make sure you'll know or gets notified when to reorder your inventories. You can perform some tweaks on the Preferences page to achieve this.
Here's how:
After turning on this setting, QuickBooks will remind you when to reorder your items moving forward.
Also, you can personalize the said reports to get other details that you need. Then, you can memorize them to save a copy for later use.
Lastly, I'd recommend checking out our Firm of the Future site to get you in the loop about the latest happenings and product enhancements.
Keep me posted if you have additional inventory-related concerns. I'll keep an eye on your reply. Take care!
Thank you @ReyJohn_D
I choose all for the date range when I create the inventory stock status by site. The items on the report change when I change sites. In some cases, the item name will be the same but the descriptions will be different from one report to another. I think the report is pulling the items and their descriptions to populate from previous sales instead of from the item list.
Since the replies have stopped, I'll assume there isn't a solution to this issue.
Good day to you, @PoolHero1
Allow me to chime in and add some clarification.
Yes, you got it right, since you’ve chosen All dates as the date range of the report, it’ll include all the previous sales. Also, it could be that your item before has a different description. Thus, it’s the reason it shows different information.
If you don’t want to include the previous sale, I recommend selecting an appropriate date. This way, it’ll only show your current sales and the data you need.
To be guided on how to generate reports to accurately show the information you need, you can check out this link for reference: Customize reports in QuickBooks Desktop.
In case you have any other concerns or follow-up questions about running your reports in QuickBooks, you’re always welcome to share them with me. I’ll be more than happy to assist you. Have a great day!
Thanks @JasroV
I am unable to customize the report in QB in such a way that I can get the on hand, reorder, and max quantities for both sites to display at the same time. When I run the report separately, some items are not included on both report making it very difficult to match up the surplus from one site with the reorder from the other.
Hi there, @PoolHero1.
I appreciate you for getting back to us here in the Community. I'm here to help you customize the report in QuickBooks Desktop.
Before you start the customization, please review your items and ensure you enter the on hand, reorder, and max quantities for each site. This way, we can ensure the information will display for both sites in the report.
Here's how:
Once done, please proceed with running the Inventory Stock Status by Site report. Please follow these steps:
Additionally, I recommend visiting the following article to export reports to Excel: Export reports as Excel workbooks in QuickBooks Desktop.
Feel free to hit that Reply button if you have additional questions about the report. Have a great day ahead.
Good Morning @AlcaeusF
Do you know how to compare the reorder and max quantities for both sites and all the items at the same time? We want the those quantities to be the same for each site. It would be very time consuming to view and then edit each individual item on the item list.
I did however check one of the items that is showing up on the report for one site but not the other. That item has a zero reorder and max quantity for both sites.
After running the report for multiple sites as you've described, some items are listed in one site but not the other. Without the lists being identical, I'm unable to export the two sites and combine the lists to calculate the transfer quantities.
Hey there, @PoolHero1.
Thanks for following up with us.
At this time, the best report option would be to follow the steps provided by my colleague above. However, there are some third-party apps you could look into that will offer a wider variety of report management. I've included the link to our supported third-party apps below.
On the other hand, I can see how having a better report for your concerns would be beneficial for you and your business. I've submitted a feedback request to our product development team, so this could be considered in a future update.
Please let me know if you have additional questions or concerns. I'll be here every step of the way. You can reach out to the Community or me at any time. Take care and have a Merry Christmas!
Is anyone else transferring extra inventory from one site to another? If so, how are you getting a list together of what to transfer?
Hello @PoolHero1. Happy New Year!
While we cannot recommend a specific 3rd Party App, the link that @Tori B provided for the list of 3rd Party Apps will help you choose one that best fits your needs!
If you have any other inquiries please feel free to reach back out to us here in the Community.
Other Community users are encouraged to share their solutions and suggestions for a 3rd party app that has helped them accomplish transferring data and/or ways to put together a list of what to transfer!
It seems as though there isn't a solution for this issue within QB or the third party apps although I haven't checked them all. I'm going to look for a solution within excel.
Here are the directions for how to create a list of overstocked items that can be transferred to a site that needs them:
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here