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 ]

003. Invoice On Hold Summary Report
Documentation :|: BEN Balances Report Documentation :|: Quick View

* Return to Quick View List

Last Updated: 07/10/06

This report is used to summarize, by Buyer or Org, invoices that are on hold and have outstanding holds greater than the number of days specified in the parameters of the report. The report shows both invoice count and invoice amount for the invoices on hold.

To view invoice details by Buyer or Org use the 500. Matching Holds Extract or the 501. Matching Holds Report. The data returned on the 500 and 501 reports will not necessarily match the summary data on the 003 report. When the "ORG" is specified in the parameters for the 500.Matching Holds Extract and the 501.Matching Holds Report it is selecting Purchase Orders that have used that "ORG" in the PO distribution. The 003 report uses the "ORG" parameter to select the invoice hold data by the "Home" Dept/Org of the buyer, regardless of the distribution used on the Purchase Order. Therefore, all invoices/holds would be included in the user’s MarkView Working Folder.

This report is not secured by org and can be run from the Sr. BA Reporting responsibility.

Parameters:

This report requires ALL parameters [Group By, Order By, > Entered # of days on hold, ORG Low and ORG High] to be entered.

GROUP BY [Select Buyer OR Home ORG]

§         Buyer

  • ALL invoices on Hold for that particular buyer for any account combination.

§         Home Org

  • ALL invoices on Hold for any Purchase Orders processed by buyers within the ORG entered. If purchase orders were processed by a buyer in this Home Org and they have invoices on hold, they will appear on this report

ORDER BY [Descending Order]
  • 1 - Order by Invoice Amount (Descending)

  • 2 - Order by Number of invoice exemptions (Descending)

This data will be displayed in descending order

> [greater than] ENTERED # OF DAYS ON HOLD

  • Number entered in this parameter is used to determine how many invoices are on hold for “X” # of days greater than the date the invoice went on hold. Data is calculated as the duration between the dates the oldest hold was applied on an invoice to the point in time when this report is run. Number of Days: 0-99. Standard vendor terms are 30 days. The standard timeframe for clearing a hold is 7 days or less.
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

1

Buyer Name

2

# Invoices on Hold

3

Invoice Amount

4

Org

5

Org Name

6

Center

7

Center Name

8

Cumulative Count

9

Cumulative Dollars

10 Cumulative Count %
11 Cumulative 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.

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