The balance sheet search conditions define which information is included in the balance sheet.
The Receipt date specifies the date of the receipts to be included. The default value in the start date is the start date of the oldest open accounting period.
In the New search condition drop-down menu, you can add the search condition Entry period(yyyy-mm), which allows you to select receipts by entry period. No default value is shown in the entry period field.
If you enter both the date and the entry period, the system selects receipts according to the shortest common time period (for example, the combination Receipt date 01.09.2011 - 31.10.2011 and Entry period 2011-10 - 2011-12 yields receipts from time period 01.10.2011 - 31.10.2011).
In the Report length drop-down menu, you can select Brief, Default, All account groups or All accounts.
In the Report columns drop-down menu, you can select the desired comparison data to be shown in the search result.
The column options are:
- Last month and total sum
- Every month and total sum
- Every quarter and total sum
- 12 month cumulative sums ending in different months
- Every dimension code and total sum
- Opening balance, change and closing balance
New search condition
The New search condition menu allows you to add a selected option from the drop-down list or from the additional options in the magnifying glass.
The search conditions for the balance sheet are the following:
- Budget version
- Entry period (yyyy-mm)
- Adjusted part: Dimension 1
- Invoice currency
- Name and Company ID
- Report language
- Report currency
- Number format
- Transaction value
- Back to top
The Receipt status drop-down menu allows you to select the statuses of the receipts to be included in the report. The option Business transactions includes all approved receipts, but not receipts in status Invalidated, Unfinished, Verified or Received and not receipts of type order. The option All includes all receipts except those in status Invalidated and orders in status Invoiced. The option Non-transactions includes transactions in status Unfinished, Verified and Received and all orders that are not in status Invoiced. You can select several receipt statuses at the same time, except if you select Business transactions, All or Non-transactions.
From the Receipt type drop-down menu you can select the receipt types to include in the report. You can select several receipt types at the same time.
Show rows with zero values
If you select Show rows with zero values, the report also shows the rows that have the value zero. The Report length selection All accounts does not affect this.
If you select Show rows with zero values, the report also shows the rows, the sum of which is zero. Report length selection All accounts also shows the accounting accounts which the title-level sums are composed of.
As the report comparison data you can select Budget, Previous year, Percentageor none. In the accounting reports, the comparison data is the basic budget, when no dimension items are used as search criteria. The dimension budget can be viewed when the dimension items included in the budget are used as the report's search criteria.
The buttons in the search result
The HTML, PDF and Excel buttons allow you to view the drill-down report in those formats if you like.
The Search transactions button opens the balance sheet, from which you can drill down to information in the individual receipts.