How to run the Project Balance Check - Utility

Owned by Knowledge Assistant
Last updated: Mar 14, 2024
Description of Issue
  • Project Expense String(s) and Funding Source(s) have incorrect Budget, Actual, Encumbrance or Requisition amounts
  • Project memo header/summary amounts do not match underlying journal detail lines for posted and proof
Context
  • Project Balance Check (pabalchk)
  • Utilities
  • General Maintenance
Cause
  1. Proof Transaction incorrectly updated PL Monthly Amount values when detail line was allocated or re-allocated with an amount
    • Adding new transaction to proof
    • Change period (Deletes original journal, inserts new proof journal)
    • Modify Detail account or amount
    • Deleted
  2. Output Posted any Munis Module transaction for Actuals including PL String(s)
    • Proof or Posted journal process Interrupted
Resolution
  1. Browse System Administration > Diagnostic Tools > Project Balance Check
  2. Select Define
  3. Search by
    • Project (Code)
    • Project String
      • Project Sting Type Expense or Funding Source
        • Project String (PL String Segments)
  4. Month/Year Range Month/Year to Month/Year
  5. Accept
  6. Select
  7. Excel
  8. Select all check boxes for fields needed from the Export Filter
  9. Accept
  10. Review and reconcile each error and try to identify the root cause
    1. Try to identify specific Journal(s) or Transactions that tie out to amount differences 
    2. Keep all review examples and screen shots for Financial Support to review in detail
  11. Contact Munis Financial General Ledger Support for root cause analysis or log an Online Support Client Portal categorized as Project & Grant Accounting with all attached examples of review and the Excel list of errors
Additional Information