In this screen you can see all transactions posted from the three fiscal years available for posting. Filters can be set to view less transactions and either reported on or exported. When printing any report with the Crystal Report Template of GL Transaction List will be listed.
The search box is very powerful in this list as you can find transactions from any word(s). An example would be to search for a customer code and every transaction posted for that customer will show on the list. Or search for a purchase order number so that every receiving, closed and AP entry will be found.
Refresh – Re-read the grid results to display all posted transactions, including any Filter criteria if used.
Filters – Use search criteria to display only particular transactions of interest.
Search Box – List account transactions that contain the entered word(s) in searchable text fields.
Export – Export the filtered and sorted list to Excel or .csv.
Print – Print any report with the Crystal Report Template of GL Transaction List.
Transaction – Choose from:
- View the complete journal entry
- View Source for the source transaction that produced this journal entry, from particular module posting. Source transactions from Sales Orders, Purchase Orders and Payroll can be opened, but not from Accounts Receivable, Accounts Payable, Inventory, Production Orders or General Ledger.
- Create a new journal entry transaction
- Reverse a previously posted GL journal entry by creating a new transaction for the same accounts but with debits and credits reversed.
View Account – Open the account record of the highlighted transaction, to see information or make and save changes.
Reconcile – Open the Account Reconciliation window for the highlighted account. If no Open reconciliation exists, then a new one will be created. If a reconciliation has been started and not yet posted, it will be opened. See Account Reconciliation for more details.
Grid Columns
Transaction No – The GL transaction number that was generated during posting, from the next transaction number in Company Settings/Sequence Numbers.
Source – The module / transaction type where this transaction was posted.
Transaction Date – The date that the transaction was posted to.
Type – The sub-category of transaction that was posted. Transactions originating in General Ledger will have a blank value.
Document – The document number passed from the subledger posting, such as the invoice or check number.
Entity – The customer, vendor or employee code of the posted transaction. Some transaction types will have a blank value.
Debit – The amount of the debit transaction. If it was a credit amount, this column will display zero.
Credit – The amount of the credit transaction. If it was a debit amount, this column will display zero.
Posted Date – The computer system date when the transaction was posted.
Currency – The currency code for the transaction, which will be blank for base currency transactions.
Foreign Debit – The source currency amount of the debit transaction. If it was a credit amount or a base currency transaction, this column will display zero.
Foreign Credit – The source currency amount of the credit transaction. If it was a debit amount or a base currency transaction, this column will display zero.
Memo – A text comment that may have been added to the account line entry.
Reconciled – The checkbox will display as selected if the entry has been reconciled.
Reconciled Date – The date that the entry was reconciled. If blank then it has not been reconciled.
User ID – The initials of the user that posted the transaction.
Reports
From the Transactions list screen and the reports toolbar button, either for all transactions or when editing a particular account, you can select one or more account transactions to print reports for the selection, or print the reports for all records. Note that printing selected records only chooses the selections and not necessarily the entire transaction, so it is possible to only print a portion of the entry.
Bank Disbursements List – Prints a list of credit transactions and any applied debit transactions. This report is designed to be used with a Filter that selects a specific bank account and a range of transaction dates, rather than entire journal entries.
GL Account Activity – Consolidated Divisions – Prints a list of the selected transactions, grouped by account number, with debits and credits and then net change amount. Additionally, if a transaction Filter was used to select records by date ‘in between’, instead of grid selection, and the beginning date is the first day of a period, a running Balance column will also be printed. You cannot include divisions in the filter, and must log into the company with a division of 000 to print this report successfully.
GL Journal Transaction – Prints a list of transactions with their respective accounts and debit or credit amounts.
General Ledger Account Activity – Prints a list of the selected transactions, grouped by account number, with debits and credits and then net change amount. Additionally, if a transaction Filter was used to select records by date ‘in between’, instead of grid selection, and the beginning date is the first day of a period, a running Balance column will also be printed.
Video Instruction