Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
Best answer February 12, 2020
Solved
Best Answers
Hello there, @Chewbacca.
I can see and understand the situation that you've been through. You've got me here to help you pull up the report that you need so you can get past on this hurdle.
If the people who bought your business are using QuickBooks Desktop and Point of Sale at the same time, comparing their inventory reports is not ideal. A program that's earlier than the other, the values in these reports will not match.
When it comes to pulling up the inventory summary report 2 years ago, you'll just need to customize the date range of the report. Please see he screenshot attached for reference: 
On the other hand, the Inventory Valuation report in Point of Sale gives you more accurate data since this is where you manage and track your inventory. The Inventory Summary report summarizes the quantity, average cost, and extended value of each of the inventory quantities and provides a total inventory valuation. That said, the rental items will appear.
To verify why these items are not showing up, you'll need to make sure that the date range of the report that you pulled up is correct.
Once confirmed and the issue persist, I suggest contacting on Point of Sale Team. They have the tools that can help check on your transactions and determine the root cause of the problem. You can reach them through the contact details found in this link: Customer Resource Center.
I've also added here some articles that you can visit about managing the Inventory Valuation report and fixing common inventory accounting issues in POS and QBDT:
- Inventory valuation amounts in Point of Sale and QuickBooks Desktop do not match
- Common QuickBooks inventory accounting mistakes
Let me know if you have further questions. I'll make sure you're all set. Take Care!
Hello there, @Chewbacca.
I can see and understand the situation that you've been through. You've got me here to help you pull up the report that you need so you can get past on this hurdle.
If the people who bought your business are using QuickBooks Desktop and Point of Sale at the same time, comparing their inventory reports is not ideal. A program that's earlier than the other, the values in these reports will not match.
When it comes to pulling up the inventory summary report 2 years ago, you'll just need to customize the date range of the report. Please see he screenshot attached for reference:
On the other hand, the Inventory Valuation report in Point of Sale gives you more accurate data since this is where you manage and track your inventory. The Inventory Summary report summarizes the quantity, average cost, and extended value of each of the inventory quantities and provides a total inventory valuation. That said, the rental items will appear.
To verify why these items are not showing up, you'll need to make sure that the date range of the report that you pulled up is correct.
Once confirmed and the issue persist, I suggest contacting on Point of Sale Team. They have the tools that can help check on your transactions and determine the root cause of the problem. You can reach them through the contact details found in this link: Customer Resource Center.
I've also added here some articles that you can visit about managing the Inventory Valuation report and fixing common inventory accounting issues in POS and QBDT:
- Inventory valuation amounts in Point of Sale and QuickBooks Desktop do not match
- Common QuickBooks inventory accounting mistakes
Let me know if you have further questions. I'll make sure you're all set. Take Care!
Hello, @Chewbacca.
I can help with that. You can modify by filter data to make changes with the date. I'll show you how:
- Click Report menu, choose Items.
- Select Summary.
- Drop-down arrow from I Want to, then select Filter data.
- Fill out and filter the information you want to reflect on the data in the report.
Once done, you can view the summary report for the specific date.
I've also added here an article that you can read about QuickBooks Point of Sale: QuickBooks Point of Sale (POS) FAQ.
That should point you to the right path. Keep me posted if there's anything else you need. Have a good one.
Thanks for joining the thread, Alicia1.
I'll share some technique to get the inventory value for a specific date in QuickBooks Point of Sale.
The software will only allow you to run Inventory Summary report for a current date. To get the value of your inventory for a past date, you can run three separate report.
Here's how:
- Run the Inventory Summary report to get actual total of your inventory. Take note of the value.
- Generate a Purchasing Summary report to know the value of the item you received from a certain date. Go to All Reports and then select Purchasing. From the Purchasing list, choose Summary. Enter the reporting date and subtract the value to the actual amount of your inventory Summary report. Example: Inventory Summary report has a total of $40,706 and the item receive amount is $2,988. It will look like this $40,706 - $2,988 = $37,718.
- Now you can look for the item you have sold for the specific date by running the Item Summary report. Go to the All report and select Sales. From the Sales list, choose Item Summary and enter the reporting period. Get the value and add it to the current total based on the example. If the value of the Item Summary report is $1,601. You can add it to the current total $37,718 + $1,601. The result will be the actual inventory value of the date you selected.
If you're still not getting the correct amount, I recommend contacting our QuickBooks Desktop Point of Sale support using this link: Chat with us. They can do a screen sharing to further assist you in getting the exact value of your inventory.
Support is available from 6 AM to 6 PM PT, Monday through Friday.
You're welcome to post again if you need anything else. We're always available to help you.
