Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Transaction reports don't have any date ore field groupings when a row collects data from the database. All data is aggregated to a single value using the aggregate function configured in the row settings.
Possible row types:
  • Invoice: Collects data from the invoices table
  • Invoice Line: Collects data from the invoice lines table
  • Profit and Loss: Collects data from the ledger accounts imported from the bookkeeping software
  • KPI: Collects data from "Manual Data Points" (time based static values) (see Settings > Manual Data Points)
  • Formula: Use existing report variables or row results to calculate a value
  • /wiki/spaces/SVA/pages/10420360: Use a predefined SQL query (see Settings > SQL Query). These SQL queries can only be defined/edited by admins (for security reasons)
  • Alias Normalisation Factor: (currently not in use)

  • No labels