Docstoc

Vendor Liability Aging Report - Download Now DOC

Document Sample
Vendor Liability Aging Report - Download Now DOC Powered By Docstoc
					39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.docVendor Liability Aging Report           Training Guide


Vendor Liability Aging Report

Purpose:
The Vendor Liability Aging Report lists all vouchers (open liabilities in Payables) that have not been
paid by the “As of Date”. You can run the report in either summary or detail format for business units
and/or specific vendors. You can also specify whether to include unrecorded (un-posted) liabilities,
prepayments, un-matured drafts paid, and available discounts. The report excludes vouchers that are in
the Recycled status and categorized scheduled payments on hold or on hold for withholding.

The process does two things: Calculate which invoices fall into which aging bucket (0-30 days, 31-60
days, etc.) and then creates a Crystal report. The report uses public query
APY1408_AGED_VENDOR_LIABILITY

Navigation:
   1. Accounts Payable
   2. Reports
   3. Voucher Reconciliation
   4. Vendor Liability Aging
   5. Find or Add a run control

Run Request:




Last Change: 5/11/2010 11:44:00 PM39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.doc          Page 1 of 5
39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.docVendor Liability Aging Report                     Training Guide




Report Request Parameters:
Use this page to generate the Vendor Liability Aging Report.

        Field                                                     Explanation
As Of Date                Enter the end date for the period that you are processing.
As Of Date Type           Select either the accounting date or the invoice date. The report output is based on
                          either the accounting date or the invoice date of the voucher. The report includes data
                          based on the combination of the values in the As Of Date field and the As Of Date
                          Type field. For example, suppose that you enter 07/31/2003 as the as-of date and select
                          the accounting date as the as-of date type. All vouchers with open liabilities with the
                          accounting date of July 31, 2003 or earlier will be included in the report.
Aging Basis Date          Options are:
                          • Net Due Date: The report uses the Net Due Date from the voucher.
                          • Schedule Due Date: The report uses the Schedule Due Date from the payments tab of
                          the voucher. (Recommended option)
Include Unrecorded        Select this option to include vouchers that have not been paid and voucher posted.
Liabilities               Selecting this option also includes those vouchers that have not been processed through
                          the Journal Generator, which means they are not recorded in the General Ledger.
Include Prepayment        Select this option to include prepaid vouchers that have available amounts to be
                          applied. If you select to include prepayments, the report displays the Prepayments
                          column that includes both prepaid vouchers that have been paid but are not fully
                          applied and any prepaid vouchers that have not been paid. Prepaid vouchers that have
                          been paid but are not fully applied will appear as a negative (−) amount. Prepaid
                          vouchers that have not been paid appear as positive amounts.
                          If you do not select this check box, the Prepayments column does not appear in the
                          report, and the report Totals field displays the total amount of the prepayments that are
                          not fully applied
Include Unmatured         Select this option to include vouchers that are paid by a draft method when the
Drafts Paid               payment date is not due yet. Also, this option includes drafts that have been written off
                          after the as-of date.
Include Available         Select this option to include vouchers that reduce the liability. If you do not select to
Discount                  include available discounts, the prepayments column will not appear in the report.
Business Unit Option      Select All to create a report for all business units for the time period you specified.
                          Select Value to specify any number of business unit rows on which to report.
Business Unit             Select appropriate Business Unit. Additional Business Units can be selected by
                          clicking the + icon.
Vendor Select Option      Select Select All to create a report for all vendors for the time period that you specify.
                          Select Specify to specify any number of vendor ID rows on which to report.
Vendor SetID              Select STIND for SETID to pull in all the vendors from the vendor tables. The vendor
                          tables are driven by STIND not by Business Units.
Vendor ID                 Enter Vendor ID number(s) to pull information on specific vendor(s). Searches can be
                          done on more than one vendor by clicking on the + icon.
Aging Cycle ID            Select an aging cycle to specify the aging categories that group overdue columns in the
                          report. MONTH includes aging buckets for 0-30, 31-60, 61-90, 91-120 days plus
                          vouchers not yet due and due more than 120 days.




Last Change: 5/11/2010 11:44:00 PM39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.doc                    Page 2 of 5
39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.docVendor Liability Aging Report                Training Guide




Currency Options        Options are:
                        • Base Currency: The report uses the base currency of the business unit for each
                        voucher
                        • Selected Foreign Currency: The report uses the currency defined in the Currency,
                        Rate Type, and Currency Effective Date fields.
                        • Transaction Currency: The report uses the currency in which the procurement took
                        place.
Currency                Select appropriate Currency or leave blank. (Recommend leaving blank.)
Rate Type               Select appropriate Rate Type or leave blank. (Recommend leaving blank.)
Currency Effective      Select appropriate Currency Effective Date or leave blank. (Recommend leaving
Date                    blank.)
Report Vendor By        Options are:
                        • Invoice Vendor: The report will pull vendor information based of the invoice vendor
                        used on the invoice information tab of the voucher.
                        • Remit Vendor: The report will pull vendor information based of the remit vendor used
                        on the payment information tab of the voucher. (Recommended option)
Report Group By         Options are:
                        • Business Unit/Vendor: The report will sort data reported by Business Unit first &
                        then vendor.
                        • Vendor/Business Unit: The report will sort data reported by Business Unit first &
                        then vendor.
Detail or Summary       Options are:
                        • Detail: The report will output detailed outstanding liability amounts by Business
                        Unit, Voucher ID, Invoice Number, Accounting Date, Invoice Date, and Due Date
                        based on aging cycle dates.
                        • Summary: The report will output outstanding liability amounts by Business Unit and
                        by Vendor Number and Name based on aging cycle dates.




Last Change: 5/11/2010 11:44:00 PM39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.doc               Page 3 of 5
39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.docVendor Liability Aging Report                         Training Guide




Process Scheduler Options




When you click the Run button, the Process Scheduler Request page lists the processes that generate a liability
report. You can load data and generate a report or just generate the report. This table describes options, depending
on the report that you select:

      Process List Option                                                 Description
Vendor Liab Aging Data & Report       Loads data into the report tables based upon run request parameters and generates
                                      the Vendor Liability Aging report.
Vendor Liab Aging Report Only         Generates the Vendor Liability Aging report using data that is already loaded into
                                      report tables. Use this option when data is already loaded and when only the report
                                      format options have been changed since the last data load.
                                      Note. You must run the Vendor Liab Aging Data Application Engine process
                                      (AP_APY1408) if the as-of date, as-of date type, business unit options, or vendor
                                      options parameters change.

Note: For the report to be ran in an Excel format, after clicking the Run button, and change the drop down box for
*Type to WEB & the *Format drop down box to XLS. Once this has been complete click on the Description name
Vendor Liab Aging Data & Reprt link & change the *Type to WEB and *Format to XLS for both reports
(AP_APY1408 and APY1408).




Last Change: 5/11/2010 11:44:00 PM39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.doc                         Page 4 of 5
39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.docVendor Liability Aging Report                               Training Guide




Voucher Reconciliation Reports:
The table below lists additional Voucher Reconciliation Reports that can be utilized. The navigational steps are listed below as
well as the description.

Report ID       Name                        Description                                Navigation
and Report
APY1400         Summary AP/GL Open          Compares the AP Open Liability             Accounts Payable,
                Liability Account           balance to the GL Open Liability           Reports, Voucher
                Reconciliation Report       balance. (Crystal Report)                  Reconciliation,
                                                                                       Open Liability Reconciliation,
                                                                                       Payables Open Liability Reconciliation
APY1405         Detail AP/GL Open           Shows all accounting activity for          Accounts Payable,
                Liability Account           accounts payable transactions for each     Reports,
                Reconciliation Report       voucher. Use the detail report to          Voucher Reconciliation,
                                            validate the AP Open Liability             Open Liability Reconciliation,
                                            balance to the General Ledger.             Payables Open Liability Reconciliation
                                            (Crystal Report)
APY1406         Payables Open Liability     Lists all open liabilities by business     Accounts Payable,
                Report                      unit. (Crystal Report)                     Reports,
                                                                                       Voucher Reconciliation,
                                                                                       Payables Open Liability,
                                                                                       Payables Open Liability
APY1408         Vendor Liability Aging      Lists all vouchers that have not been      Accounts Payable,
                Data &Report                paid by the As of Date. You can run        Reports,
                                            the report in either summary or detail     Voucher Reconciliation,
                                            format for specific vendors.               Vendor Liability Aging.
                                            The report excludes ouchers
                                            that are in the Recycled status and
                                            categorized scheduled payments on
                                            hold or on hold for withholding.
                                            (Crystal Report).
APY1410         AP/GL Journal               Lists totals by journal line and journal   Accounts Payable,
                Reconciliation Report       ID. (Crystal Report).                      Reports,
                                                                                       Voucher Reconciliation,
                                                                                       AP/GL Journal Recon Request,
                                                                                       AP/GL Journal Reconciliation
APY1420         AP/GL Account               Lists account totals by Journal ID and     Accounts Payable,
                Reconciliation Report       Account. (Crystal Report).                 Reports,
                                                                                       Voucher Reconciliation,
                                                                                       AP/GL Account Recon Request,
                                                                                       AP/GL Account




Last Change: 5/11/2010 11:44:00 PM39ccc0e0-b0b6-4ede-9f42-6a1f4a5ae237.doc                              Page 5 of 5

				
DOCUMENT INFO