Invoice Payment Selection - Fields

 

Invoice Payment Selection

Select By

Select an option to determine which invoices to pay.

  • Select Discount Due Date Only to pay invoices with the discount due dates entered in the Select Field Discount Due Date field.
  • Select Invoice and Discount Due Dates to pay invoices that are due on or before the date entered in the Invoice Due Date field and invoices with the discount due dates entered in the Select Field Discount Due Date field.
  • Select Invoice Due Date Only to pay invoices that are due on or before the date entered in the Invoice Due Date field.

 

Invoice Due Date

Enter the invoice due date to pay, or click the Calendar button to select a date from the calendar. Invoices due on or before the date entered are selected for payment. This field is available only if Invoice Due Date Only or Invoice and Discount Due Dates is selected in the Select By field.

 

Always Take Discounts

Select this check box to deduct discounts for all invoices selected, regardless of the discount due date; discounts are also taken when the invoice discount due date is earlier than the date entered in the Discount Due Date field. Clear this check box to take discounts only if the discount due date is on or after the date entered in the Discount Due Date field. This field is available only if Invoice Due Date Only or Invoice and Discount Due Dates is selected in the Select By field.

 

Discount Due Date

Enter the discount due date, or click the Calendar button to select a date from the calendar. Discounts are taken if the invoice discount due date is on or after the date entered. Typically, the discount date is several days earlier than the invoice due date. This field is available only if Invoice Due Date Only or Invoice and Discount Due Dates is selected in the Select By field and the Always Take Discounts check box is cleared.

 

Pay Retention Balance

Select this check box to pay the full invoice including any outstanding retention. Clear this check box to pay the invoice balance minus any retention.

Select this check box only if a job number is selected. If this check box is selected, any invoice with retention and/or retention balance that falls within the invoice or discount due date is selected for payment.

This field is available only if the Accounts Payable module is integrated with Job Cost.

 

Include Electronic Payment Vendors

Select an option to determine whether invoices for electronic payment vendors are included.

  • Select No to exclude invoices for electronic payment vendors.
  • Select Only to select invoices for electronic payment vendors only.
  • Select Yes to include invoices for electronic payment vendors along with invoices for vendors that are paid by check.

Note If the Electronic Payment check box is selected for a vendor in Vendor Maintenance, and the Pre-Note Sent field is set to an option other than Approved for the vendor's bank account in the Vendor Electronic Payment window, the vendor's invoices will be selected if you select Only or Yes in this field; however, the vendor will be paid by check. In this case, a message on the Invoice Payment Selection Listing will indicate that the vendor will be paid by check.

This field is available only if the Enable ACH Electronic Payments check box is selected in Accounts Payable Options.

 

Pay Electronic Payment Vendors by Check

Select this check box to pay electronic payment vendors by check instead of electronic payment. Clear this check box if you do not want to pay electronic payment vendors by check.

This field is available only if the Enable ACH Electronic Payments check box is selected in Accounts Payable Options, and if Only or Yes is selected in the Include Electronic Payment Vendors field.

 

Operand

Select an operand to limit your selection to a particular value or range of values. When selecting a value using the Lookup button or entering a value directly into the Value field (and moving out of the field), the operand automatically changes to Equal to. Likewise, when selecting a value using the Lookup button for a range or entering values directly into both Value fields, the operand automatically changes to Range.

The following operands are available:

Operand

Operand Function

All Selects all information for the Select Field.
Begins with Selects only the information for the Select Field that begins with the value entered in the Value field.
Ends with Selects only the information for the Select Field that ends with the value entered in the Value field.
Contains Selects only the information for the Select Field that contains the value entered in the Value field.
Less than Selects only the information for the Select Field that is less than, but not equal to, the value entered in the Value field.
Greater than Selects only the information for the Select Field that is greater than or equal to the value entered in the Value field.

Range

When Range is selected, two Value fields are used. Information is selected that is greater than or equal to the first value entered and less than or equal to the second value entered in the Value fields.


Note Entries in the "From" Value field may change to the entry made in the "To" Value field, if the "From" Value contains a lowercase letter and the "To" Value contains an uppercase letter. This occurs because lowercase letters are greater than uppercase letters. For example, if 01a is entered in the "From" Value field and 01C is entered in the "To" Value field, the "From" Value field changes to 01C.

Equal to

Selects only the information for the Select Field that is equal to the value entered in the Value field.

Not Equal to

Selects only the information for the Select Field that is not equal to the value entered in the Value field.

 

Additional operands are available for date Select fields. The system date is used to calculate the date ranges. When one of the date operands is selected, the Value fields automatically default to the appropriate dates.

You can use commas (,) to separate multiple values; however, if your selection values already contain commas, you must use alternate separators to separate them.

Note When alternate separators are used, the value list must end with the alternate separator character.

The alternate separators include the following:

~ ! @ # $ % ^ & * ( ) = [ ] \ ; " / _ + { } | : < > ?

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").

If your company uses commas in item codes, use an alternate separator to select one or multiple item codes.

 

Value

Enter a value based on the operand entered, or click the Lookup or Calendar button to select a value from the list. Multiple values can be entered by using a comma or alternate separators to separate values.

For customer number, vendor number, and item code select fields, you can start typing a customer name, vendor name, or item description to locate a record. As you type, a list of records matching your entry appears. You can then select a record from the list.

Note If Country Code is an option in the Select field, and your source documents have no value in the Country Code field, the default Country Code entered in Company Maintenance is used as selection criteria for those documents.

You can enter single or multiple values as follows:

Operand

Value

All Selects all information for the Select Field.

Begins with

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Ends with

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Contains

Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Less than Only single values are allowed.
Greater than Only single values are allowed.
Range Both Value fields are used to define a range. Only single values are allowed at each Value field.
Equal to Multiple values are separated by a comma or alternate separator. An OR condition is assumed.

Not Equal to

Multiple values are separated by a comma or alternate separator. An AND condition is assumed.

Note If you enter a value that contains a comma (for example, if a vendor number is 01-SAGE,WEST), then you must enclose the value with an alternate separator (for example, %01-SAGE,WEST%). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").