Reports for inventory

Currently, we don't have a specific report to track products missing from sales orders,angel511.  However, we can run the Open Sales Orders by Item and Inventory Stock Status by Item reports as these can help manage your inventory more effectively. Let's go through these reports below.

You can pull up these two reports to show what products are missing for your sales order before building assemblies in QuickBooks. Here's a step-by-step guide to help you with that.

To pull up the Open Sales Orders by Item:

1. Go to the Reports menu.
2. Select Sales and choose Open Sales Orders by Item.
3. Once the report is opened, click the Customize Report button to modify the report based on the data you need.

To pull the Inventory Stock Status by Item report:

1. Go back to the Reports menu and select Inventory.
2. From there, choose Inventory Stock Status by Item. This report shows the quantities on hand, sales orders, and purchase orders.
3. Click the Customize button to modify based on the data you need.

Then, you can export the reports to Excel to modify your data further. For more details about exporting and customizing reports in QuickBooks, see these links:

• Customize reports in QuickBooks Desktop.
• Export reports as Excel workbooks in QuickBooks Desktop

I've also added a couple of articles that you may find helpful when building assembly in the future:

• Track the Products you Manufacture
• Understand Inventory Assets and Cost of Goods Sold Tracking

If you're looking for guidance on generating inventory reports or have any questions related to QuickBooks, please don't hesitate to post here again. I'm here to provide assistance. Have a good one.