About Consolidating Account Ranges
You can perform two extremely useful operations on a group of accounts. You can:
- Consolidate all the lines of an account range instead of printing out the details.
- Print subtotals for groups of accounts according to changes in particular account segments.
Grouped, Separate, or Summarized Data
You can generate separate lines for each account in an account range, consolidating the account reference in a single line, consolidating account data by account group, or you can consolidate the account data by account segment code.
You specify this choice in column D of a report specification. In addition, you can use the column D setting to override the account order processing on a line-by-line basis.
| Value | Description |
|---|---|
| D | For a detail. Prints one line for each account number. |
| RD | For a rollup account detail. Prints all the top-level rollup details, as well as accounts not in rollup groups. |
| T | For a total. Consolidates the data. |
| D(ACCT) | Consolidates by the account segment code, setting the account number sorting order to account segment order for this single account reference. |
| D(ACCTGROUP) | Consolidates by the account group. |
| D(ACSEGVALn) | Consolidates by account segment number n. |
| D(AcctSegID) | Consolidates by the named account segment—for example, D(REGION). |
| PD | Consolidates by transaction details in posted transaction order. |
| PT | Consolidates by transaction consolidated total. |
| P(POSTTRAN) | Consolidates by transaction consolidated by account. |
| P(POSTDATE) | Consolidates by transaction consolidated by journal date. |
| P(POSTSEQ) | Consolidates by transaction consolidated by posting sequence. |
In each case where consolidation is performed on the basis of a property of the account number, Financial Reporter processes the account number in the order required for consolidation. For example, if consolidation is by account group, the account numbers are processed in account group order.
Transactions can also be listed by consolidated account segments and account groups when listing by accounts. If you are consolidating by a specific account order in a list of transactions, the value in Column D must begin with a “P”. For example:
- P(ACSEGVAL02) returns transaction records consolidated by account segment 2.
- D(ACSEGVAL02) returns account history records consolidated by account segment 2.
FR requires a correct sorting order in Column D in order to list details by transaction through field consolidation, as follows:
| Exclusive Sorting Order | Meaning |
|---|---|
| POSTTRAN | By posted transaction in account order |
| POSTDATE | By date order |
| POSTSEQ | By posting sequence order |
| POSTACCT | By account posting sequence |
- The sorting order must be POSTTRAN if the consolidation value in column D is by P(POSTTRAN).
- The sorting order must be POSTDATE if the consolidation value in column D is by P(POSTDATE).
- The sorting order must be POSTSEQ if the consolidation value in column D is by P(POSTSEQ).
- Anything that appears in column D on a default specification line will be used by all subsequent lines unless you specifically override it.
Examples of "T" and "D" Consolidation Settings
The following examples show the effect of T and D settings in column D of a report specification.
Displaying Account Balances on Separate Lines
Specifying D in column D lists each of the accounts between 1100 and 1200 on separate lines.
|
Current Balance |
|
|---|---|
|
Petty cash |
274.57 |
|
Bank account |
8,437.54 |
|
Bank account, CAD dollars |
4,372.96 |
|
Total: |
13,085.07 |
Displaying Account Totals on a Single Line
Specifying T in column D indicates that all accounts in the range are consolidated.
The resulting report totals the balances of all the accounts between 1100 and 1200, and reports the total on a single line.
|
Current Balance |
|
|---|---|
|
Liquid assets |
13,085.07 |
Displaying Accounts in Segment Order, Consolidated by Segment
Specifying D(ACCT) in column D indicates that all accounts in the range are to be listed in account segment order and consolidated by the account segment.
|
Current Balance |
|
|---|---|
|
Petty cash |
274.57 |
|
Bank account |
12,810.50 |
|
Total: |
13,085.07 |
Two lines are printed in the above example, because there are two account numbers with an account segment code between 1100 and 1200.
The first account segment code (1100) is for petty cash, and the second account segment code (1200) is for Bank Accounts. Two separate account numbers have an account segment code of 1200, but these two accounts (shown in the previous example) have been consolidated.
D(ACCT) summarizes by account segment code all other segments that happen to be within the ranges specified when printing the report.
For subsequent rows, the order will revert to the order that was in effect prior to this specification row.
Related Topics