How to create a report from Account Inquiry

Owned by Knowledge Assistant
Dec 13, 2024
1 min read
Description of Issue

How to create a report from Account inquiry

Context

Account Inquiry

Report

Cause

Resolution

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

Additional Information

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.