The Coins ERP+ General Ledger Reporter allows you to produce reports based on General Ledger accounts; for example:
Profit and loss reports
Balance sheet reports
Overhead analysis
Budget/actual comparisons
You can also report on some contract information, such as House Sales budgets and contract report stores.
You can report on GL accounts from all sectors of the current company, but also from other companies in the same environment. The reports can be detailed or summarised, and the accounts that are included can either be specified as part of the report configuration, or chosen by the user when they run the report.
GL Reporter – Adding a Report
In most cases it is recommended that you copy an existing report and make any amendments required. Using this method means you can use a report that is similar to your requirements. However there are situations when you may want to start from the beginning.
To create a GL report:
Go to Reporter Configuration.
The Reporter Configuration browse screen will be displayed showing all the reports that have been configured.
Click Add (
) to configure a new report.Give the report a code and a title.
These are used to identify the report, for example when choosing from a list which report to run. The code is the only part of the report that you cannot change directly once you have chosen it. If you need to rename a report you must copy it. The title will be printed on the report.
Click Save (
).While you are configuring the report, you can preview the layout: click the Preview link in the header.
On the Configuration tab, enter the settings that determine the overall appearance of the report, such as the page layout and font class to use.
Click here for details of the fields
Divide By
The number that the values on the report should be divided by.
For example, set this to 1000 or 1000000 if you want to report in thousands or millions. Set this to 2 if you want to report on a company you manage in Coins ERP+ but only have a 50% share in. 1 is the default, meaning that values will show as they actually are.
Zero or blank means do not divide.
Round
The precision to round the values on the report to. If zero or blank then no rounding is performed. Typically 1 or 1000.
Page Layout
The pre-defined page layout to use for the report.
Class
The pre-defined report class that defines the text formatting to use for the report.
Highlight Style
The class variant to be used for the report font.
Extra
Extra formatting to be applied to the report font.
Column Ratio
The number of printing points to be used for each column of the report layout. If left blank then a standard ratio will be used.
Normally leave this value blank unless the standard ratio is not suitable. Using the standard ratio, one column is approximately the point size multiplied by 0.22mm (so at 10pt, one column would be about 2.2mm wide)
Page Length
The number of lines of the body of the report that will fit on a page.
This allows the report output to be split on to pages correctly. The number of lines to use will depend on the page layout and the font class used.
Click Save (
).Then set up the report rows and columns.
The rows control the structure of the report. There are different row types, such as Account row, Total row, Text row. Account rows (and contract rows) specify the selection of General Ledger accounts (or a selection of contracts) to report on. Other row types determine where other lines such as subtotals and text lines come. See GL Reporter - Report Rows.
The columns control what information is shown on each line. You can select from a number of different data items, and specify which row types each one is shown on.