Report in QB Enterprise that shows inventory quantity sold and quantity on hand
Nice to see you here in the QuickBooks Community! You can find these reports in QuickBooks Enterprise and merge them in Excel! Here's how:
To find the Inventory Quantity Sold, go to the Reports, then scroll to Contributed Reports and select Inventory.
From there, choose the Number of Items Sold Report and select Run.
Once making customizing, such as adjusting the dates and so on, in the header, select Excel, then use the dropdown arrow and select Create New Worksheet.
Select Export once finished,
Following step one once more, and in the Contributed Reports, select Inventory, then scroll to select the Inventory Report.
Make adjustments and click Excel. This time choose the option Update Existing Worksheet and then Export.
That should do it! You will then have a report customized to your liking! If you have additional questions about customizing reports, feel free to review this article with great details. Any questions or concerns, don't hesitate to let me know. We are here to help!