Accounts Payable - Vendor Account Detail Query

Pgm: APACCQRY – Vendor Account Detail Query; standard Treeview path: Accounts Payable > Queries > Vendor Account History

The Accounts Payable Vendor Account Detail Query screen is used to perform detailed vendor account queries. The first section allows the operator to query vendor accounts by vendor code, vendor name, or terms. After entering the age date and cut off date, the relevant transactions against the vendor’s account, making up the vendor’s balance, appear in the Vendor Account Details section. The Company field can be left blank in order to query vendor details across multiple companies.

Selection Criteria

This section’s fields are used to filter the list of vendor accounts displayed in the Vendor Account Details section.

Company

Select relevant company or leave blank to view account details for the selected vendor across all companies in the system.

Vendor

Enter/select a vendor code.

Terms

This is a display-only field displaying the payment term associated with vendor.

Age Date

Enter/select date. Aging of vouchers will be as of this date.

Detail After Date

Enter/select date. Detail will be shown only for voucher dates which are on or after this date.

Include Zero Balances

If checked, zero balances will be included.

Query Data

Press this button to run the query. If one of the parameters is changed, click this button again to refresh the list.

Vendor Account Details

This section lists the vouchers making up the vendor’s balance, according to the parameters entered in the Selection Criteria section. The following provides details about the columns in the table of records.

Comp

Company under which voucher was entered.

Source Num

Identifying number of transactions. For example, if the transaction was made via a voucher, this number would be the voucher’s invoice number.

For Source

PO or contract number.

Source Date

Voucher’s invoice date.

Due Date

Voucher’s due date.

Net Amount

Voucher’s net amount.

Balance

Voucher’s balance.

Age

Difference, in days, between the age date (in Selection Criteria section) and the source date.

Under this section’s table, display-only fields provide details about the selected voucher. The Type field indicates what type of transaction has been processed against the vendor's account:

• V - Posted voucher

• C - Posted automatically generated check

• M - Posted memo

• D - Draft indicates a payment in foreign currency

• Q - Posted manual check

• T - Deposits (posted pre payments)

• Z - Posted manual check not associated with a vendor invoice

Under the initial set of display-only fields is a second set of display-only fields displaying vendor’s account aging summary and account totals.