Understanding the Dynamic Generation of Reports
You can specify the list of the cell numbers in which you need to display a specific item in the processing options of the respective reports. You can specify the cell numbers by mentioning the sequence number of the item and the column number. The sequence number is defined in the Report Format Definition program (P75C003). The column number is sequential with the first amount column starting with A. For example, if you want to display the item Beginning Amount in the report for sequence numbers 10, 20, and 30 in column A and 5, 15, 25, in column B, you enter 5B, 10A, 15B, 20A, 25B, 30A in the processing option Beginning Amount.This enables you to run your report dynamically, choosing the cell and the value in it, as per your requirement.
You can configure a cell with any of the following options:
- Beginning amount
Enter the beginning amount of the year for a specific natural account or a combination of natural accounts.
- Period amount
Enter the net amount of the period for a specific natural account.
- Year positive
Enter the total positive amount of all transactions for a particular year and a specific account. These positive amounts are listed in the Account Ledger table (F0911).
- Year negative
Enter the total negative amount of all transactions for a particular year and a specific account. These negative amounts are listed in the Account Ledger table (F0911).
- Year to this period (including beginning balance)
Enter the closing balance of the particular period including the beginning balance of the same period.
- Year to this period (excluding beginning balance)
Enter the closing balance of the particular period excluding the beginning balance of the period.
- Period positive
Enter the total positive amount of all transactions for a particular period and a particular account. These positive amounts are listed in the Account Ledger table (F0911).
- Period negative
Enter the total negative amount of all transactions for a particular period and a particular account. These negative amounts are listed in the Account Ledger table (F0911).
- Amount with reverse sign
Enter amount that is retrieved from the respective table and is displayed after reversing the sign. That is, a positive value is displayed as negative and vice versa.