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
Contact Information
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 ]

900. Uninvoiced Receipts Report
Documentation :|: BEN Balances Report Documentation :|: Quick View

* Return to Quick View List

Last Updated: 03/02/09

The 900. Uninvoiced Receipts report is designed to provide a preview of all accrual entries that will be posted to your school/ center’s 26-digit account in June as part of year end processing. The accrual calculation is derived from the quantity/amount receipted less the quantity/amount billed times the unit price for an open purchase order line.

This report is unsecured and can be run from PO Manager and PO/CO Manager responsibility.


Sort Order:

The report sort order is by Charge Account Distribution, PO #, PO Line #, and PO Shipment #.


Parameters:

This is a standard Oracle report; all fields on the parameters page are NOT used in Penn’s environment.

Enter ONLY the following parameters:

  • Title - We highly recommend that the title you create includes the CNAC/ORG parameters used to run the report. These parameters are NOT shown on the parameters page as they are in other reports.
  • CNAC (Low-High) - (Required- only if the ORG is blank)
  • ORG (Low-High) - (Required- only if the CNAC is blank)
  • Minimum Extended Value - Enter the minimum accrual amount that you want to see on this report (i.e. if $1,000 is entered then the report will only show accrual amounts for purchase order lines that have uninvoiced receipts that are >= $1,000)
  • Period Name - Enter the current accounting period.

DO NOT use the following parameters. Accept the default

  • Accrued Receipts- Accept the default (NULL).
  • Include Online Accruals- Accept the default (NO).
  • Categories (From-To)- The report will not complete if these fields are entered.
  • Vendors (From-To)- The report will not complete if these fields are entered.
  • Sort By- Accept default (NULL).
  • Dynamic Precision Option- Accept the default (2).

Note: All purchasing reports are unsecured therefore a CNAC and/or ORG should be entered when running the report. Otherwise, the report will complete with accrual entries for ALL schools and centers.

To ensure that the report output is what you requested, select “0” print copies prior to submitting your report request. Once you have verified the report output, select the reprint option from the Requests form, Tools> Reprint.


Report Heading:

The report heading includes the following information:

Penn General Ledger Uninvoiced Receipts Report (Report Name)
Report Title (specified by user on parameters screen)
Report Date and Time
Page sequence


Report Layout:

Illustration 1: Purchase Order line with one Shipment line.

Illustration 2: Purchase Order line with multiple Shipment lines. The second Shipment line is created when a requisition contains two or more lines that are exactly alike with respect to supplier, item, ship to address and distribution. The PO will combine the quantities of the like lines into one line and create multiple shipment records -- one for each of the lines being combined.

Zone #1: PO Line Detail- provides information about the purchase order #, vendor, category, description and accrual amount for that line.
Zone #2: PO Shipment Detail- provides the same information as shown on the Quantity Detail folder from the Shipment screen in PO Manager. The Quantity Received, Quantity Billed and unit price used to calculate the accrual amount for that shipment is also shown in this zone. The accrual is created by using the following calculation (Qty Received x Unit Price) - (Qty Billed x Unit Price).

Zone #3: PO Distribution Detail- provides the Distribution information including the Quantity Ordered on a requisition for the PO Shipment Line(s). The unit price, the 26-digit charge account, accrual account and accrual amount for that distribution.

Note:
If the Quantity Received is less than the Quantity Billed, the accrual = 0.
If the Quantity Received exceeds the Quantity Billed an accrual is created.


First Page of the Report:

The parameters used to request the report are NOT printed on this page. The only information that is displayed is the Report Title in the header and the Period Name in which the report was run. If the data returned to you in the report is not what you expected, reference the report parameters used. (See Report Parameters section in report documentation).

Comptroller Spotlights

New Category Codes
2007 Financial Report
GL Object Codes FY2010
FY2009 Closing Instructions

BEN Offices

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


Penn Home
Visit Penn's website