List financial report definitions
The profit and loss statement definition below shows some typical uses of 'Line Type' codes.
Some highlights of this definition:
Multiple RRT lines are used to calculate a 100% amount.
Database wild cards are used in the acct no/sub acct no fields to define account selection criteria for RDT, RSM, RMS, and RRT lines.
Twelve total levels are available. After a total prints, it is reset to zero. Thus, to print a cumulative income amount, one must always use a higher level number, as you proceed down the report.
Accounts can be listed in any order. Note the 38 series of accounts printed at the bottom of the report.
RSM summarizes accounts for the the Acct No/Sub Acct No qualifier, printing one line on the report, using the description entered.
Not shown in this example is the RMS line type. Multiple RMS lines aggregate to one total that is printed with the description of the last RMS line. This provides a way to aggregate a total for out of sequence account numbers.
RDT, RSM, & RMS lines do not print if all columns have a zero amount.
RSH, RSU, & RTO do not print, if inclusive RDT, RSM or RMS lines have zero amounts.
The 'Skip' lines after printing value stays in effect until a subsequent line has a non-null value.
The change 'Sign?" value stays in effect until a subsequent line has a non-null value.
The 'Maintain financial report definitions' detail dialogue contains a complete list of 'Line Type' codes.