University of Pennsylvania
Business Enterprise Network
BEN Financials Home
Frequently Asked Questions
Advisories
Closing Schedules
Logging On
Desktop/Printer Standards
Documentation
Training
Security Access
Enhancement Requests
Financial Systems
Document/Forms
Feedback


U@Penn


University of Pennsylvania
Suite 318 Franklin Building
3451 Walnut Street
Philadelphia, PA 19104
215.746.4357 (Phone)
215.898.0817 (Fax)

Penn Home Penn A-Z Directories Calendar Maps
 
Business Enterprise Network

[ BEN Financials ]

510.GA: Detail Transactions By Object By Organization
Documentation :|: BEN Balances Report Documentation :|: Quick View

* Return to Quick View List

Last Updated: 12/03/97

Although the 510.GA report was originally designed to provide transaction detail to the School of Medicine to support the management and reconciliation of CPUP and area Hospital accounts, it can be a useful report for broader purposes because it lists transaction detail for a given range of accounts.

The 510.GA report lists journal entry information for actuals only -- no budget or encumbrance entries are shown. Transactions are grouped, based on the object code, into either "University Charges" or "Hospital Charges" with a sub-total labeled "Total Current Activity". These transactions are followed by a net monthly total which adjusts the Total Current Activity by any transactions in object code 1526. For a definition of "University Charges" and "Hospital Charges", see the Report Template section below.


Report Break:

The report will provide a page break for each unique ORGanization defined in the parameters.


Sort Order:

The report level sort is by ORGanization in ascending order.

The primary row sort within the report is by Object Code. Within the accounting flexfield, the secondary sort is by Source and within each Source, the third level of sort is the Posted Date.

Sub-totaling occurs at the Object code level. The report displays sub-totals for University Charges, Hospital Charges, Current Activity, and Total Monthly Net. ORGanization level Beginning and Ending Balance are also displayed on the report.


Report Template:

No report template is used for this report. However, object parents are used to define which objects should be included in each of the transaction groupings. The following table identifies the objects used in these groupings:

Grouping

Object Codes

Hospital Charges

1529, 1531, 1533, 1535, 1536, 1537

University Charges

All object codes, except 1526 and those listed under the "Hospital Charges" category, are included in the University Charges category.

Total Monthly Net

Hospital Charges + University Charges + object code 1526.


Parameters:

In addition to the Accounting Period (Period Name), all seven account segments are available as parameters for account selection:

  1. CNAC (School/Center Net Asset Class)
  2. ORG (Organization)
  3. BC (Budget Control)
  4. FUND
  5. OBJ (Object Code)
  6. PROG (Program)
  7. CREF (Center Reference)

A low to high segment value range may be entered for any of the segment parameters. Parent values for any of the segments may also be used.


Report Heading:

The report heading includes the following information:

  1. Report Break:
    Indicates the accounting segment the report will break on. For this report, the ORGanization segment is the report break.

  2. Period Ending: MMM-YY
    Indicates the accounting period for which journal activity is provided. Accounting period is provided as a parameter when the report is requested.

  3. Organization/Description:
    Indicates the 4 character segment value and the segment value description for the ORGanization segment.


Report Columns:

From left to right, the report columns provide the following information.

  1. SOURCE
    This column displays the originating source of the journal entry batch.

  2. Batch Name
    This column displays the journal entry batch name.

  3. Accounting Flexfield
    This column provides the seven segment account number to which the journal was posted.

  4. Description
    This column displays the journal entry line description.

  5. HUP Cost center
    If a HUP Cost center was provided as additional descriptive information on the journal entry line, it will be displayed in this column.

  6. Line Item
    For transactions originating from Accounts Payable (source = Payables), this column displays additional line item information. For all other transactions, this column will be blank.

  7. Posted Date
    This column displays the date the journal was posted.

  8. Journal Amount

This column displays the amount of the transaction. Credit amounts are identified with a CR displayed next to the amount.


Last Page Of The Report:

On the last page of every report information is provided regarding the parameters used to request the report. If the account combinations returned to you in the report are not what you expected, the report parameters list is a useful first place to start. At a minimum, you can verify the range of values you provided at the time you submitted the request.

Comptroller Spotlights

GL Object Codes FY2018
Concur Expense Type/Object Code Matrix (2018)
FY2017 Closing Instructions
FY17 Closing Calendar QRG
Guide to Year-End Closing
School Closing Summary Template

BEN Offices

BEN Deposits
BEN Financials
Office of the President Home Page Penn A-Z Directories Calendar Maps
 
 
Copyright © , University of Pennsylvania
3451 Walnut Street, Philadelphia, PA 19104 · 215.898.5000
Copyright Information | Contact Us | Privacy Policy


Penn Home
Visit Penn's website