Related topics
- About making enquiries on G/L balances and budgets
- About making enquiries on G/L transactions
- About reconciling accounts
On this and the following panels you select and sequence transactions from the G/L to reconcile, or that you want to make an enquiry about.
You can reach this panel from three different routines:
- Balances and budgets enquiry
- G/L transactions enquiry
- G/L account reconciliation
When you reach this routine from G/L account reconciliation, you can reconcile transactions on selected G/L account combinations. You do this by using the reconciliation options, Reconcile and Un-reconcile, on the G/L account reconciliation panel.
For each selected transaction, the account combination, voucher number, voucher type, amount, quantity with quantity code, period, text and reconciliation information is shown.
When you access this panel from the Balance/budget enquiry program a temporary template is automatically created and defaulted. It carries the key values that you have entered on the Balance/budget enquiry panel.
You can select and sequence on, for example, the following criteria; account parts, account period, voucher type and number, amount, document and transaction currency. You can also decide whether you want the selected transactions to be presented in ascending or descending order.
This is the first of three panels where you can make your selections and define your sequences.
Function keys
| Export | Export the data to an Excel file or CSV file. Normally when exporting data from sub-files to an Excel or CSV file, the number of records that can be exported cannot exceed 9999 records. Using this function key, any limitation of the number of records in a sub-file that can be exported/converted is eliminated. You can choose to leave all selection fields blank and click this function key, or fill in the necessary selections first and then click this function key. Either way, you will access the DC1 Export window where the number of records/rows that will be exported is displayed. Make your selection, i.e. choose Save to Excel file or Save to CSV file. |
| Display description | View the account description. |
Selection part 1
- Account part 1-8
- Period
- Reconciled
Value Description YES Include all reconciled transactions NO Include all non-reconciled transactions Blank Include all transactions - Voucher type
- Voucher number
- Voucher date
- Year/Journal
- Amount/Absolute val
Enter an individual or range of amounts (in system currency) using the first two input fields. Set the last input field to YES if you want to search and retrieve all debit and credit transactions containing this system amount/amount range.
G/L transaction enquiry/G/L account reconciliation, Selections (FMR50012)
On this panel you can continue with further selections.
Function keys
| Export | Export the data to an Excel file or CSV file. Normally when exporting data from sub-files to an Excel or CSV file, the number of records that can be exported may not exceed 9999 records. Using this function key, any limitation of the number of records in a sub-file that can be exported/converted is eliminated. You can choose to leave all selection fields blank and click this function key, or fill in the necessary selections first and then click this function key. Either way, you will access the DC1 Export window where the number of records/rows that will be exported is displayed. Make your selection, i.e. choose Save to Excel file or Save to CSV file. |
Selection part 2
- Document type
- Document number
- Document date
- Transaction currency
- VAT handling code
Only shown if the VAHC-G/L function is activated in the Function control file which enables selection on VAT handling codes updated on G/L transactions. - Description
G/L transaction enquiry/G/L account reconciliation, Selections (FMR50013)
On this panel you define your sequences for the enquiry. There is a maximum number of 18 sequences that can be selected at the same time.
Function keys
| Export | Export the data to an Excel file or CSV file. Normally when exporting data from sub-files to an Excel or CSV file, the number of records that can be exported may not exceed 9999 records. Using this function key, any limitation of the number of records in a sub-file that can be exported/converted is eliminated. You can choose to leave all selection fields blank and click this function key, or fill in the necessary selections first and then click this function key. Either way, you will access the DC1 Export window where the number of records/rows that will be exported is displayed. Make your selection, i.e. choose Save to Excel file or Save to CSV file. |
Sequence
- A/D
- Account part 1-8
- Voucher type
- Voucher number
- Voucher date
- Accounting year
- Accounting period
- Journal number
- Document type
- Document number
- Document date
- Transaction currency
- Amount
- VAT handling code
Only shown if the VAHC-G/L function is activated in the Function control file which enables selection on VAT handling codes updated on G/L transactions.
Save as template (FMR50014)
In this pop-up window you can save the made selections and sequences, that you are currently working with, in a new or an existing template.
- Template
- The system will automatically retrieve the id of the template you are currently using. You can change the name to a new one, or use the name of an existing template. Note: Changing template will override the made selections and sequences of the old template with the new ones.
- Description
- For existing templates, the current description is suggested. This description may be changed. Note: The defaulted description is the description entered when the template was created, even if a translated description exists.
G/L transaction enquiry/G/L account reconciliation, Print (FMR50015)
On this panel you set the printout parameters for the listing of the selected G/L transactions.
Printout parameters
In the fields below, you specify if you want the amounts printed in system currency and/or transaction currency, and/or reporting currency.
- System currency
- Indicate if you want the amounts printed in system currency.
- Transaction currency
- Indicate if you want the amounts printed in transaction currency.
- Reporting currency
- Indicate if you want the amounts printed in reporting currency. Note: You may select all currencies at the same time.
- Quantity
- Indicate if you want the quantity printed on the list.
- Text
- Indicate if you want the transaction text to be printed on the list. Note: The Quantity and Text fields are mutually exclusive.
G/L transaction enquiry/G/L account reconciliation (FMR50001)
This panel displays the balances of the transactions.
Options
| Reconcile | Only displayed if you enter this routine from G/L account reconciliation. Select this option to perform a reconciliation for transactions on the selected G/L account combinations. Note: To be able to view whether transactions have been reconciled or not you must click Fold and show the reconciliation information. If the transaction displays a YES, in the rightmost position, it has been reconciled. Otherwise blank. |
| Un-reconcile | Only displayed if you enter this routine from G/L account reconciliation. Select this option to undo the reconciliation. |
| Details | Select this option to drill-down to G/L details and further on to A/R or A/P document. |
| G/L text | Select this option to maintain text for the selected voucher. |
| Voucher | Select this option to display the entire voucher that this transaction was included in. |
Function keys
| Shift value | Toggle between showing the amount in system currency, reporting currency, transaction currency and quantity with quantity code. |
| Fold | Fold and show additional information per transaction, such as transaction text, document date, document number, document type, period and reconciliation information. |
| Selections | Return to the selection panel, where you can change/view your selections and sequences again. |
| Voucher date/number | Toggle between showing the voucher number and the voucher date. |
In the panel header:
- Rec.
- Displays what you have entered in Reconciled on the previous selection panel.
- Bal. per/amount
- Displays the balance in system currency of the entered account combination, at the period shown. If you enter another period, the balance at that period will be shown. The default is the actual period.
- Total sel.
- Displays the accumulated amount of the selected transactions.
In the subfile:
- T
- This column heading indicates if G/L text exists for the voucher.
- R
- This column heading indicates if the record has been reconciled. Click Fold to fold and show the reconciliation information.
G/L transaction enquiry/G/L account reconciliation (FMR50004)
This panel displays the detailed information for the selected transaction.
- Account parts 1 – 8
- Displays the account combination, with description, for the selected transaction.
- Period
- Displays the transaction’s accounting period.
- Year/Journal number
- Displays the year and the journal number in which the transaction was posted.
- Voucher type
- Displays the voucher type for the selected transaction.
- Voucher number
- Displays the voucher number for the selected transaction.
- Voucher date
- Displays the voucher date for the selected transaction.
- Document type
- Displays the document type for the selected transaction.
- Document number
- Displays the document number for the selected transaction.
- Document date
- Displays the document date for the selected transaction.
- Transaction amount
- Displays the amount in transaction currency for the selected transaction.
- System amount
- Displays the amount in system currency for the selected transaction.
- Quantity
- Displays the quantity for the selected transaction.
- Text
- Displays the entered text for the selected transaction.
- Currency
- Displays the transaction currency for the selected transaction.
- Reporting amount
- Displays the amount in reporting currency for the selected transaction, when applicable.
- Quantity code
- Displays the quantity code for the selected transaction.