Profit and Loss Row Type
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 "Profit and Loss". 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.
- 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.
- Financial Accounts: A variable with Ledger Accounts imported from the bookkeeping software
- Aggregate: A row can only have one result. Select the method how the the results of the ledger accounts should be aggregated.