Account Inquiry Search

SEARCHING BY ROLLUP GROUP:

Instructions:

1. Open Account Inquiry (Tyler Menu > Departmental Functions > Account Inquiry)

   

2. Click SEARCH.

   

3. In “Rollup”, type your 3-digit site number followed by a “D” for Discretionary (ex: 009D).

   

4. Click ACCEPT.

   

5. The accounts will load:

   

6. NOTES:
   1. The Account Code is indicated at the top of the screen, with a description of the account right below it.
   2. The four columns of data represent the current fiscal year and three years historical.  Be sure to look at the column headers to verify the fiscal year.
   3. “Drill down” by clicking on the yellow folders next to the data you want to review. For example, click on the yellow folder next to “Actual (Memo)” for FY19 to see what was spent from that account.
   4. Use the black arrows at the bottom to click between account codes.

“SEARCHING BY SPECIFIC ACCOUNT CODE:

1. Open Account Inquiry Enterprise ERP -> Financials -> General Ledger Menu -> Inquiries and Reports -> Account Inquiry
2. Clear CLICK search in the top menu 
3. Enter your account code, exactly, into the “Acct” search bar. Note – this is an exact search, so you must have your full account number entered correctly. Click Enter. 
4. All Orange folders are clickable. You can review Actuals, encumbrances and budgets. 
5. Once you drill into a folder, you’ll see a detailed view of transactions. You can sort these transactions by clicking on the header column names. If you right click on a column name, you can add or remove columns from your view.
6. To get more detail on a transaction, highlight the line, and click the green Detail button at the top of the page.
   1. The Detail button won’t work for P-Cards in new through Released status. To see the detail of those P-Cards, you must go to Purchase Card Statements and lookup the P-Card.

SEARCHING BY SEG FIND:

1. Open Account Inquiry Enterprise ERP -> Financials -> General Ledger Menu -> Inquiries and Reports -> Account Inquiry
2. Click Seg Find in the top menu. 
3. Enter the segment you’d like to dive into. For example, if you know you purchased a supply (object code 450) but don’t remember which account you coded it to, (General Fund, Title Fund, SSASR Fund) you would search by object code 450: 
4. Click Enter.
5. From here, there are two options available:
   1. Browse all account codes, by clicking Browse at the top of the screen. Browsing gives you the ability to sort by account code or amount in the account. To sort, click the header names at the top of the columns.
   2. Total all expenses into a single detailed list by clicking Totals: the blue circle in the top right of the menu. When you click totals, all detail for the account 
6. If you click the Totals button, all Orange folders are clickable. You can review actuals, encumbrances and budgets. 
7. Once you drill into a folder, you’ll see a detailed view of transactions. You can sort these transactions by clicking on the header column names. If you right click on a column name, you can add or remove columns from your view.
   1. One of the columns is titled “Account”. If you don’t see the “Account” column, right-click any of the other header column names, and you’ll get a drop down of columns that can be viewed. Make sure “Account” is selected.
   2. When you find your transaction from among the list, you’ll know exactly how you coded it, by looking at the “Account” column.
8. To get more detail on a transaction, highlight the line, and click the green Detail button at the top of the page.
   1. The Detail button won’t work for P-Cards in new through Released status . To see the detail of those P-Cards, you must go to Purchase Card Statements and lookup the P-Card.
   2. Unposted p-card transactions will say “PCARD” in Ref4 

BONUS FEATURES::

7. Click BROWSE (located at the top of the screen) to see all the account codes in a list.

   

8. Click TOTALS in the Icon Toolbar.  If you pull in your Discretionary Budget, clicking TOTALS shows you the sum of those accounts.  This allows you to easily compare totals across Fiscal Years.

   

   Totals Screen (use the “Exit Totals” Icon to exit):

   

9. Use the EXCEL Icon to export your active records to Excel.

   

10. Select the columns to export. Click ACCEPT.