Overriding Print Range Options within a Report
Financial Reporter selects which account data is to appear in a financial report by evaluating three separate account number filters:
-
The account number reference in column A of the report line.
-
The account filtering expression in column B (if there is one).
-
The print range options for the entire report.
Normally, an account has to satisfy the requirements of all three filters in order to be included in the report. However, the Financial Reporter also provides a mechanism for specifying a report range — and including accounts which lie outside that range.
Specifying a particular segment to override a segment range
You can override a segment range specified in the Print Financial Statements dialog box by including the particular segment values you want on the line in the column A account number reference.
For example, if you want to compare the performance of each department to the total sales for the organization, you can specify the total organization's sales on a line like this:
4000~4999-A, 4000~4999-B, 4000~4999-C, 4000~4999-D
Then print reports specifying a segment range of A, of B, etc.
Using the "$" prefix for account number references
The "$" prefix turns off report-level account range filtering for the particular account number reference.
If you use the "$" prefix, any account numbers that match the account reference you specify and match the selection criteria in column B will appear on the report, regardless of the restrictions imposed by the Financial Reporter print dialog box.
You can use "$" with "%%"
You can also use the "$" prefix with "%%" to include any account in the ledger allowed by the criteria in column B for the row. ("%%" is an account number reference that includes all accounts, no matter what their account structure.)
See also
Account Ordering, Processing Order, and Account Segment Ranges