You can obtain information from the G/L account balances in three different ways:
- Through the Balance/budget enquiry. See Make an enquiry on G/L balances.
- Through the Query group enquiry. See About working with query groups.
- Through DC1 Report Writer where the layout of the reports and the information to include is completely user-defined. See About DC1 Report Writer for more information.
The Balance/budget enquiry gives you the possibility to make enquiries on single account values or combination of account dimensions. You may also enquire on your pre-defined summary identities. The balances may be viewed in system currency, reporting currency as well as transaction currency. If your company uses quantity you may also enquire on your quantity balances.
The balances are always displayed as a total per period. Three columns of information can be displayed at the same time which gives you the possibility to easily compare this year’s values with budget or last year’s achieved result. You define this on the enquiry template. You may create as many enquiry templates as you wish, making it easy to toggle between different information for the same account enquiry. For more information, see Create a G/L balance enquiry template.
It is totally user defined on which levels you can view your balances. If, for example, you want to see the total balance per cost centre, this is possible by creating a summary level for this combination. The summary level is set up in the Summary level definition table. You may change existing or add new summary levels at any time. See Define a summary level.
The result from your balance enquiry may be analysed on two different levels:
- The first level is a total of an account combination displayed per period.
- The second level displays the detailed transactions that build up your balances.