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:36] evelint [Shows only transaction rows without object(s)] |
en:fin_aru_pea [2022/04/25 14:25] evelint [4.2 Showing currency amounts and exchange rates] |
||
|---|---|---|---|
| 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. | ||
| {{:et:pearaamat_pilt31.png?|}} | {{:et:pearaamat_pilt31.png?|}} | ||
| - | {{:et:pearaamat_pilt32.png?|}} | + | {{:et:evelint20220425-141838.png}} |
| Picture(3) | Picture(3) | ||
| - | ===== 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. | ||
| - | {{:et:pearaamat_pilt4.png?|}} | + | {{:et:evelint20220425-142530.png}} |
| - | {{:et:pearaamat_pilt41.png?|}} | + | |
| - | {{:et:pearaamat_pilt42.png?|}} | + | |
| Picture(4) | Picture(4) | ||
| Line 135: | Line 133: | ||
| - | =====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 141: | ||
| - | ===== 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 165: | ||
| :?: 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 177: | ||
| {{: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 183: | ||
| 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) | |
| - | ===== 4.7. Subtotals by currency ===== | + | ==== 4.7. Subtotals by currency ==== |
| + | Nominal Ledger report in base currency (EUR) | ||
| {{:et:jane20211124-181720.png}} | {{:et:jane20211124-181720.png}} | ||
| + | Picture(13) | ||
| + | === 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}} | ||
| + | Picture(14) | ||
| + | === Subtotal by currency with currency filter === | ||
| + | Option **subtotal by currency** with **Currency** filter shows by currencies their beginning balance, turnovers and ending balance in nominal value. | ||
| {{:et:jane20211124-181955.png}} | {{:et:jane20211124-181955.png}} | ||
| + | Picture(15) | ||
