General Ledger - Account Activity Query

Pgm: GLBALQRY – Account Activity Query; standard Treeview path: General Ledger > Queries > Account Activity Query

The Account Activity Query screen is used to examine the transactions for a company within a fiscal year, sorted by the posted date. This query relies on the year-end procedure being executed properly on all clearing accounts set to “0”. When the year-end procedure has not been executed, the outstanding balance may include the previous year figures.

Selection Criteria

Company, Year, From/To Period, Account Pick List

Enter/select a company code, fiscal year, period range, and account pick list.

[Query Data] – Button

Press this button to run the query and display all the transactions within the specified range for that company.

Account

This section lists the accounts set up for the selected company. Select an account to display it's transactions in the Transaction section.

Transactions

This section displays all the transactions posted for the account and fiscal period range selected in the previous two sections.