Reviewing Voucher, Payment, and Vendor Information

This section provides an overview of voucher, payment, and vendor information, lists common elements, and discusses how to:

Click to jump to parent topicUnderstanding Voucher, Payment, and Vendor Inquiries

PeopleSoft Payables provides numerous inquiry pages and reports that enable you to access your voucher, payment, and vendor information how and when you need it. The inquiry pages in particular can be very useful when your customers call and want you to track down information for them.

Using Voucher Information to Access Payment Detail

What if a vendor calls looking for an outstanding invoice? The vendor won't have any of the information that has become part of the voucher (such as voucher ID), but only raw data as it appears on their invoice. How do you find the information they are requesting? In this instance, you would:

  1. Use the Voucher Inquiry page to search for vouchers by vendor and vendor invoice number.

  2. Drill down to the Scheduled Payment Inquiry page to view the scheduled payment details for the vouchers (such as payment method, scheduled pay date, and approval status).

  3. Drill down to the Voucher Payment Detail page to access detail on the payment itself (such as bank, payment date, payment amount, currency, and payment status).

  4. Drill down to the Voucher Detail Lines Display page to view invoice and distribution line level detail for the vouchers (such as General Ledger business unit, ChartFields, and line amounts).

You can continue to drill down from the inquiry pages to more detailed information.

Using Payment Information to Access Voucher Detail

What if a vendor calls and asks you which invoices were included on a check they have received? The advice may have become separated from the check itself, making it impossible for them to enter reconciling entries in Account Receivable. In this instance you would:

  1. Use the Payment Inquiry page to search for payments by vendor name and check amount, or payment method.

  2. Drill down to the Vouchers For a Payment page to view payment details (such as vendor address, reconciliation date, voucher ID, paid amount, and currency).

You can continue to drill down from the inquiry pages to more detailed information.

In addition to being interconnected, enabling you to access payment information for a voucher, or voucher information for a payment, these interconnected pages also enable you to:

Click to jump to parent topicCommon Elements Used in This Chapter

Amount Rule

Enter an amount rule and a value in the Amount field. To search on a particular voucher amount, specify how you are comparing your search to that amount. Options include: Any, Equal to, Greater than, Greater than or equal to, Less than, Less than or equal to.

Financial Sanctions Status

Select a vendor's financial sanctions status. This field is applicable when you have enabled financial sanction editing either at the installation level on the Installations Options - Payables page or at the bank level on the Bank Information page. Options include:

Blocked: The vendor has been positively identified as being a match to a financial sanctions list (for example, the Specially Designated Nationals (SDN) list).

Cleared: The vendor was reviewed and determined that it is not a match to a financial sanctions list.

Review: The vendor is a potential match to a financial sanctions list and needs further review.

Valid: The vendor is not a potential match to a financial sanctions list. The system sets this status initially for all vendors before any validation occurs.

Max Rows (maximum rows)

Enter the maximum rows to be retrieved in the main search for each component. Maximum rows that can be retrieved are 300.

Click to jump to parent topicReviewing Voucher Information

You can review vouchers using several inquiry pages and reports.

This section describes how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Review Voucher Information

Page Name

Definition Name

Navigation

Usage

Voucher Search

VCHR_SRCH_WRK

Accounts Payable, Vouchers, Add/Update, Voucher Search

Perform a quick search when little data is known.

Voucher Inquiry

AP_VOUCHER_INQUIRY

Accounts Payable, Review Accounts Payable Info, Vouchers, Voucher, Voucher Inquiry

Search for and review status of a voucher and any payment information.

Voucher Details

AP_VCHR_LN_DET_DSP

Click a Detail Lines button on the More Details tab of the Voucher Inquiry Results grid on the Voucher Inquiry page.

View voucher line and distribution line detail. You can also view attachments and comments related to this voucher.

Voucher Payment Detail

VCHR_PYMNT_INQ

Click the Payment Information button on the Voucher Details tab of the Voucher Inquiry Results grid on the Voucher Inquiry page.

View information about the payments that make up a voucher.

Scheduled Payment Inquiry

AP_SCHD_PYMNT_INQ

  • Click the Scheduled Payments button on the More Details tab of the Voucher Inquiry Results grid on the Voucher Inquiry page.

  • Accounts Payable, Review Accounts Payable Info, Vendor, Scheduled Payment, Scheduled Payment Inquiry

View the scheduled payments details.

Rejected Vouchers

VNDR_PAYINQ_RJCT

Accounts Payable, Review Accounts Payable Info, Vendor, Rejected Vouchers

View vouchers that have a status of Rejected.

Click to jump to top of pageClick to jump to parent topicSearching for Vouchers

Access the Voucher Search page (Accounts Payable, Vouchers, Add/Update, Voucher Search)

The Voucher Search page is useful when you want to search and update vouchers using limited criteria, such as by business unit.

Click to jump to top of pageClick to jump to parent topicReviewing Voucher Details

Access the Voucher Inquiry page (Accounts Payable, Review Accounts Payable Info, Vouchers, Voucher, Voucher Inquiry).

Note. Multiple views of this page are available by clicking the tabs in the scroll area. We document fields that are common to all views first.

Search Criteria

Enter search criteria to create your request.

Note. The screenshot displays all the fields that can display. Actual search criteria fields that appear are dependent on fields specified on the Named Search Criteria List page.

See Setting Up Inquiry Search Criteria.

From Business Unit and To Business Unit

Enter a business unit or a range of business units to be used in your search. A business unit is required. You must specify at least one other search criteria. If only the business unit is known, use the Voucher Search page.

If you search on a range of business units, you cannot search on either a Voucher ID or an Invoice number.

From Short Name and To Short Name

Enter a vendor short name or range of vendor short names to be used in your search. Once a name is entered in the From Vendor Short Name field, the To Vendor Short Name field is populated and available for entry.

Once you enter a name in the From Vendor Short Name field, both vendor ID fields are populated but are unavailable for entry.

If you search for a range of vendor short names you cannot search on a vendor location in the same search.

From Vendor ID and To Vendor ID

Enter a vendor ID or range of vendor IDs to be used in your search. Once a number is entered in the From Vendor ID field, the To Vendor ID is populated and available for entry.

To search on a range of vendor ID numbers, use both fields. To search on one vendor ID number, use the From Vendor ID field and leave the To Vendor ID field blank.

Once you enter a vendor ID in the From Vendor ID field, the vendor name fields are not populated but are unavailable for entry.

If you search for a range of vendor IDs, you cannot search on a vendor location in the same search.

Entry Status

Select the overall voucher status.

Lease Number

Enter the lease number for a lease payment voucher. This field displays only when you have also installed the Real Estate Management module.

Voucher Style

Select a voucher style. Options include specific voucher styles, all vouchers, and all vouchers except prepaid and single pay vouchers.

Post Status

Select a voucher post status. Options include: NotApplied, Posted, or Unposted.

Approval Status

Select an approval status. Options include: Approved, Denied, or Unapproved.

Voucher Balance

Select a voucher balance option. Options include: Balance Remains or No Balance Remains.

Voucher Source

Select the original data source for the voucher or leave blank to select all sources.

Match Status

Select a specific match status of the voucher.

Max Rows

Enter the maximum amount of rows for the system to display. The system will initially count the number of rows returned by the search criteria, and if this number is larger than the amount entered in this field, a message will display asking if the system should continue searching additional data rows. If you click OK, the system will sort the rows based on the sort criteria selected and display only the maximum. If you select Cancel, you can return to the search page to enter additional search criteria to further reduce the number of results.

Sort Criteria

Sort By

Enter the field you want to sort by and select a sort order of Ascending or Descending.

Double click on any column header and you can also resort the search results.

Display Currency Criteria

Currency

Enter the type of currency in which you want your data to display.

This field is populated from the operator preferences but you can edit it. The system converts all of the payments shown to this currency.

Rate Type

Enter to convert the amounts that use the exchange rate for the type of currency you selected.

Show Display Currency

Select if you want to convert all amounts to one consistent currency type for display purposes.

Convert

Click to activate the search on the payments that match your selection criteria and to convert the display, if you chose to.

Late Interest Analysis

Payment Date

Enter a "what-if" payment date.

Calculate

Click to calculate late interest charges for overdue vouchers.

Voucher Inquiry Results

Once you generate your search, the results appear at the bottom of the page.

Voucher Details Tab

Accounting Entries

Click the button to access the Voucher Accounting Entries page in a separate window, where you can view detailed information about a voucher's associated accounting entries while still reviewing the voucher inquiry search results.

Match Workbench

Click the button to access one of the Match Workbench inquiry pages in a separate window, where you can view detailed information about matched documents for the selected voucher while still reviewing the voucher inquiry search results. The inquiry page you access is dependent on the match status of the voucher.

Payment Information

Click the button to access the Voucher Payment Detail page, where you can view more detailed information about a voucher payment.

Scheduled Payments

Click the button to access the Scheduled Payment Inquiry page, where you can retrieve scheduled payment information for a vendor or a group of vendors.

Amounts Tab

Lists the various amounts and charges of the voucher.

Gross Invoice Amount

Displays the total invoice amount, including any nonmerchandise amounts.

Voucher Unpaid Balance

Displays the unpaid balance amount remaining on the voucher.

Unapplied Prepayments

Displays the total unapplied prepayments for the voucher.

Total Non-Merch (total nonmerchandise)

Displays total amount of gross invoice amount allocated to sales tax, use tax, freight tax, and miscellaneous tax.

Entered VAT

Displays the VAT amount entered on the voucher header.

Gross Amount Paid

Displays the actual amount paid on this voucher.

Net Amount Paid

Displays the gross amount paid on this voucher, less any discount.

More Details Tab

Lists the various statuses of the voucher and the dates associated with the voucher.

Detail Lines

Click the button to access the Voucher Details page, where you can view line and distribution line detail for the voucher.

See Also

Entering and Processing Vouchers Online: General Voucher Entry Information

Defining Late Interest Charges

Click to jump to top of pageClick to jump to parent topicReviewing Voucher Payment Details

Access the Voucher Payment Detail page (click the Payment Information button on the Voucher Details tab of the Voucher Inquiry Results grid on the Voucher Inquiry page).

Access the Voucher Payment Detail page from the Voucher Inquiry page.

Click the Payment Reference ID link to go to the Payment Inquiry Page.

Applied Business Unit and Applied Voucher ID only display information if the payment was made by the application of a prepaid voucher. These prepayment application lines do not have a payment reference ID or a payment date.

Click the Back To Voucher Inquiry link to return to the Voucher Inquiry page.

Click to jump to top of pageClick to jump to parent topicReviewing Scheduled Payment Information

Access the Scheduled Payment Inquiry page (Accounts Payable, Review Accounts Payable Info, Vendor, Scheduled Payment, Scheduled Payment Inquiry).

Search Criteria

Enter the search criteria for your inquiry. There are some dependencies among search fields:

All other fields can be used to search in any combination. Many fields enable you to search by single value or range of values.

Most fields in this region are similar to those discussed for the Voucher Inquiry page.

See Reviewing Voucher Details.

Note. The screenshot displays all the fields that can display. Actual search criteria fields that appear are dependent on fields specified on the Named Search Criteria List page.

See Setting Up Inquiry Search Criteria.

Display Currency Criteria

You can convert the currency that appears in the results region to one common currency. You can enter your display currency criteria either before or after you click the Search button. Enter the currency code of the type of currency that you want your data to be displayed in. This field is automatically populated from the operator preferences, but you can edit it. The system converts all of the payments shown to this currency.

Select Rate Type to convert the amounts by using the exchange rate for the type of currency that you selected. Select the Show Display Currency check box to view additional information about the converted amounts. Today's date appears by default in the As of Date field. If you have already generated your search, click the Convert button to convert the display of your results.

Note. The Convert button displays the converted currencies; it does not convert them.

Sort Criteria

To sort your results, select the field or fields that you want to sort by, and select whether you want your inquiry sorted in descending order. Click the Sort button to generate the sort.

Schedule Payment Listing

Results appear in the Scheduled Payment Listing grid.

Style

Displays the voucher style for this scheduled payment.

Voucher ID

Click the Voucher ID link to access the Voucher Inquiry page, where you can view more detailed information about the payments that make up this voucher.

Pymnt Nbr (payment number)

Displays the payment number for this scheduled payment. This is a system-generated number, not the payment reference number (that is, not a check number or its equivalent).

Scheduled to Pay

Displays the payment date scheduled for this payment.

Hold Payment

Displays as checked if there is a hold on the payment for this voucher.

(USF) IPAC Payment

Displays as checked if this payment is a payment to be processed through the U.S. Department of Treasury's IPAC system. This appears only if you are a U.S. federal agency.

See (USF) Processing PeopleSoft Payables for U.S. Federal Agencies.

Trans Currency (transaction currency)

Displays the type of currency that the transaction itself is in.

Display Gross Amount

Displays the gross amount, which appears in the converted currency. This field appears only if you select the Show Display Currency check box.

Display Currency

Displays the common currency in which the gross amount is calculated. This field appears only if you select the Show Display Currency check box.

Approval Status

Displays the approval status of the scheduled payment. Values are: Approved, Pending, and Denied.

Draft Sight Code

Displays the draft sight code that is associated with this scheduled payment.

Draft Scheduled Maturity Date

Displays the date on which the draft that is associated with this scheduled payment matures, if applicable.

Letter of Credit ID

Displays the letter of credit ID that is associated with this scheduled payment, if applicable.

Netting Reference ID

Displays the netting reference ID number that is associated with this scheduled payment, if applicable.

Total Display Gross Amount

Displays the gross amount, which appears in the converted currency. This field appears only if you select the Show Display Currency check box.

See Also

Establishing Pay Cycles

Processing Drafts

Letters of Credit

Managing Bilateral Netting

Click to jump to parent topicReviewing Payment Information

PeopleSoft Payables includes several inquiry pages and reports that enable you to examine the detail associated with your payments. The inquiry pages are just a starting point. You might find that you want to use PeopleTools to create additional inquiry pages that contain the data that you need organized in the manner that you desire.

This section describes how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Review Payment Information

Page Name

Definition Name

Navigation

Usage

Payment Inquiry

PYMNT_INQ_SRCH

Accounts Payable, Review Accounts Payable Info, Payments, Payment, Payment Inquiry

Search on payments using specific search criteria to create a list of detailed payment information or display a chart of payments by date.

Vouchers For a Payment

PYMNT_VCHR_DET_SEC

Click the Payment Reference ID link on the Payment Inquiry page.

View more detailed information about a payment voucher.

Replaced Payments

PYMNT_RPLCD

Accounts Payable, Review Accounts Payable Info, Payments, Replaced Payments

View those payments for which you have replaced the payment reference number. Payment reference numbers are replaced when you recreate checks in a pay cycle.

Scheduled Payments on Hold

VNDR_PAYINQ_HLD

Accounts Payable, Review Accounts Payable Info, Vendor, Scheduled Payments on Hold

View vouchers that are scheduled for payment, yet are on hold.

Overdue Scheduled Payments

VNDR_PAYINQ_OVRDUE

Accounts Payable, Review Accounts Payable Info, Vendor, Overdue Scheduled Payments

View vouchers that are overdue for a vendor.

Click to jump to top of pageClick to jump to parent topicReviewing Payment Information

Access the Payment Inquiry page (Accounts Payable, Review Accounts Payable Info, Payments, Payment, Payment Inquiry).

Note. Multiple views of this page are available by clicking the tabs in the scroll area. We document fields that are common to all views first.

Search Criteria

From Payment Date and To Payment Date

Enter to search for a payment that was issued on a particular date or in a range of dates. When you select the Show Chart option, these are required fields.

Payment Status

Select a specific payment status. Options are as follows: Alignment, Deleted, Escheated, Overflow, Paid, Pre-Note, Replaced, Same Ref (same reference), Stale, Stop, Undo, or Void.

Settle by

Select a settlement method of Gateway or Pay Cycle.

Settlement Status

Select a settlement status. Options are: Canceled, Error, Hold, Loaded, None, Paid, Received, or Send.

Schedule ID

Enter a schedule ID number to review payments in a payment schedule. This field only displays if you enable federal payment schedules.

Single Payment Vouchers

Select to limit returned results to only single payment vouchers.

Show Chart

Select this option to display a summary of payments by amount and currency chart. The paid amount can only be displayed in one currency, which is the payment currency. Clicking a bar on the chart displays the list of payments that are represented on the chart.

This option requires you to specify a date range in the From Date and To Date fields.

The dates cannot span more than 31 days.

Chart Type

Select what kind of chart you want to display. The options are: Bar Chart, Horizontal Bar, Horizontal Stacked Bar, Percentage Stacked Bar, and Stacked Bar. After the chart is displayed, you can change this option and click the Search button to display the new chart type.

 

Max Rows

Enter the maximum number of rows that you want to appear in the grid. The maximum number of rows displayed is determined after the search criteria is applied and after the sort criteria is applied.

Sorting Criteria

1st sort

Specify how your inquiry results will be sorted. The options are Account, Amount, Currency, Date, Paycycle, Pymnt Ref (payment reference), Remit Vndr (remit vendor), and Vendor.

Select whether the data is to be sorted in Descending order.

2nd sort

Select a field to sort by in the 2nd sort field for a more detailed sort within your first sort. Available choices are the same as for the first sort. Again, indicate whether the data is to be sorted in descending order.

Payment Details Tab

Payment Reference ID

Click the payment reference ID number to access the Vouchers For a Payment page, where you can view the vouchers that make up this payment.

Reconciliation Status

Displays whether the payment has been reconciled.

Reconcile Date

Displays the reconciliation date if the payment has been reconciled.

Additional Info Tab

Lists the post status, cancel status, pay cycle, and bank information associated with the payment.

Vendor Details Tab

Lists the vendor name and address associated with the payment.

Financial Gateway Tab

Lists summary information for payments settled through the Financial Gateway.

Payment Details

Click to access the Review Payment Details page and review settlement detail information.

See Also

Processing Document Sequencing in PeopleSoft Payables

Canceling Individual Payments

Click to jump to top of pageClick to jump to parent topicReviewing Payment Voucher Details

Access the Vouchers For a Payment page (click the Payment Reference ID link on the Payment Inquiry page).

Days Outstanding

Displays the number of days difference between the payment date and the due date for unreconciled payments. For reconciled payments, this is the number of days difference between the payment date and the payment clear date.

Value Date

Displays when the funds actually clear the bank.

Approved By

Displays the person who approves the pay cycle. This is for Federal only and is set at the Pay Cycle Certification page.

Approval Date

Displays the date the pay cycle was approved. This field only displays when you enable the Federal Payments feature.

Treasury Chk # (Treasury check number)

Displays the check number that the U.S. Treasury issued to pay an obligation on behalf of an agency. This can also represent an electronic payment number issued by the U.S. Treasury via electronic funds transfer. This field only displays when you enable the Federal Payments feature.

Voucher ID

Click to access the Voucher Inquiry page, where you can view details for this voucher.

Click to jump to top of pageClick to jump to parent topicReviewing Replaced Payments

Access the Replaced Payments page (Accounts Payable, Review Accounts Payable Info, Payments, Replaced Payments).

You must recreate checks in a pay cycle before using this page.

Old Payment Ref (old payment reference)

Displays the payment reference number that was changed.

New Payment Ref (new payment reference)

Displays the current payment reference number.

Click to access the Payment Inquiry page. Clicking this button next to the Old Payment Reference number transfers you to the Payment Inquiry page for that Reference number. Clicking this button next to the New Payment Reference number transfers you to the Payment Inquiry page for the current reference number.

See Also

Restarting Pay Cycles and Re-creating Checks

Click to jump to top of pageClick to jump to parent topicReviewing Scheduled Payments on Hold

Access the Scheduled Payments on Hold page (Accounts Payable, Review Accounts Payable Info, Vendor, Scheduled Payments on Hold).

Note. This page displays vouchers that are on hold, on hold for withholding, pending approval, or denied approval.

Vouchers

Displays the number of vouchers on hold for this vendor.

Scheduled Payment

Displays the ID of the payment that is on hold and whether full or partial payment will be made.

Scheduled to Pay

Displays the date that the payment is scheduled to be paid. This could be the Due Date, the Discount Due Date, or a more current date, if the voucher was entered after both of these dates.

See Also

Processing Withholding in PeopleSoft Payables

Click to jump to top of pageClick to jump to parent topicReviewing Overdue Scheduled Payments

Access the Overdue Scheduled Payments inquiry page (Accounts Payable, Review Accounts Payable Info, Vendor, Overdue Scheduled Payments).

Overdue scheduled payments must exist before you can access this page.

The fields on this page are similar to those on the Scheduled Payments on Hold page.

Vendor Payment Hold

Displays as selected if the vendor was placed on hold in the Vendor component (VNDR_ID).

Scheduled Payment Hold

Displays as selected if the scheduled payment was placed on hold in the Voucher component (VCHR_EXPRESS).

On Withholding Hold

Displays as selected if a withholding exception is generated during the Pay Cycle Application Engine process (AP_APY2015).

See Also

Reviewing Scheduled Payments on Hold

Click to jump to parent topicLocating Related Procurement Documents

With both PeopleSoft Payables and Purchasing installed, you can inquire and cross-reference related documents across the procure-to-pay business cycle, to tie all documents together for the same transaction flow. You have quick access to requisitions, purchase orders, receivers, and vouchers/payments associated with the requested voucher or payment ID. You can also see such things as post status, budget check status, match status, and gross amount.

This section describes how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Locate Related Procurement Documents

Page Name

Definition Name

Navigation

Usage

Voucher Document Status

PRCR_DOCSTAT_VCHR

Accounts Payable, Review Accounts Payable Info, Vouchers, Document Status, Voucher Document Status

Locate related documents starting from a voucher number.

Purchase Order Inquiry

PO_INQUIRY

Accounts Payable, Review Accounts Payable Info, Interfaces, Purchase Order

View purchase order and related documentation information.

Purchase Order Inquiry - Purchase Order

PO_LINE_INQ

Click the DOC ID (document ID) link for a Document Type of PO on the Voucher Document Status page.

View purchase order information associated with the voucher.

Payment Document Status Inquiry

PRCR_DOCSTAT_PYMT

Accounts Payable, Review Accounts Payable Info, Payments, Document Status, Payment Document Status Inquiry

Locate related documents starting from a payment number.

Click to jump to top of pageClick to jump to parent topicLocating Documents from a Voucher ID

Access the Voucher Document Status page (Accounts Payable, Review Accounts Payable Info, Vouchers, Document Status, Voucher Document Status).

Vendor ID

Click the View Related Links button to access the Vendor Information, Conversations, or Contact components (VNDR_ID, VNDR_CNVRSTN, or VENDOR_CONTACT, respectively).

Voucher ID

Click to access the Voucher Inquiry page in a separate browser.

Status

Click to access the Voucher Accounting Entries inquiry page in a separate browser. This link appears if the voucher posting status is Posted.

Document Tolerance Status

Click to access the Document Tolerance Exceptions page in a separate browser if the document tolerance status is Error.

Budget Misc Status (budget miscellaneous status)

Click to access the Voucher (NP) Exceptions page in a separate browser if the budget miscellaneous status is Error.

Budget Status

Click to access the Voucher Exceptions page in a separate browser if the budget status is Error.

Match Status

Click to access one of the Match Workbench pages in a separate browser. The inquiry you access is dependent on the voucher's match status. This link is only active for vouchers that require matching.

Documents Tab

DOC ID (document ID)

Click to go to the inquiry page for that document in a separate browser. You access an inquiry page related to the document type you select. For example, for a PO, you access the Purchase Order Inquiry - Purchase Order page, but for a receipt, you access the Receipts page.

Click to go to the Document Status Inquiry page for that document in a separate browser. For a PO, for example, it takes you to the PO Document Status page, which has links to related documents.

Related Info Tab

This tab appears only if the transaction was posted or if the related vouchers require matching.

Match Workbench

Click to access one of the Match Workbench pages in a separate browser. This link is only active for related vouchers that require matching. The inquiry you access is dependent on the related voucher's match status.

Accounting Entries

Click to access the Voucher Accounting Entries page in a separate browser. Payment accounting entries are based on vouchers. This link appears if the transaction was posted.

Reviewing Purchase Order Information

Access the Purchase Order Inquiry - Purchase Order page (click the DOC ID (document ID) link for a Document Type of PO on the Voucher Document Status page).

Access the Purchase Order Inquiry - Purchase Order page by clicking the DOC ID link for the Document Type of PO (purchase order).

See Also

Viewing Purchase Order Data

Click to jump to top of pageClick to jump to parent topicLocating Documents From a Purchase Order Number

Access the Purchase Order Information page (Accounts Payable, Review Accounts Payable Info, Interfaces, Purchase Order)

You can search for purchase orders by business unit or by business unit and PO number, PO date, Vendor ID or Vendor short name.

Click to jump to top of pageClick to jump to parent topicLocating Documents from a Payment ID

Access the Payment Document Status page (Accounts Payable, Review Accounts Payable Info, Payments, Document Status, Payment Document Status Inquiry).

Payment ID

Click to access the Payment Inquiry page in a separate browser instance.

Documents Tab

DOC ID (document ID)

Click to access the inquiry page for that document in a separate browser. For example, for a voucher, the system takes you to the Voucher Inquiry page.

Status

Click to access the Voucher Accounting Entries inquiry page in a separate browser. This link appears if the voucher posting status is Posted.

Vendor ID

Click the View Related Links button to access the Vendor Information, Conversations, or Contact components.

Click to access the Document Status Inquiry page for that document in a separate browser. For example, for a voucher, the system takes you to Voucher Document Status page.

Related Info Tab

This tab appears only if the transaction was posted or if the related vouchers require matching.

Match Workbench

Click to access one of the Match Workbench pages in a separate browser. This link is only active for related vouchers that require matching. The inquiry you access is dependent on the related voucher's match status.

Accounting Entries

Click to go to the Accounting Entries Inquiry page in a separate browser. This link appears if the transaction was posted.

Click to jump to parent topicReviewing Vendor Information

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Review Vendor Information

Page Name

Definition Name

Navigation

Usage

Vendor Aging

AP_VNDR_AGING

Accounts Payable, Review Accounts Payable Info, Vendor, Aging, Vendor Aging

Review the aging of different payments for a vendor or group of vendors.

Past Due Aging

MTRC_AP_PAST_AGING

Accounts Payable, Review Accounts Payable Info, Vendor, Past Due Aging Metric, Past Due Aging

Display and review past due payments by voucher status in the form of a list or chart.

Scheduled Due Aging

MTRC_AP_SCHD_AGING

Accounts Payable, Review Accounts Payable Info, Vendor, Scheduled Due Aging Metric, Scheduled Due Aging

Display and review scheduled due payments by voucher status in the form of a list or chart.

Vendor Current Balances

AP_VNDR_BAL

Accounts Payable, Review Accounts Payable Info, Vendor, Current Balance, Vendor Current Balances

Review the current payables balance for a vendor or group of vendors.

Click to jump to top of pageClick to jump to parent topicReviewing Vendor Aging

Access the Vendor Aging page (Accounts Payable, Review Accounts Payable Info, Vendor, Aging, Vendor Aging).

Search Criteria

Enter the search criteria for your inquiry. You can use any combination of the search criteria fields. You can search by single vendor ID, single vendor name, or a range of these values. Today's date appears by default in the As of Date field.

Display Currency Criteria

You can convert the currency that appears in the results region to one common currency. You can enter your display currency criteria either before or after you click the Search button. Enter the currency code of the type of currency in which you want your data to appear. This field is automatically populated from the operator preferences, but you can edit it. The system converts all of the payments shown to this currency. Select a rate type to convert the amounts that use the exchange rate for the type of currency that you selected. Select the Show Display Currency check box to view additional information about the converted amounts. If you have already generated your search, click the Convert button to convert the display of your results.

Note. The Convert button displays the converted currencies; it does not convert them.

Balance as of XX/XX/XXXX

Your inquiry results are broken down into these status categories: Approved Voucher, Unapproved Voucher, Negative Voucher, Hold Payment, Prepaid Voucher, and Draft Issued.

Note. The Prepaid Voucher row displays unapplied amounts of paid prepayment vouchers.

If your search retrieves no data for a status category, the results region of the page displays 0.00 in each amount field.

For payments that fall into more than one category, such as an unapproved negative voucher, the following hierarchy applies:

  1. Hold payments.

  2. Negative vouchers.

  3. Unapproved or approved vouchers.

In this hierarchy, 1 is the highest priority. For example, a negative voucher has a higher priority than an unapproved voucher, so a negative, unapproved voucher appears in the Negative Voucher column.

The columns in the following table refer to the scheduled date or maturity date of a voucher, payment, or draft

These fields display in the Past Due column.

Past Due: Over 60d

Totals in this column refer to items that are more than 60 days past their scheduled date or maturity date.

Past Due: 60 to 31d

Totals in this column refer to items that are 31 days or more (up to 60 days) past their scheduled date or maturity date.

Past Due: 30 to 1d

Totals in this column refer to items that are 1 to 30 days past their scheduled date or maturity date.

These fields display in the Schedule / Maturity Due column.

Schedule / Maturity Date: 0-30d

Totals in this column refer to items that are at their scheduled or maturity date or that have up to 30 days until their scheduled date or maturity date.

Schedule / Maturity Date: 31-60d

Totals in this column refer to items with 31 to 60 days before their scheduled date or maturity date.

Schedule / Maturity Date: Over 60d

Totals in this column refer to items with more than 60 days before their scheduled date or maturity date.

These fields display in the Total column.

Total

Total of all columns for each line.

Click the link in any cell containing your results to access the vendor Scheduled Payment Inquiry page, to view details for that value.

See Also

Reviewing Scheduled Payment Information

Click to jump to top of pageClick to jump to parent topicReviewing Past Due Aging

Access the Past Due Aging page (Accounts Payable, Review Accounts Payable Info, Vendor, Past Due Aging Metric, Past Due Aging).

This chart displays a summary of payments that are past due. Amounts that are to be paid are grouped by aging categories: 1 to 30 Days, 31 to 60 Days, and Over 60 Days. Click a bar on the graph to display the list of vouchers that are represented by that bar on the chart.

Transaction Currency

Select the currency code in which you want to display past due amounts on the chart. Amounts can only be displayed in the transaction currency. Only payments in the currency you select are shown in the chart.

Chart Type

Select the kind of chart you want to display. Options are: Bar Chart, Horizontal Bar, Horizontal Stacked Bar, Percentage Stacked Bar, and Stacked Bar. After the chart appears, you can change this option and click the Draw Chart button to display the new chart type.

Past due payments are categorized by the status of the vouchers from which they derive their amounts. The following categories have particular characteristics:

Click to jump to top of pageClick to jump to parent topicReviewing Scheduled Due Aging

Access the Scheduled Due Aging page (Accounts Payable, Review Accounts Payable Info, Vendor, Scheduled Due Aging Metric, Scheduled Due Aging).

This chart displays a summary of scheduled payments. Amounts that are to be paid are grouped by aging categories: 1 to 30 Days, 31 to 60 Days, and Over 60 Days. Click a bar on the graph to display the list of vouchers that are represented by that bar on the chart.

Transaction Currency

Select the currency code in which you want to display scheduled payment amounts on the chart. Amounts can only be displayed in the transaction currency. Only payments in the currency you select are shown in the chart.

Chart Type

Select what kind of chart you want to display. Options are: Bar Chart, Horizontal Bar, Horizontal Stacked Bar, Percentage Stacked Bar, and Stacked Bar. After the chart appears, you can change this option and click the Draw Chart button to display the new chart type.

Click to jump to top of pageClick to jump to parent topicReviewing Current Vendor Balances

Access the Vendor Current Balances page (Accounts Payable, Review Accounts Payable Info, Vendor, Current Balance, Vendor Current Balances).

Search Criteria

Enter the search criteria for your inquiry. You cannot search by both vendor ID and vendor short name. If you do not search by business unit, you must search by vendor ID or vendor short name. You can search by single vendor ID, single vendor name, or a range of these values. Today's date appears by default in the As of Date field.

Sort Criteria

To sort your results, select the field that you want to sort by, and select whether you want your inquiry sorted in ascending or descending order. Click the Sort button to generate the sort.

Display Currency Criteria

You can convert the currency that appears in the results region to one common currency. You can enter your display currency criteria either before or after you click the Search button. Enter the currency code of the type of currency in which you want your data to be displayed. This field is automatically populated from the operator preferences, but you can edit it. The system converts all of the payments shown to this currency. Select a rate type to convert the amounts by using the exchange rate for the type of currency that you selected. Select the Show Display Currency check box to view additional information about the converted amounts. If you have already generated your search, click the Convert button to convert the display of your results.

Note. The Convert button displays the converted currencies; it does not convert them.

Vendor Current Balances

Once you complete your inquiry, your results appear in this grid.

Short Vendor Name

Click to open the Scheduled Payment Inquiry page, for a breakdown of details for this vendor that is independent of the selected business unit and transaction currency.

Gross Amount

Click to open the Scheduled Payment Inquiry page, for a breakdown of details for this vendor by business unit and transaction currency.

Unapplied Prepayments

Displays the available balance of any paid, unapplied prepayments.

Note. Prepaid vouchers must be paid to appear here.

See Processing Prepayments.

Payable Balance

Displays the total balance of payments for each vendor.

Voucher Inquiry

Click the Voucher Inquiry button to access the Voucher Inquiry page, where you can view details about the vouchers payable to this vendor.

If the Show Display Currency check box is selected, the following additional columns appear:

Display Currency

Displays the type of currency that you requested that the balance amounts be shown in.

Display Gross Amount

Displays the gross amount in the converted currency.

The total of this column also appears at the bottom of the page.

Display Unapplied Prepayments

Displays the amount of unapplied prepayments in the converted currency.

Display Payable Balance

Displays the total payable balance for each vendor in the converted currency.

See Also

Reviewing Scheduled Payment Information