AP Supplier Liability Aging Report

Purpose: Use this document as a reference for creating the AP Supplier Liability Aging Report.

Audience: Accounts Payable Staff.

The BI Publisher Report provides a system delivered report that summaries outstanding vouchers based on the defined aging cycles with aging time periods that specify a numerical range representing days, weeks, and so forth. Aging cycles are used in Supplier Liability Aging (APY1408) reports.

You must have at least one of these local college managed security roles:

  • ZZ Accounts Payable Reports
  • ZZ Purchasing Reporting

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Run the AP Supplier Liability Aging Report

Navigation: Accounts Payable > Reports > Voucher Reconciliation > Supplier Liability Aging

  1. The Supplier Liability Aging search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA150_AP_SUP_LIAB_RPT (College, Process).
  3. On the Supplier Liability Aging page, complete the Report Request Parameters.
  4. Enter or select today's date in As of Date.
  5. Enter or select MONT in Aging Cycle ID.
  6. Select Invoice Date or Accounting Date in As of Date Type.
  7. Select Net Due Date in Aging Basis Date.
  8. Mark the following checkboxes:
    1. Include Unrecorded Liabilities - Select this option to include vouchers that have not been paid and voucher posted in AP but not in GL.
    2. Include Prepayment - Select this option to include prepaid vouchers that have available amounts to be applied.
    3. Include Unmatured Drafts Paid - Select this option to include vouchers that are paid by a draft method.
    4. Include Available Discount - Select this option to include vouchers that reduce the liability.
  9. Select Value in Business Unit Option.  The Business Unit field will become available.  
  10. In the Business Unit section, enter or select the college Business Unit.
  11. Select Select All Suppliers in Supplier Select Option.
  12. Select Base Currency in Currency Options.
  13. Select Invoice Supplier in Report Supplier By.
  14. Select Business Unit/Supplier in Group By.
  15. Select Detail in Detail or Summary.
  16. Select the Run button to initiate the process.  The Process Schedule Request page will display.
Supplier Liab Againg search page
  1. On the Process Schedule Request page, select the checkbox for the Vendor Liab Aging Data & Report to initiate the process to load the Accounts Payable information into a reporting stating table and will initiate the Supplier Liability Aging BI publisher report.
  2. Select Web in Type.
  3. Select PDF in Format.
  4. Select the OK button to initiate the PSJob process scheduler request and close the Process Scheduler Request page. For more information, please refer to the Process Schedule Request steps for further instructions.
Process Scheduler Request window
  1. The Supplier Liability Aging Report page displays. Select the Report Manager link.
Select Report Manager link
  1. On the Report Manager page, select the Administration tab to view the status of the Process Scheduler and to access the Supplier Liability Aging Report.
  2. Select the Refresh button until the Supplier Liab Aging Data Loading yield a status of Posted.
  3. Select the APX1408-APX1408.pdf link to review the Supplier Liability Aging Report.
Admin page of the Report Manager, select the APX report link
Example of the Supplier Liability Aging Report
  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.