SQL schema for creating custom reports

Tables you can try:

  • BankTransactions
  • BankTransactionLines
  • JournalEntryLines
  • SalesInvoices
  • Customers
  • Suppliers
  • Employees

It’s better if you ask what report would you like to create. Custom reports don’t have 100% coverage yet but I keep adding more.

2 Likes