G/L Source Turnover
For the detailed analysis of the G/L account by source type, a G/L Source Turnover report is created. This report contains the values at the beginning and end of the period and the turnover on debit and credit for the period for each account, sub-account according to the generation source. Functional features of the report are as follows:
- Generation based on the general ledger entries.
- Sources of amounts can be entries of customers, vendors, bank accounts and fixed assets.
- Setting the levels of detail of the report lines, namely: currency, contract, order, entry.
- Values of report amounts can be calculated in the original and additional reporting currencies.
- Generation of expanded start and end account balance.
- Report export to excel.
To run this report:
- Choose the
icon, enter G/L Source Turnover, and then choose the related link. - On the G/L Source Turnover page, set the parameters listed in the table below for generating and displaying information in the report:
| Filter | Description |
|---|---|
| View By | Select a period for which amounts will be displayed (day, week, month, quarter, year, accounting period). |
| Date Filter | Enter a date that will be used to filter the amounts in the window. |
| G/L Account filter | Select a G/L account, for which amounts will be displayed. You can select several G/L accounts at the same time. The filter is required. |
| Source Type Filter | Select a source type by which the turnover will be generated. The filter is required. |
| Source No. Filter | Enter a source number for turnover generation (specific customer, vendor, bank account or fixed asset). You can select several G/L source numbers at the same time. |
| Currency Code Filter | Enter a currency code for which the turnover will be generated. Available only when the Show amounts in original currency option is enabled. |
| Global Dimension 1 Code | Select a value of global dimension 1 by which amounts will be displayed. |
| Global Dimension 2 Code | Select a value of global dimension 2 by which amounts will be displayed. |
| Show Agreements | Select this option to display information in terms of agreements. Available only to customers and vendors. |
| Show Order | Select this option to display information in terms of orders. Available only to customers and vendors. |
| Show Entries | Select this option to display information in terms of entries. |
| Show Amounts in ACY | Select this option to display the amounts in additional reporting currency. |
| Show Amounts in OCY | Select this option to display the amounts in original currency. To generate totals in the original currency, set the values in the Currency Code Filter field. Not available for fixed assets. |
| Show External No. | Select this option to display the external document numbers for posted entries. |
| Expand Account | Select this option to display the expanded general ledger account balance on the page. Available only to customers and vendors. |
- Click Update Values.
To view detailed information on each of the amounts generated in the report lines, click on the amount, and the General Ledger Entries window with the appropriate filters will open.
On the Results FastTab, the results of the generated turnover are displayed.