Output General Ledger Accounts by Rollup Code

Owned by Knowledge Assistant
Last updated: May 15, 2023
Description of Issue

Need to have a list of all accounts and their assigned rollup codes

Context
  • Reports
  • Budget Rollup
Cause
  • Account Master does not output rollup codes
  • Account Inquiry does not output rollup codes
Resolution

YTD Budget Report program can be used to generate a list of all accounts and their assigned rollup codes.

  1. Browse to Munis > Financials > General Ledger Menu > Inquiry & Reports > YTD Budget Report
  2. Choose Select
  3. Accept
  4. Report Options
  5. Update
  6. Use YTD Budget Report option's sort sequence as follows:
    1. Rollup Code
    2. Org Code
    3. Object Code
    4. Project Code
  7. Accept
  8. Return
  9. Excel
  10. Choose all needed field checkboxes for output, especially Rollup Code
  11. Ok
Additional Information

Excel can be filtered and sorted as needed