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 ]

010. Invoice Creation Exceeds Vendor Invoice Date Summary Report
Documentation :|: BEN Balances Report Documentation :|: Quick View

* Return to Quick View List

Last Updated: 02/02/2010

The report summarizes invoice exceptions for purchase order invoices that have an invoice creation date [date invoice is entered into BEN Financials] that exceeds the vendor invoice date by a specified number of days. This report can be run to help determine which invoices are not paid within vendor terms [Standard terms are 30 days]. An example of this would be invoices not being sent directly to Accounts Payable for processing. Exceptions can be summarized by Buyer or by Org.

To view invoice level details for this exception type, by buyer or Org, the 015 Detail report should be used.

This report is unsecured by Org and can be run from the Sr. BA Reporting responsibility.

Parameters:

This report requires ALL parameters to be entered.

INVOICE CREATION START & END DATE

  • Date range (typically a calendar month) in which the Purchase Order invoice was entered into BEN Financials. Date format- DD-MMM-YYYY

SUPPLIER TYPE [EDI/ Non-EDI]

  • B - EDI & Non-EDI (Both) – purchasing suppliers that submit invoices using Electronic Data Interchange and also all other purchasing suppliers. Type = B
  • Y - EDI (Electronic Data Interchange) - electronic transmission of select Penn Marketplace supplier purchase orders. Type = Y
  • N - Non-EDI - ALL other purchasing suppliers that do not use the electronic transmission process. Type = N
GROUP BY
  • Buyer
    • ALL invoice exceptions for a particular buyer for any account combination.
  • Org
    • ALL invoice exceptions for any Purchase Orders processed using the specified Buyer ORG
ORDER BY (Descending Order)
  • 1 - Order by Dollar amount of invoice exceptions (Descending)
  • 2 - Order by Number of invoice exemptions (Descending)
ENTERED # of DAYS
  • Number of days by which that the Invoice Create Date in BEN Financials exceeds the Vendor Invoice Date. Number of Days: 0-99. Standard vendor terms are 30 days.
ORG LOW & ORG HIGH
  • Enter the Low/High values for the ORGs to be included for the report. ORG for this parameter is the buyer's home organization. To report on all ORGs within a school or center, specify the lowest ORG to the highest ORG in that school/center.

File Layout:

From left to right, the columns provide the following information:

Column #Column Heading
1Buyer Name
2Invoice Count
3Invoice Org Amount
4Org
5Org Name
6Center
7Center Name
8Cumulative Count
9Cumulative Dollars
10Cumulative Count %
11Cumulative Dollar%

The report will have a total for the invoice amount at the Buyer level, ORG level and grand total.

Last Page of the Report:

Report Parameters

The parameters used to request the report are printed on the last page as confirmation of what was requested. If the invoice data 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 report.

College Hall window

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
spacer
spacer
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