Custom report for cash account

1

I would like to create a custom report for the cash on hand account (mainly listing all information including the date, payee, description, reference, etc).

What is the sql query for cash on hand? I have tried SELECT * FROM CashAccounts and SELECT * FROM CashOnHand. Both command is not working. Please help. Thank you very much.

2

Click on the blue balance of the account in the Cash Accounts tab. All that information is already shown. You can export the listing.

3

Try

SELECT * FROM CashTransactions
4

@Tut @lubos Thank you :heart_eyes:. Tried both ways. What a perfect program!