Begin Improving Your Finance Reporting with SQL Queries

In this lesson we’ll dive a little deeper in our application and build a Stock on Hand Report. Now, in Zoho Books, on the Item page, you can see how much stock is available. However, it will be really useful for us to see, all in one place, the available stock for every item, how much has been sold in the last 60 days, and how much is ‘committed’. This is far better than any report in Zoho Books, the app.