Business Enterprise Network
	BEN Financials Home
	Frequently Asked Questions
	Advisories
	Closing Schedules
	Logging On
	Desktop/Printer Standards
	Documentation
	Training
	Security Access
	Enhancement Requests
	Document/Forms
	Contact Information
	Feedback

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

[ 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: 08/24/06

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]

§         Y - EDI (Electronic Data Interchange) - electronic transmission of select Penn Marketplace supplier purchase orders.

§         N - NON-EDI- ALL other purchasing suppliers that do not use the electronic transmission process.

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:

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.