9.2 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: NavBar > Navigator > Accounts Payable > Reports > Voucher Reconciliation > Supplier Liability Aging

  1. On the Supplier Liability Aging search page, select the Add a New Value tab.
  2. Enter a Run Control ID.
  3. Select Add.  The Supplier Liability Aging page will display.
Add a New Value tab
  1. On the Supplier Liability Aging page, complete the Report Request Parameters.
  2. Enter or select today's date in As of Date.
  3. Enter or select MONT in Aging Cycle ID.
  4. Select Invoice Date or Accounting Date in As of Date Type.
  5. Select Net Due Date in Aging Basis Date.
  6. Select the Include Unrecorded Liabilities checkbox.
  7. Select the Include Prepayment checkbox.
  8. Select the Include Unmatured Drafts Paid checkbox.
  9. Select the Include Available Discount checkbox.
  10. Select Value in Business Unit Option.  The Business Unit field will become available.  
  11. Enter or select the College Business Unit.
  12. Select Select All Suppliers in Supplier Select Option.
  13. Select Base Currency in Currency Options.
  14. Select Invoice Supplier in Report Supplier By.
  15. Select Business Unit/Supplier in Group By.
  16. Select Detail in Detail or Summary.
  17. Select the Run button to initiate the process.  The Process Schedule Request page will display.
Supplier Liability Aging 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.
Process Scheduler Request
  1. Select the Report Manager link.  The Report Manager page will display.

 

Supplier Liability Aging Report Manager link
  1. Select the Administration tab to view the status of the Process Scheduler and to access the Supplier Liability Aging Report.

 

Administration tab
  1. Select the Refresh button until the Supplier Liab Aging Data Loading and APX1408-APX1409.pdf  yield a status of Posted.
  2. Select the APX1408-APX1409.pdf link to open and review the Supplier Liability Aging Report.
Administration Report List
  1. Review the Supplier Liability Aging Report.
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.