[ 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
BEN Offices
|
|