Run, Schedule, Share Any Report...

How to Run the Fund Equity by Fund Reports (UGLC016 A-E)

The Fund Equity Reports UGLC016 A-E have three different links under the Custom Reports - GL menu.  All the reports display revenue, expense, adjustment activity and give an equity balance (you must remember to subtract the Commitments from the Ending Balance to get a true equity balance).  They only differ by presentation of data.

Fund Eqty by Dept Range (016) reports all fund equity balances for a specific department or range of departments.

Fund Eqty by deptree (016A-D) reports all fund equity balances for a specific DeptID and fund range.  The A-D specifies the sort:  A = by Department Node, B = Fund Equity by Dept/Fund Group, C = Fund Eqty by Fund Grp/CostCntr (this report would be the most useful for departments to run to excel), D = Fund Eqty Summary by Fund.

Fund Eqty by Fund Range (016E) reports all fund equity balances for a specific fund or range of funds. 

The following example will be using the 016E report.

1. NAVIGATION:         Custom Reports – GL – Fund Equity by Fund Range (016E)
2. Click Search on the Find an Existing Value tab to select a Run Control ID to open the report parameters page. 
3. To add a new run control:  select the Add a New Value tab.  Enter a name for the run control, and then click the Add button.

     4.  Enter 00759

     5.  Enter the fiscal year.

     6.  Enter the Period To.

     7.  Enter the Fund Range.

     8.  Click Run.

     9.  Make sure the report is selected

   10.  Make sure Web and PDF are selected.

   11.  Click OK.  This will take you back to the report parameters page, click Process Monitor.

  12.  Look for a Run Status of “Success” and a Distribution Status of “Posted”.  Click Details.

  13.  Click View Log/Trace.

  14.  Click the PDF file link to open the report in Acrobat Reader.