The process of defining lines in a report is performed via the Work with reports menu item. On the lines you define the sequence on the printout and the selection for each line (of the selected keys on the report description).
Report printout
Throughout the instructions in this routine, the report shown below will serve as the exemplified printout:
Report example
The following columns are shown on the report:
- OPENING BALANCE (THIS YEAR, ALL PREVIOUS PERIODS)
- Displays the system currency amount value for all previous periods. The period is normally selected when you print the report. For information about creating this column, see About working with columns.
- BALANCE (THIS PERIOD)
- Displays the system currency amount value for the selected period. The period is normally selected when you print the report. For information about creating this column, see About working with columns.
- CLOSING BALANCE (YEAR TO DATE)
- Displays the system currency amount value for all previous periods and the including the selected period. The period is normally selected when you print the report. For information about creating this column, see About working with columns.
The following lines are shown on the report:
- SALES
- Show the sales accounts. For more information about creating this line, see Define an item line.
- COST OF SALES
- Show the cost of sales accounts. For more information about creating this line, see Define an item line.
- EXPENSES
- Displays a header for all expenses. For more information about creating this line, see Define a text line.
- SALES & MARKETING EXPENSES
- Show the sales & marketing expenses accounts. For more information about creating this line, see Define an item line.
- ADVERTISING & PROMOTIONS
- Show the advertising & promotions expenses accounts. For more information about creating this line, see Define an item line
- DISTRIBUTION & WAREHOUSING
- Show the distribution & warehousing expenses accounts. For more information about creating this line, see Define an item line
- TRANSPORT EXPENSES
- Show the transport expenses accounts. For more information about creating this line, see Define an item line
- OTHER COSTS
- Show the other costs accounts. For more information about creating this line, see Define an item line
- TOTAL EXPENSES
- Displays the total of all expenses accounts. For more information about creating this line, see Define a sum line.
- TOTAL
- Displays the total of sales, cost of sales and total expenses accounts. For more information about creating this line, see Define a sum line
- EXPENSES & OF SALES
- Displays the expenses accounts percentage of sales accounts. For more information about creating this line, see Define a calculated line.
Throughout this routine, period 01 is January, 02 is February, etc. If you have a Financial year (which does not follow the Calendar year), period 01 might be July, 02 August, etc.
Printouts
- Print report specifications