In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • Report Lines
    In the Report Lines worksheet, you define the different reporting lines you want to use in the KPIs such as inventory or total assets. For each of these reporting lines, indicate the type as calc or data:
    Calc. The value of the reporting line is calculated based on other reporting lines.
    Data. The value of the reporting line is based on retrieved data such as a range of GL accounts or a range of GL accounts in combination with sub-accounts and cost centers.
    The following parameters are available:
    Indent Level Parameter. Builds a hierarchy.
    Visible Parameter. Uses reporting lines for calculation only but does not show them in the dashboard.
    Change Sign Parameter. Displays all positive values.

    CFO Report Lines Worksheet
    Here is the full list of report lines used in the standard setup:
     
    Line Number
    Line Type
    Line Text
    10
    calc
    NOPAT
    20
    data
    Interest Paid
    30
    calc
    Total Assets
    40
    calc
    Working Capital
    41
    calc
    Current Assets
    42
    calc
    Current Liabilities
    45
    data
    Fixed Assets
    60
    data
    Other Current Assets
    70
    data
    Inventory
    75
    data
    Cash and Banks
    80
    data
    Investments
    90
    data
    COGS
    100
    data
    AR
    101
    data
    Provision Bad Debt
    110
    data
    Net Sales
    120
    data
    AP
    130
    calc
    EBIT
    140
    calc
    Total Liabilities
    142
    data
    LT Liabilities
    145
    data
    Other Current Liabilities
    170
    data
    Total Equity
    180
    calc
    Other OPEX
    181
    data
    Other Operating expenses
    185
    data
    Bad Debt expense
    188
    data
    ICT expense
    190
    data
    Taxes
    200
    calc
    Net Income
    210
    calc
    Purchases