Creating a report definition

  1. Open the Financial Report Writer form.
  2. Click Create.
  3. On the Report Information tab, specify this information:
    Report ID
    Specify a unique report ID to identify the report.
    Description
    Provide a description about the report. This description is not printed on the report.
    Orientation
    Select Portrait or Landscape. The default value is Landscape.

    This field is disabled if the Output Format is Excel.

    Paper Size
    Select the report paper size.

    This field is disabled if the Output Format is Excel.

    Display Site
    Select this check box to display the appropriate site for the amounts on the report.

    If you clear this check box, the Site value is blank on the reports. Otherwise, the reports display the Site Group ID.

    If the Site Group ID is not set, the reports display the site ID of the direct report to the current entity, if Direct, or the source site, if Site.

    Analytical

    Select this check box to generate the report from the Analytical Ledger.

    Clear this check box to generate the report from the General Ledger.

    Separate Debits and Credits

    Select this check box to print two columns for each defined column. One column is for the debit amount and one column is for the credit amount.

    Clear this check box to print both the debit and credit amounts in the same column.

    Task Name
    Specify the name to be used for the Task Name on the Background Task Definition record for this report. The default value is the Report ID and the word “Task”.

    For example, if the Report ID is BalSheet then the value of Task Name will default to BalSheetTask.

    Output Format
    Select the report output format. The default value is Acrobat Format.
  4. In the Report Preview section, view the maximum amount of columns that can fit on the report.
  5. Click Save.
  6. Click Next.
  7. On the Columns tab, add columns for the report.

    See Adding report columns.

  8. Click Next.
  9. On the Lines tab, click Add.

    See Adding report lines.

  10. Click Next.
  11. On the Report Preview tab, check the report summary.
  12. Optionally, click Print.
    See Printing a report output.