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 Accounts Payable Dashboard
    To access the EE Accounts Payable dashboard, select Dashboard|QAD Standard|Financials|EE Accounts Payable.

    Financial Dashboards
    This dashboard contains the following KPIs and reports:
    Days Payable Outstanding. See Days Payable Outstanding for the Last 12 Months.
    Top 25 Outstanding Suppliers. See Top 25 Outstanding Suppliers.
    Trend Open Balance by Fin Month. See Trend Open Balance by Fin Month.
    Detailed Open Invoice by Supplier at Effect Fin Month report. See Detailed Open Invoices by Supplier at Effect Fin Month Report.
    Open Invoices by Supplier report. See Open Invoice by Supplier Report.

    EE Accounts Payable 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 Enterprise Edition. 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.