How to create a report from Account Inquiry

How to create a report from Account inquiry

Account Inquiry

Report

Financials > Account Inquiry or Financials > General Ledger Menu > Inquiries and Report > Account Inquiry

1. Click Search

2. Enter in the search criteria (Segment, full account, etc)

3. Click Excel 

4. Click Summary or Monthly

5. Click Ok

6. In the pop up window check off the fields that are needed 

7. Click Accept

Or

1. Click Search

2. Enter in the search criteria (Segment, full account, etc)

3. Click Browse

4. Hover over the column headers and right Click (then check off all the columns that are needed)

5. Click Accept

For Detail (shows one account at a time)

1. Click Search

2. Enter in the search criteria (Segment, full account, etc)

3. Click Detail in the ribbon

4. Complete all search criteria 

   • Date range

   • Year/period

   • Include Unposted journals

   • Actual journals

   • Budget journals

   • Encumbrance journals

   • Source journal

   • Reference 1

   • Reference 2

   • Reference 3

   • Reference 4

   • Invoice

        5. Click Accept

For additional options to view Detail:

Financials > General Ledger Menu > Inquires and Reports > YTD Budget Report

• Print Options tab: Year/period (Enter 1-13 as needed, run for Period 99 to include unposted journals)

• Additional options tab: Print journal detail, update the Year and period range.