Defining an account row (Style 1 reports)

You can define a row that includes only account information. This can include individual accounts and subaccounts, account and subaccount ranges, account and subaccount groups, and account lists. You can use this type of row only for a Style 1 report.

Procedure flow: defining an account row (Style 1)

Follow these steps to define an account row:

Note: As an option, click Accounts on the Style 1 tab on RW00 to access Account Rows (RW10.2).
  1. Access Rows (RW10.1).
  2. Click Accounts Type to open Account Rows (RW10.2).
  3. Click New Row to open the Define Accounts Row (RW11.1). Use this form to define a new account row name, specify a description of the row, and assign a folder.
    Note: If you are defining a new row that is similar to an existing one, then click Copy to copy the existing row and make changes. You cannot copy one row style to a different row style (i.e., Style1 to Style 2).

    See Defining a report.

  4. When you add the new row, you return to Account Rows (RW10.2). Use this form to complete the row definition. Use these guidelines to specify the field values:
    Description

    Specify a description for each row line. The type and detail fields determine if and how the description line displays in the report. For example, an underline row type repeats the character that you type here to create an underline in the row line.

    Type

    Select how the row line is used. You can select:

    Dtl (Detail)

    If you selected Detail in the Type field, then select the amount of detail to include in the row line in the Dtl field. These are the valid options:

    Tot (Total)

    If you selected Total in the Type field, then select a total level for each total line to indicate how the row line should be totaled. Total levels range from one through nine and are used to indicate what data that you want to include in a total. If the total level used is greater than the previous total level, then the previous total is included. If the total level is less than or equal to the previous total, then the previous total is not included.

    Accounts and Subaccounts

    Select a range of accounts, and optionally subaccounts, to include in the row line.

    If the range of accounts you want to include in the row line are not sequential, then leave these fields blank and use the Additional Information (RW10.6) subform to select accounts as described in the following two steps.

  5. Click More to open Additional Information (RW10.5). Use this subform to define additional row line information.
    Note: If you selected accounts on RW10.2, they display in the Major Account fields on RW10.5.
  6. If you did not select a range of accounts for the row line on RW10.2, then use More to select valid accounts for the row. You can use these options for selecting accounts:

    • A specific summary account within a chart

    • A range of accounts or subaccounts

    • An account group

    • A subaccount group

  7. You can define additional options for the row line on the Options tab.
    Space After

    This field determines the number of spaces after each row line. Consider these options:

    • Entering 1 leaves no space after the row line.

    • Entering 2 leaves one blank space after the row line.

    • Entering 3 leaves two blank spaces after the row line.

    • Entering 9 inserts a page break after the row line.

      If you leave this field blank, then the default is no space after the row line.

    Sign Reversal

    Specify Y (Yes) if you want the application to print a negative sign next to a positive amount. Use this option if you do not want revenue and liability balances to print with a negative sign. Reversing the sign only affects report printing, not account totaling. If you leave this field blank, then No is set as default and the system prints a negative sign for a negative amount.

    Print Line

    This field determines if account and organizational level row information prints on the report. If you select No, then only the row line totals print. If you leave this field blank, then Yes is set as default and the line of information prints. See About suppressing a row line from printing on a report.

    Note: You can select Unconditional Underline/Sep only for an underline or separator row line that specifies the row line is printed unconditionally. For example, an underline does not print if no detail has been printed since the last underline. Use this feature to print the line unconditionally.
    Affect Total

    This field lets you add the row line to the total, subtract the row line from the total, or define the row line as having no effect on the total. See Excluding a line from a total.

    Dr/Cr Balance

    This field lets you include the net balance, only the debit balance, or only the credit balance on the row line. The default setting is Net Balance.

    For example, if you are using a sales account and only want to view the debit balance, then select Debit Only.

    Format Override

    This field lets you use a different format for use in the row line. Select a format assigned in the Formats tab on Report Writer (RW00.1). See Assigning multiple formats.

    Two Line Heading

    This field lets you print only the last two lines of the header in a format file before each detail line. This can be used along with a format override. See Assigning multiple formats.

    Detail Group

    You can specify a number to group row lines into a detail group. For example, if you specify 1 in this field for row lines 10 through 50, they become detail group 1. See Detail group and Defining a detail group.

Related topics