Home > Financial Systems > PeopleSoft Financials > Accounts Payable > Queries

Queries

Download an Excel spreadsheet containing the current AP run-only queries. 
 
03/27/2003 - AP - Updated Queries
Added to the list of AP Queries:

• 0AP005H_VERIFY_EXP_BY_FUND

Added to the list of AP Queries:

• 0SP026_PO_List_by_5_Digit_NIGP
• 0AP053_VNDRS_RANKED_BY_PYMNTS

10/25/2002 - AP - Updated Queries
Added to the list of AP Queries:

• 0AP034B_PAID_VCHR_BY_RECIP

09/27/2002 - AP - Updated Queries
Added to the list of AP Queries:

• QRY0834, 0AP052_VCHRS_BY_PAYMENT_REF (New)

08/02/2002 - AP - Updated Queries
Added to the list of AP Queries:

• AP è 0AP034B_PAID_VCHR_BY_RECIP (New)

06/28/2002 - AP - Updated Queries
Added to the list of AP Queries:

• AP è 0AP007_DELETED_VOUCHERS
  (Modified)
  Added OPERID_LAST_UPDT
• 0AP018_CLOSED_VOUCHERS
  (Modified)
  Added LAST_UPDATE_DT & OPRID_LAST_UPDT

05/03/2002 - AP - New Query
Added to the list of AP Queries:

• 0AP051_Payment_Cancellation

04/25/2002 - AP - New and Modified Query
Added to the list of AP Queries:

• 0AP005G_VERIFY_EXP_BY_PROJECT (New)
• 0AP014_VOUCHERS_ON_HOLD (Modified)

04/01/2002 - AP - New Query
Added to the list of AP Queries:

• 0AP037_VOUCHERS_CREATED_W_$0_AMT

03/25/2002 - AP - New Query
Added to the list of AP Queries:

• 0AP021B_ADJUST_VCHRS_ BY_ PERIOD

This query lists all Adjustment Vouchers which were created, paid, voided, or closed for the requested Accounting Period. This query will include Adjustment Voucher number, vendor, voucher line amount, distribution line amount, and related voucher number. This query will prompt on Business Unit, Fiscal Year, Accounting Period From and Accounting Period Thru.

03/15/2002 - AP - New Query
Added to the list of AP Queries:

• 0AP021B_ADJUST_VCHRS_ BY_ PERIOD

01/18/2002 - AP - New Query
Added to the list of AP Queries:

• 0AP035_BUDGET_OVERRIDE_BY_USER

11/09/2001 - AP - New Query
Added to the list of AP Queries:

• 0AP004_VERIFY_CASH_DISB

11/02/2001 - AP - New Query

A new query named the 0AP034_PAID_VCHR_INCL_RECIP has been created. This query can be used with the APXXX0419 Travel Expense Report and the APXXX0420 Per Diem and Expense Report to identify paid voucher info for a 3rd party recipient vendor. The Vendor ID entered on prompt box will display paid voucher info for 3rd party Recipient Vendor ID and Remit Vendor ID. The query will include Voucher ID, Recipient, Vendor Name, Account Number, Reference Number, Payment Date and Accounting Date. An asterisk in the Recipient Column will denote that Vendor belongs to a 3rd party Recipient Voucher.

This query will prompt on Business Unit, Vendor ID, Payment Date From and Payment Date Thru. The 3rd party Recipient Vendor ID should be entered on the Vendor ID prompt box.

09/28/2001 - AP - New Queries

Effective September 28, 2001, the following new queries have been created:

• 0AP005D Verify_Exp_by_Sub-Class
• 0AP005E Verify_Exp_by_Organization
• 0AP005F Verify_Exp_by_Program
  

Each of these queries will provide a listing of expenditures by Sub-Class, Organization, or Program for the specified time frame.

Each query prompts on Business Year, Fiscal Year, Accounting Period From, Accounting Period Thru, for the query type chosen (Sub-Class, Organization, or Program).

These queries can assist users with balancing like the original AP005 Verify Expense query.

09/04/2001 - AP - New Query Created

Effective August 27, 2001, a new query, 0AP033_OUTSTND_PY_W/INACT_VND, has been created. This query will list open payable vouchers with an "Inactive" Remit to Vendor status by Business Unit. This query will list the Voucher ID, Invoice Number, Remit Vendor Number, Remit Vendor Name, Remit Vendor Name 2, Gross Amount, Schedule Due Date and the Payment Count. The Payment Count number will allow users to determine if multiple payments exist for a voucher. Payable vouchers that are on Hold will not appear on this query. The purpose of this query is to determine why a voucher cannot be paid.

08/06/2001 - AP - New Query Created

Effective August 3, 2001 a new query, 0AP032_PAYABLES_WITH_DISC_AMT, has been created. This query lists all open payable vouchers with a discount by business unit. It lists the Schedule Due Date and the Discount Due Date to allow users to make adjustments to the dates, as needed, to meet the discount terms. By evaluating the Discount Due Date and the Schedule Due Date, users can also determine if they have lost a discount for a payable. The query also lists the gross amount, amount of the discount, bank/ bank account and vendor information.

When evaluating the dates, users should keep in mind that payment processing in overnight batch can occur after midnight, which can determine whether a discount is lost.

The following example will illustrate how discounts may be lost if the Schedule Due Date and the Discount Due Date on the voucher are the same.

Example: Schedule Due Date = 07/11/01

• Discount Due Date = 07/11/01
• Paycycle Requested on 07/11/01
  • Pay Thru Date on the Paycycle = 07/15/01
  • Payment processing begins at 12:30AM on 07/12/01 (after midnight on 07/11/01)
  • PeopleSoft assigned Payment Creation Date = 07/12/01
• The discount was lost.
  

One way to prevent losing a discount is to change the Schedule Due Date on the voucher to a date at least two (2) days earlier than the Discount Due Date. A paycycle should then be requested to select the voucher for payment.

Example: This query is available

• Today is 07-09-01
• View query results and one of the vouchers has:  Schedule Due Date = 07/11/01
• Discount Due Date = 07/11/01
• To prevent possibly losing discount change
• Schedule Due Date on voucher to 07/09/01
• Paycycle Requested on 07/09/01
• Pay Thru Date = 07/09/01
• Payment process begins on 07/10/01 at 12:30 am
• PeopleSoft Payment Creation Date = 07/10/01
• The Discount is taken on this payment.

 
08/03/2001 - AP - New Query Created
The List of AP queries now includes:

• 0AP032_Payables_With_Disc_Amt

07/02/2001 - AP - New Query Created
The List of AP queries now includes:

• 0AP014_VOUCHERS_ON_HOLD

06/29/2001 - AP - New Query Created

Effective June 29, 2001, a new query has been created called the 0AP030_AP_PO_OPERATOR_ORGINS. This query will list the Accounts Payable and/or Purchasing origins established for each operator within a business unit.

06/25/2001 - AP Information - New Query Created

Effective today, a new query (0AP029B_OUTSTND_PY_W/O_$0_VCHR) has been created to provide a list of all open payables for each liability account without the zero dollar adjustment vouchers. This query is identical to the 0AP029_OUTSTND_PY_W/O_$0_VCHRS query except the 29B version includes distribution line information and distribution line amounts. To determine the Voucher Gross Amount, sum all the distribution lines per voucher. In Excel, perform the Subtotal function - At each change in: Voucher, Use Function: Sum, At Subtotal to: Amount.

This query will list vouchers with a positive or negative gross amount only. The query will prompt by Business Unit, Account From and Account Thru. A liability account should be entered.

06/05/2001 - Open Payables

Effective June 04, 2001, a new query, 0AP029_OUTSTND_PY_W/O_$0_VCHR, has been created to provide a list of all open payables for each liability account without the zero dollar adjustment vouchers. This query lists vouchers with a positive or negative gross amount only. The query will prompt by Business Unit, Account From and Account Thru. A liability account should be entered.

06/05/2001 - Run-only Queries

Download an Excel spreadsheet containing the current AP run-only queries.