Invoice Row Type

Owned by Joss Herrmann
Last updated: Oct 25, 2017 by Deborah Pender (Unlicensed)
2 min read

Input fields:

  • Display Name: see report fields
  • Name: see report fields
  • Description: see report fields
  • Type: The type of a row describes where it collects the data (see description on the right). Depending what type is selected the options to configure the type are displayed below:
    • 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)
    • Conversion Row: Collects data from Invoice Lines Table
    • Alias Normalisation Factor: (currently not in use)

Enter display name and description and, as we want to count invoices, select type "Invoice". The options are now displayed below:

Input Fields:

  • Visibility: Select if the row should be displayed on the dashboard table/chart. Select "hidden" if the result is only used for calculations.
  • Aggregate: A row can only have one result (but different columns in case of grouping). Select the method how the the results (of each column) should be aggregated.
  • Column: The database column used for calculation or a column based function (like "distinct") depending of the selected aggregate function.
  • Date Filter: The Date Range Variable (Global or Report scope) that contains the date period where the invoices are collected from. Please note that reports variables with the same name (case sensitive) are overriding global variables.
  • Filter Button: It's possible to add additional filters by comparing a column to a variable (global/report scope, only matching variable types are shown), e.g. invoice "Total Value" "greater than" "number_zero" to count only "real" invoices
  • Filter Logic: allows boolean operations on the defined filters