Payment History Summary (Inquiry)

Additional Information

Inquiries

The Payment History Summary Inquiry allows you to view a summary of posted historical payment transactions to Employees and Vendors for a given date range. The inquiry provides two levels of information, which include the payment history summary and payment tax return detail.

Restrictions

The inquiry includes the following default restrictions:

Restriction		Description
	From Payment Date	Enter or select a beginning document date. This is the first date in the date range to include all items.
	To Payment Date	Enter or select an ending document date. This is the last date in the date range to include all items. This field defaults to the current date.
	Payee	Enter or select an employee or vendor whose data is to be retrieved.
	Bank Account	Enter or select a bank account.
	Currency Type	Enter or select the type of currency to display on the inquiry. This field defaults to Document Currency, but available options include Base Currency, Company Currency, and Document Currency.

For a list of the optional restrictions, see Payment History Summary Inquiry Optional Restrictions.

The following optional restrictions are available:

Cash Organization
Currency
Document Type
Employee Company
Employee Location
Employee Organization
Employee Status
Payee Type

Payment Amount
Payment Generation Document Number
Payment Number
Source Company
Vendor Alternate Name
Vendor Parent
Vendor Type
Voided

Results

The inquiry results include the following levels of information:

Payment History Summary: The first level of the inquiry provides payment control information, which includes Payee Name, Payment Date, Payment Number, and Payment Amount. The initial view is grouped by Source Company Code, Payee Name, Payment Date, Payment Number, and Payment Amount. Payment History Summary Optional Columns.

The following optional columns of information are available:

Bank Account Code
Bank Account Name
Currency
Discount Taken
Document Suffix Code
Document Suffix Name
Document Type
Employee Company Code
Employee Company Name
Employee Organization Code
Employee Organization Name
Employee Status
Financial Description
Payee City
Payee Code
Payee Country
Payee State / Province

Payee Street
Payee Type
Payee Zip / Postal Code
Payment Generation Document Number
Payment Posting Date
Payment Routing Code
Payment Routing Name
Payment Void Document Number
Source Company Code
Source Company Name
Tax Amount
Vendor Alternate Name
Vendor Parent Code
Vendor Parent Name
Vendor Type
Voided
Withholding Amount

Payment History Detail: The next level of the inquiry provides payment Tax return codes and amounts, which includes Payment Return Type, Payment Return Code, and Payment Return Amount. Payment History Detail Optional Columns.