en:fin_aru_pea
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
en:fin_aru_pea [2022/04/20 16:32] evelint [4.6. Object search and exclusion] |
en:fin_aru_pea [2022/04/20 16:46] evelint [4.7. Subtotals by currency] |
||
|---|---|---|---|
| Line 112: | Line 112: | ||
| - | ===== 4.1 Showing object name ===== | + | ==== 4.1 Showing object name ==== |
| Nominal Ledgers fine tuning has **show object name** setting, where all object levels that names should be displayed in report, can be entered by comma separated list. Object name is displayed only when **levels** option is also selected in report. | Nominal Ledgers fine tuning has **show object name** setting, where all object levels that names should be displayed in report, can be entered by comma separated list. Object name is displayed only when **levels** option is also selected in report. | ||
| Line 122: | Line 122: | ||
| - | ===== 4.2 Showing currency amounts and exchange rates ===== | + | ==== 4.2 Showing currency amounts and exchange rates ==== |
| It is possible to add currency amount and exchange rate columns to the report from fine tuning. | It is possible to add currency amount and exchange rate columns to the report from fine tuning. | ||
| Line 135: | Line 135: | ||
| - | =====4.3 Subtotals===== | + | ====4.3 Subtotals==== |
| **Subtotal** filter will generate subtotals with selected option. Each subtotal consists of transactions , opening and closing balances. The report also shows unchanged account balances for the selected date range. | **Subtotal** filter will generate subtotals with selected option. Each subtotal consists of transactions , opening and closing balances. The report also shows unchanged account balances for the selected date range. | ||
| Line 143: | Line 143: | ||
| - | ===== 4.4 Resetting balances ===== | + | ==== 4.4 Resetting balances ==== |
| It is possible to reset balances from the past. To do this, a financial transaction must be created with desired date, for example, at the end of the year. | It is possible to reset balances from the past. To do this, a financial transaction must be created with desired date, for example, at the end of the year. | ||
| Line 167: | Line 167: | ||
| :?: If for example an object has been deleted, a warining will be displayed when the financial transaction is saved, but the transaction will still be saved. | :?: If for example an object has been deleted, a warining will be displayed when the financial transaction is saved, but the transaction will still be saved. | ||
| - | ===== 4.5. Only with balance ===== | + | ==== 4.5. Only with balance ==== |
| If an account has a lot of transactions and there is a need to check only transactions that has closing balance for example by supplier. It is possible to choose Subtotal by Supplier and only with balance, then all suppliers that have closing balance 0 are excluded (only sum filter must also be chosen). | If an account has a lot of transactions and there is a need to check only transactions that has closing balance for example by supplier. It is possible to choose Subtotal by Supplier and only with balance, then all suppliers that have closing balance 0 are excluded (only sum filter must also be chosen). | ||
| Line 179: | Line 179: | ||
| {{:et:evelint20220420-162429.png}} | {{:et:evelint20220420-162429.png}} | ||
| Picture(9) | Picture(9) | ||
| - | ===== 4.6. Object search and exclusion ===== | + | ==== 4.6. Object search and exclusion ==== |
| Example from Nominal Ledger, account has turnovers with and without objects: | Example from Nominal Ledger, account has turnovers with and without objects: | ||
| Line 185: | Line 185: | ||
| Picture(10) | Picture(10) | ||
| - | **Shows only transaction rows that have object(s)** | + | === Shows only transaction rows that have object(s) === |
| {{:et:jane20211112-222321.png}} | {{:et:jane20211112-222321.png}} | ||
| Pilt(11) | Pilt(11) | ||
| - | **Shows only transaction rows without object(s)**\\ | + | === Shows only transaction rows without object(s)=== |
| Use character thats in ''System settings > Character to search empty field'' | Use character thats in ''System settings > Character to search empty field'' | ||
| {{:et:jane20211112-222539.png}} | {{:et:jane20211112-222539.png}} | ||
| {{:et:jane20211112-222836.png}} | {{:et:jane20211112-222836.png}} | ||
| - | + | Picture(12) | |
| - | Vahesumma valuutade lõikes | + | ==== 4.7. Subtotals by currency ==== |
| + | Nominal Ledger report in base currency (EUR) | ||
| {{:et:jane20211124-181720.png}} | {{:et:jane20211124-181720.png}} | ||
| + | === Subtotal by currency === | ||
| + | Option **subtotal by currency** shows transaction rows with different currencies converted into the base currency. | ||
| {{:et:jane20211124-181819.png}} | {{:et:jane20211124-181819.png}} | ||
| + | === Subtotal by currency with currency filter === | ||
| {{:et:jane20211124-181955.png}} | {{:et:jane20211124-181955.png}} | ||
