Inventory On Hand and Sales Orders

Hello there, fmkport. You can run two separate reports to modify inventories on hand and quantities available in your account. I can walk you through these processes.

In QuickBooks Online Advanced, specific reports are available to track inventory items on hand and quantities recorded from a Sales Order. You can run separate reports and export them to an Excel file, then merge these data.

Thus, to check the item quantity used in a transaction and the inventory available on hand, you can run the Inventory Valuation Detail report. Here's how:

1. In your QBO account, navigate to the Reports tab from the menu panel and enter the Inventory Valuation Detail report.
2. Hit on the Customize icon and click Change columns.
3. Make sure to tick the Qty and Qty On Hand checkboxes.
4. Verify all details, then select Run Report.

Once done, export the report to an Excel file to merge these data to the other downloaded report.

You can also run the Open Sales Order by Item report and customize the data to show the quantity used in a Sales Order. Then, export.

Additionally, you'll want to seek additional guidance from our QuickBooks Live Expert Assisted team to help you keep track of your inventory workflows.

Moreover, you'll want to save a customized report to help improve data accessibility or share it with other users.

These detailed steps help you manage your overall inventories and customer transactions, fmkport. Reach out to us in the comments below if there's anything else you need assistance with. We'll be around to assist.