Select Transactions Fields

Filter criteria

Key: R – Read-only in all contexts

Field		Options*	Description
Due Date		To, From‑To	Use the To date to retrieve only those transaction lines that are due up to and including that date. Combining this with an optional From date retrieves all transaction lines that are due between (and including) those two dates.
Payment Method		Equals, Multi-select	Check, Electronic, Cash and None. Only those accounts that have a payment method that matches this filter are retrieved. Remove the default payment method and leave it blank to include all accounts regardless of the payment method set on the vendor’s account record. Choose "None" if you only want to retrieve those accounts that do not have a payment method defined.
Accounts Payable Control GLA		Multi‑select, Contains, From‑To	Only those transaction lines with a GLA that matches this filter are retrieved. Use this filter if you run multiple purchase ledgers with different accounts payable control GLAs. You may leave this field blank. In this case, the app retrieves both sales and payable transaction lines. You won't be able to pay the sales lines, but you can see how much you owe them. All transactions that you select for a vendor account must share the same GLA, and this must be the same as the Accounts Payable GLA for that account. This GLA is used when the payment's cash entry is posted.
Vendor Name		Multi‑select, Contains, From‑To	Only those transaction lines with a vendor (account) name that matches this filter are retrieved. A vendor only appears on this list if an Accounts Payable Control GLA is set on the corresponding account record. This field cannot be used to filter if platform encryption is enabled. It is hidden.
Vendor Invoice Number		Equals, Contains, From‑To	Only those transaction lines with a vendor invoice number that matches this filter are retrieved.
Payable Invoice Number		Equals, Contains, From‑To	Only those transaction lines with a payable invoice number that matches this filter are retrieved.
Document Currency	R		Only transaction lines where the document currency is the same as the payment currency will be retrieved. If you want to change this, you must go back to the Payment Details page and amend the payment currency. You cannot change the document currency after transactions have been added to the payment proposal. You cannot pay in account currency in this version of Payments Plus.

Field

Options*

Description

Due Date

To, From‑To

Use the To date to retrieve only those transaction lines that are due up to and including that date. Combining this with an optional From date retrieves all transaction lines that are due between (and including) those two dates.

Payment Method

Equals, Multi-select

Check, Electronic, Cash and None.
Only those accounts that have a payment method that matches this filter are retrieved.
Remove the default payment method and leave it blank to include all accounts regardless of the payment method set on the vendor’s account record.
Choose "None" if you only want to retrieve those accounts that do not have a payment method defined.

Accounts Payable Control GLA

Multi‑select, Contains, From‑To

Only those transaction lines with a GLA that matches this filter are retrieved.
Use this filter if you run multiple purchase ledgers with different accounts payable control GLAs.
You may leave this field blank. In this case, the app retrieves both sales and payable transaction lines. You won't be able to pay the sales lines, but you can see how much you owe them.
All transactions that you select for a vendor account must share the same GLA, and this must be the same as the Accounts Payable GLA for that account. This GLA is used when the payment's cash entry is posted.

Vendor Name

Multi‑select, Contains, From‑To

Only those transaction lines with a vendor (account) name that matches this filter are retrieved.
A vendor only appears on this list if an Accounts Payable Control GLA is set on the corresponding account record.
This field cannot be used to filter if platform encryption is enabled. It is hidden.

Vendor Invoice Number

Equals, Contains, From‑To

Only those transaction lines with a vendor invoice number that matches this filter are retrieved.

Payable Invoice Number

Equals, Contains, From‑To

Only those transaction lines with a payable invoice number that matches this filter are retrieved.

Document Currency

Only transaction lines where the document currency is the same as the payment currency will be retrieved. If you want to change this, you must go back to the Payment Details page and amend the payment currency.
You cannot change the document currency after transactions have been added to the payment proposal.
You cannot pay in account currency in this version of Payments Plus.

* described in the following table:

Option	Description
Multi–select	Use to select one or more items from a picklist.
Equals	Use to find an exact match.
Contains	Use to retrieve items that contain a particular string.
From-To	Use to retrieve items within a range.

Option

Description

Multi–select

Use to select one or more items from a picklist.

Equals

Use to find an exact match.

Contains

Use to retrieve items that contain a particular string.

From-To

Use to retrieve items within a range.

Tip:

If you find retrieval by using a particular filter field is slow, your administrator can ask Salesforce to add a custom index to that field. This could improve performance.

Selection grid

When you click Retrieve Transactions, a selection grid is displayed. For information on how to use this grid, see Filtering and Retrieving Transactions. The list is sub-divided by vendor account.

The default columns are described here, but you can remove some columns or add new ones. See Customizing the Select Transactions Grid for more information.

Column	Notes
Document Number	Lookup to the originating document
Vendor Document Number	Number of the document sent by the vendor.
Transaction Number	Lookup to the related transaction.
Due Date	Date the payable document is due for payment.
Discount	The available discount calculated for the discount date you entered on the Payment Details page. Includes a discount total, summarized by account and for the whole grid.
Outstanding Value	The outstanding value on each transaction line. Includes an outstanding value total, summarized by account and for the whole grid.
Payment Value	The outstanding value minus the discount. Includes a payment value total, summarized by account and for all selected lines. You cannot remove this column from the grid.

Column

Notes

Document Number

Lookup to the originating document

Vendor Document Number

Number of the document sent by the vendor.

Transaction Number

Lookup to the related transaction.

Due Date

Date the payable document is due for payment.

Discount

The available discount calculated for the discount date you entered on the Payment Details page.
Includes a discount total, summarized by account and for the whole grid.

Outstanding Value

The outstanding value on each transaction line.
Includes an outstanding value total, summarized by account and for the whole grid.

Payment Value

The outstanding value minus the discount.
Includes a payment value total, summarized by account and for all selected lines.
You cannot remove this column from the grid.

Buttons

Button	Description
Add to Proposal	Adds the selected transaction lines to the payment proposal. This button is only enabled while there are items selected in the grid.
Back	Go back to the Payment Details page. Any transactions you've already added to the payment proposal are retained.
Back to Payments Home	Go back to the Payments Home page. Any transactions you've already added to the payment proposal are retained.
Clear All	Clears all optional filters and the selection grid. Only the payment currency filter will remain in force.
Hide/Show Filters	Hides and shows the filter criteria pane. You retain visibility of the applied filters as described in Filtering and Retrieving Transactions.
Next	Move on to the next stage of the process.
Retrieve Transactions	Retrieves transactions in accordance with the current set of filters.

Button

Description

Add to Proposal

Adds the selected transaction lines to the payment proposal. This button is only enabled while there are items selected in the grid.

Back

Go back to the Payment Details page. Any transactions you've already added to the payment proposal are retained.

Back to Payments Home

Go back to the Payments Home page. Any transactions you've already added to the payment proposal are retained.

Clear All

Clears all optional filters and the selection grid. Only the payment currency filter will remain in force.

Hide/Show Filters

Hides and shows the filter criteria pane. You retain visibility of the applied filters as described in Filtering and Retrieving Transactions.

Move on to the next stage of the process.

Retrieve Transactions

Retrieves transactions in accordance with the current set of filters.

Related Concepts

Payments Plus Overview

The Payment Proposal Side Panel

Payment Media

Asynchronous Batch Jobs

Related Tasks

Creating a New Payment Proposal

Filtering and Retrieving Transactions

Selecting Transactions to Pay

Reviewing the Proposal

Preparing Checks

Post and Match

Viewing the Payments Plus Error Log