[ 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).
|