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

  • EE CFO Dashboard
    To access the EE CFO dashboard, select Dashboard|QAD Standard|Financials|EE CFO Dashboard.

    Operations Dashboards
    This dashboard contains the following KPIs:
    Income Statement. See Income Statement.
    Balance Sheet. See Balance Sheet.
    Metric Summary. See Metric Summary.
    Days Sales Outstanding. See Days Sales Outstanding.
    Return on Capital Employed. See Return on Capital Employed.
    Quick Ratio. See Quick Ratio.
    Working Capital Turnover. See Working Capital Turnover.
    ICT Expense. See ICT Expense.
    Current Ratio. See Current Ratio.
    Return on Working Capital. See Return on Working Capital.
    Inventory Turns. See Inventory Turns.
    Days Payable Outstanding. See Days Payable Outstanding.
    Return on Investment. See Return on Investment.

    EE CFO Dashboard
    The parameter bar on the dashboard contains the following selections:
    Curr Fin Month. To indicate the month that you want to see the data for, select Current, Last Year, Previous, or Next. Select Current to see the data for the current month. Select Last Year to see the data for last year’s corresponding month. Select Previous to see the data from the previous month and Next to see the data from the next month.
    Entity. Select the entity you want to see data for. Choose % to view the data for all entities combined.
    Currency Type. To indicate the currency type, select Base Currency or Corporate Currency. Base Currency is the currency of the selected entity as set up in the ERP system. Corporate Currency is the common reporting currency for all entities in the BI data warehouse. It is defined during the setup of the BI data warehouse.
    Note: Corporate currency amounts are calculated based on the base currency of each entity. If the current month is chosen, the system uses the accounting exchange rate that is valid at the period end or on the current date.
    The calculation algorithm is as follows:
    If the CC (corporate currency) equals the BC (base currency), then the BC value is taken as the CC value.
    If the CC is not equal to the BC and the CC is equal to the TC (transaction currency), then the TC value is taken as the CC value.
    If the CC is not equal to the BC and the CC is not equal to the TC, then the CC value is calculated by multiplying the BC amount by the CC/BC accounting exchange rate. If the CC/BC rate is not found, then the system searches for the BC/CC accounting exchange rate. The accounting exchange rate is a mandatory rate in the ERP system and hence is always available.