/
How to create a report from Account Inquiry

How to create a report from Account Inquiry

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.









Related content

How to display actuals from account inquiry into one report
How to display actuals from account inquiry into one report
More like this
YTD Budget Report Amount Does Not Match Account Inquiry - Unposted Transactions in the Account
YTD Budget Report Amount Does Not Match Account Inquiry - Unposted Transactions in the Account
More like this
Account missing from YTD Budget Report excel version - Account transaction detail type is not selected in Report Options
Account missing from YTD Budget Report excel version - Account transaction detail type is not selected in Report Options
More like this
YTD Available Budget - Output not working
YTD Available Budget - Output not working
More like this
How to run the Account Detail History Report
How to run the Account Detail History Report
More like this
Unable to generate data with the Cash Flow Journal Summary report
Unable to generate data with the Cash Flow Journal Summary report
More like this