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 ]

030. Invoice Date to Payment Date Summary Report
Documentation :|: BEN Balances Report Documentation :|: Quick View

* Return to Quick View List

Last Updated: 10/23/06

The purpose of the report is to provide a summarized view of the number of days between the supplier invoice date and the payment date for purchase order invoices (C-Form invoices are not included in this report).  The report captures all EDI and Non-EDI purchase order invoices entered in BEN Financials within the date range specified in the parameters.  It displays results in aging categories and reports them by count and dollar amount.   

To view payment performance for Non-EDI invoices within the standard 30 day terms, this report is run 30 days in arrears.  For example, an invoice entered in BEN on July 31st, with a supplier invoice date of July 20th, and 30 day payment terms, will be paid on August 20th.

 

To view payment performance for EDI invoices within the standard 7 day terms, this report is run 7 days in arrears.  For example, an EDI invoice brought into BEN on August 10th, with a supplier invoice date of August 9th, and 7 day payment terms, will be paid on August 16th.

 

This report is not secured 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, fiscal year or fiscal year-to-date) in which the Purchase Order invoice was entered into BEN Financials. Date format- DD-MMM-YYYY

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.   Parent ORG codes can also be used in this parameter.  The ORG Low/High values used in the parameter will print in the header of the first page just below the report description.

File Layout:

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

Column #

Column Heading

1

Days

2

Invoices

3

% of Total

4

Cumulative %

5

Amount

6

% of Total

7

Cumulative % 

 

Last Page of the Report:

Report Parameters

The date range 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

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