Financial Statement Setup

You can define your own financial statements that best suit your reporting needs. To specify the content and format of a statement, use the Financial Statement Definition form, along with the Financial Statement Definition Columns form and the Financial Statement Line Definition form.

Note: You can now use Microsoft Excel to retrieve and format CloudSuite Business GL data. You can create a fully interactive and data-bound workbook to produce various reports such as Balance Sheet, Profit/Loss Statement, chart, and dashboard or pivot table without requiring any development knowledge or knowing the complexity of data access. For information on how to install and use this addition to Microsoft Excel, see the Infor CloudSuite Business Microsoft Office Integration Guide.

Financial statements consists of two major sections:

  • Report Columns
  • Report Totals

To design the statements, you use four major functions:

  • Copying sections of reports
  • Resequencing lines
  • Automatically generating accounts
  • Automatically setting ratio and subtotal levels

You must enter information for the report, such as:

  • Headers and titles
  • The columns in which to calculate and/or print amounts
  • The account numbers for which amounts will be printed
  • Descriptive text

You also must decide:

  • Whether to print ratios, and if so, where
  • When to print totals

It is best to lay out the reports on paper before attempting to define them. Remember to leave enough room to print all the desired amount and ratio columns, because the system does not perform this task automatically.

To create the financial statement:

  1. Find one of the demo reports (.RDL) provided with CloudSuite Business that is most like your current financial statement.
  2. Make a copy of the .RDL with a new name.
  3. In Visual Studio 2008, modify the new report as needed.
    Note: The financial statement templates included with CloudSuite Business include several suppressed fields and objects. Ensure that the data you wish to display is unsuppressed. For more information about suppression, see the Visual Studio 2008 online Help.
  4. In CloudSuite Business, add a Background Task Definition to point to this new .RDL.
  5. Open theFinancial Statement Definition form.
  6. Specify information in these required fields:
    • Report ID: Enter a unique name for your report. This value can be up to 10 characters.
    • Analytical: Select this field if this report should be pulled from a separate analytical ledger.
    • Task Name: Fill in the task name of the background task you defined in Step 4, above.
  7. Click the Columns button.
  8. Complete the header definition on the Financial Statement Definition Columns form.
  9. After you have defined the header and columns, save and return to the Financial Statement Definition form.
  10. To open the Financial Statement Line Definition form, click Lines.
  11. Define the statement lines.
  12. After you have defined a statement, you can print it by specifying the Report ID in the Financial Statement Output form.
Related topics