The Accounting Query – S/L Account Parameter Screen enables you to establish parameters for the review of subsidiary ledger accounts. This screen is the first screen to open when you choose the Saquery option in Accounting Query.
Access the Accounting Query – S/L Account Parameter screen as follows:
Access the Accounting Query option.
Select the printer you wish to use to print screens within this application.
Select Finish.
Select Saquery
Enter the desired S/L Account Parameters.
The following is a list of fields that appear on the Accounting Query – S/L Account Parameter screen and their descriptions.
Subs
The subsidiary code for the type of subsidiary you want to review. Enter “ALL” to find all subsidiaries associated to a particular ID.
Amt Type
The amount type that you want to select (ACT for actual, ENC for encumbered, etc). Use “ALL” for all subsidiary amount types.
Beg Date
For limiting subsidiary entries to those made within a range of dates; enter the beginning date to consider.
End Date
For limiting subsidiary entries to those made within a range of dates; enter the last date you want to consider.
Trs
The status of the transactions for which you are searching. Valid transaction statuses are:
(A)ll
(P)osted
(R)emoved
(V)oided
Bal
The subsidiary balance status for balances you want to consider. Valid balances statues are:
(A)ll
(C)losed
(L)ocked
(O)pen
Txt
Either “DESC” for description or “NAME” for name; the text associated with the entry or the name of the constituent.
Stop after:
A limit to your query up to a certain number of entries. If more than that number of entries is found, you will be asked if you want to continue at each addition increment of that number.
Level
The level of the subsidiary account. Subsidiary accounts can be reviewed in five separate ways: account (ACC) for the overall account information, balance (BAL) for entries by balance period, totals (TOT) for a summarization of types of entries to an account by balance period, entries (ENT) for the detailed entry, and statements (STMT) to review and print a subsidiary statement.
The following is a list of the commands that you can execute from the Accounting Query – S/L Parameter screen and their purposes. Note: You can use a specific command only when that command appears on the current command line.
Execute
Execute the parameters and moves you to the S/L Account Query screen.
Abort
When you first enter, abort returns you to the G/L side of Accounting Query. After entry of data clear the data entered and moves you between the S/L Parameter line and the S/L Account Query line.
Query
Moves to the S/L Account Query level. From this level, you can further refine your subsidiary ledger account search parameters.
G/L Query
Returns you to the G/L side of Accounting Query
Output
Launches an output window so you can change the printer/output device you selected when you first launched Accounting Query.
Fiscal Period/Date Help
When in the beginning date or ending date fields, this command allows you to perform a fiscal calendar lookup for all subsidiary periods and their associated begin/end dates.