9.2 General Ledger Account List
Purpose: The following provides the steps to view the active General Ledger Accounts or Chart of Accounts (COA) in ctcLink.
Audience: Everyone within ctcLink.
You must have at least one of these local college managed security roles:
- ZD_DS_QUERY_VIEWER
If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.
General Ledger Account List
Navigation: Reporting Tools > Query > Query Viewer
- The Query Viewer page will display.
- Enter in QFS_GL_ACCOUNT_TBL_ACTIVE.
- Select Search.
- The query results will display.
- Select Run to HTML, Excel or XML to display query results.
Select the link Add to Favorites to add this query onto your own favorites list.
- For this example, the Run to HTML was selected and the query results are displayed below. Note the total number of Accounts. As new accounts are added/modified/archived, the query will be updated to reflect changes.
- Select the desired link; Download the results in; Excel Spreadsheet, CSV Text File, or XML File.
Note: all Active Accounts in ctcLink will display with the following fields/values:
- SetID = WACTC (Accounts are Global and maintained by SBCTC).
- Account = Each General Ledger Account has 7 digits.
- Effective Date = Date the Account was activated.
- Status as Effective Date = Active (excludes old COA).
- Description = Long description displayed.
- Short Description = Short description displayed.
- Account Type = Short Account Type Description.
- Account Type Description = Long Account Type Description: A - Assets, E - Expenses, L - Liabilities, R - Revenue, Q - Equity.
- Bud. Only = Y or N (Budgetary Accounts Only. Note: only N or non-budgetary accounts can be used for Accounting Transactions).
- Process complete.
0 Comments
Add your comment