cancel
Showing results for 
Search instead for 
Did you mean: 
jorge1387
Level 1

How calculate inventory on hand in QuickBooks Desktop

I need calculate the inventory on hand in QuickBook Desktop from database. 

which are the tables that participate in this calculation?

2 Comments 2
Nick_M
QuickBooks Team

How calculate inventory on hand in QuickBooks Desktop

Hi there, jorge1387.

 

Thanks for dropping by the Community, the only way to track your inventory you have on hand would be to use our Advanced inventory tracking system. Which is exclusive to our QuickBooks Desktop Enterprise product. You can find the steps to set that up here.

If you don't have enterprise, but would like to check out more information on it and its features, you can check out this link

 

Thank you for your time and have a nice afternoon. 

BigRedConsulting
Community Champion

How calculate inventory on hand in QuickBooks Desktop

The inventory balances are calculated by QuickBooks based on all of the transactions the use the items.  This includes purchases and sales and also inventory adjustments. 

 

So, in effect it's the tables of transactions that has to be impacted - by recording transactions.

 

Inventory adjustments can impact Quantity on Hand, Value, or Both. Recording them may be a way to get what you want.

 

If you want to import them in batches instead of manually recording them, you can use our BRC IIF Transaction Creator Pro  to do that.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us