PROMATIS Best Practice Solutions: Reports for Accounting

Reports available for Oracle E-Business Suite Rel. 11i, 12, and Oracle ERP Cloud

  • Balance Sheet Statement
    This reports creates an output based on General Ledger information (Trial Balance). This report was created with BI Publisher and supports various output formats such as PDF, HTML and MS Excel. Supported methods are:
    – Total Cost Accounting
    – Cost of Sales Accounting
  • Profit and Loss Statement (P&L)
    This reports creates an output based on General Ledger information (Trial Balance). This report was created with BI Publisher and supports various output formats such as PDF, HTML and MS Excel. Supported methods are:
    – Total Cost Accounting
    – Cost of Sales Accounting
  • Financial Closing Overview Statement
    This reports creates an output based on General Ledger information (Trial Balance). This report was created with BI Publisher and supports various output formats such as PDF, HTML and MS Excel. Supported methods are:
    – Balance Sheet Statement
    – Profit & Loss Statement (Total Cost Accounting)
  • Trial Balance Template
    The Trial Balance Template complements the Oracle Standard Report (GLTRBAL1) with a BI Publisher layout so that various output formats such as PDF, HTML and MS Excel are supported.
  • Journal Report
    The Journal Report shows journals from General Ledger with lots of information coming from the relevant sub-ledgers (e.g. customer number, invoice number, invoice date for Accounts Receivables transactions). This report was created with the BI Publisher and supports various output formats such as PDF, HTML and MS Excel.
  • VAT Statement
    This reports creates an output based on General Ledger information (Trial Balance). This report was created with Financial Statement Generator (FSG) and supports various output formats such as PDF, HTML and MS Excel.  Assumption: Per tax code, a separate revenue account is required inside Oracle E-Business Suite.
  • Fixed Assets Summary Report
    This report provides a gross fixed assets summary layout in accordance with German law including the consideration (reported separately) of capital in progress (CIP) assets.
  • Preliminary Dunning Letter / Final Dunning Letter
    The Preliminary Dunning Letter and Final Dunning Letter show in perfect harmony the overdue transactions (invoices, credit memos). All types of customer payments (on account and unapplied) can be taken into consideration – also with their dunning levels. An appropriate BI Publisher template is included.
  • Aging 7 Buckets by Account Template
    The Aging 7 Buckets by Account Template complements the Oracle Standard Report (ARXAGSW) with a BI Publisher layout so that output formats such as PDF, HTML and MS Excel are supported.