Assigning Accounts
Assign accounts to a row or column to print monetary or statistical account balances. You assign accounts by entering one or more account ranges.
Typically you assign accounts to rows. However, if you enter accounts for both rows and columns, FSG only reports on intersecting accounts.
Note: If you assign accounts to a row or column, you cannot define a calculation for that same row or column. You can do one or the other, but not both.
To assign accounts to a row or column:
1. From the Rows or Columns window, choose Account Assignments.
2. Select a mathematical Sign ( + or - ) to tell FSG whether to cumulatively add or subtract the balances for each account in the specified account range. To use this feature, each segment in the range must be defined with a display type of T (Total). See step 4 below.
3. Enter a range of accounts by specifying the Low and High accounts in the range.
Additional Information: To specify just one account rather than a range, enter the same account as the Low and High.
If you leave a segment blank, FSG will process all values for that segment.
4. Enter a Display type for each account segment.
Note: You must use a display type of T (Total) for each segment if you assign:
- Multiple account ranges to a row and you want to total them. See Display Types.
5. Check the Summary checkbox if you want to report only summary balances for the accounts in the specified range.
Note: The profile option, FSG:Expand Parent Value, controls the expansion of parent values when requesting summary balances.
6. Select an Activity type (Dr, Cr or Net) to specify the types of balances to use for the accounts in each account range.
For example, enter Dr or Cr if you want to define a cash flow report or a statement of changes in financial position. For these types of reports, you may need separate rows or columns for debit and credit amounts.
7. (Optional) For each account range being assigned, enter a Set of Books from which FSG will derive account balances. If you do not enter a value, FSG will use the current set of books.
You can enter a different set of books for each account assignment if the sets of books share the same chart of accounts and calendar as your current set of books. When using different sets of books you should use Net as the Activity type.
See Also
Row Set Display Types
Row and Column Overrides
Defining Row Sets
Overview of Financial Statement Generator
Setting General Ledger Profile Options