Outstanding Warrants Report (APR018)
-
Print
-
DarkLight
-
PDF
Outstanding Warrants Report (APR018)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that lists Warrants that are outstanding, expired, or about to expire by specified date range to include Chart of Account ChartFields, payment transaction, Data and Business Unit. This report is intended to support users to monitor outstanding warrants that suppliers have not presented to the bank and will contain the age of all outstanding at the time the report is run and contains a calculated Payment Age (Current date – Payment Date), to identify warrants that are equal to or less than a certain month (e.g., 6 months, would include all months 6 months old and less than).
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- AP Reporter
- Confidential AP Viewer
Suggested Report Frequency
- Monthly
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
Report Prompts
The report data can be filtered by the following report prompts:
Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Business Unit | N | Y | Y | |
Payment Date (From: To:) | N | Financials – AP Transactions.Invoice Cleared Date.Payment Date | N | Y |
Supplier ID | N | Financials – AP Transactions.Supplier.Supplier ID | N | Y |
Payment Age | N | Financials – AP Transactions. Invoice Cleared Date.Invoice Cleared Payment Age(Months) | N | Y |
Payment Amount (From: To:) | N | Financials – AP Transactions. Facts - AP Transactions.AP Total Payment Amount | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | "AP Voucher Business Unit"."Business Unit" |
Organization | "AP Voucher Business Unit"."Organization" |
Voucher Origin | "Payables Payment Voucher Details"."Voucher Origin" |
Supplier ID | "Supplier Account"."Supplier Account Number" |
Remit Supplier Name | "Payables Payment Voucher Details"."Name 1" |
Voucher Line | "Payables Payment Voucher Details"."Voucher Line Number” |
Voucher Distribution Line | "Payables Payment Voucher Details"."Distribution Line Number" |
Distribution Line Merchandise Amount | "Fact - Fins - AP Transaction Custom"."Merchandise Amount" |
Account | "GL Account"."Account" |
Fund | "GL Account"."Fund" |
Budget Entity | "GL Account"."Budget Entity" |
Category | "GL Account"."Category" |
Grant | "GL Account"."Grant Id" |
Project | "GL Account"."Project" |
Budget Date | "Payables Payment Voucher Details"."Budget Date" |
Payment Reference Number | "Payables Payment Voucher Details"."Payment Reference ID (Interest Voucher)" |
Payment Date | "Payables Payment Voucher Details"."Payment Date" |
Payment Amount | "Fact - Fins - AP Transaction Custom"."Payment Amount" |
Payment Handling Code | "Payables Payment Voucher Details"."Payment Handling Code" || ' - ' || "Payables Payment Voucher Details"."Payment Handling Code Description" |
Payment Age (Months) | "Invoice Cleared Date"."Invoice Cleared Payment Age(Months)" |
Confidential | "Payment and Voucher Details"."Confidential" |
Additional ID | SUBSTRING("Supplier Account"."Supplier Account Additional ID Number" FROM 6 FOR 4) |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configured Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
01/31/2025 | Original Version |
Was this article helpful?
