Generate Pre-Note ACH File / Generate Direct Deposit ACH File

Bank Code to Use for Pre-Note Entries

Enter the bank code to use for any pre-note entries that have not yet been processed, or click the Lookup button to list all bank codes. The unprocessed pre-note entries will be added to the ACH files to be submitted to the bank for approval.

This field defaults to the first approved bank code set up in Direct Deposit Maintenance. Leave this field blank if you do not want to include any pre-note entries that have not yet been processed.

Click List ACH Files to open Windows File Explorer and view previously created ACH files. File Explorer opens to the folder entered in the Path for Direct Deposit File field in Payroll Options.

 

File Code to Use this Run

Type a code to use as part of the file name when the ACH files are created. The ACH file name consists of the bank code, the file code entered in this field, and the sequence number; and it has a .ach file extension. This field defaults to the current month and day, but it can be changed.

 

Batches to Include in Transmission

Select an option to determine which batches are included in the ACH files.

• Select All Batches to process all entries regardless of whether they have previously been added to an ACH file.

• Select Only Batches Never Transmitted to process only those entries that have never been added to an ACH file.
• Select Only Batches Previously Transmitted to process only those entries that have previously been added to an ACH file.

Note The transmission date is the date on which existing ACH files were created. It may be different than the run date, effective date, or descriptive date.

 

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.   Entering a range of account numbers produces different selection results than entering a range of main accounts and segments. When you specify a range of account numbers, all account numbers in that range are selected. When you specify a range of main accounts, all accounts beginning with the specified main account numbers are selected. Main account selections override account number selections.   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.

Multiple values can be entered using a comma (,) to enlarge the selection criteria. You can also use alternate separators (other than the reserved comma) to separate multiple selection values.

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").

 

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.

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").

 

Printer/Output

Select a printer or output method. The following output methods are available:

• Select Deferred to save the report or listing to your hard drive for printing at a future time using Deferred Printing.

• Select Export to export to a file type, such as PDF or Excel. The file can then be saved to your hard drive.

• Select Data Only Export to export only the data portion of the report (excluding header information) to a file type, such as PDF or Excel. The file can then be saved to your hard drive or e-mailed.

  Note This option is available only if the report or listing contains header information.

• Select Office Merge to export data to a Microsoft Word or Excel template. For more information, see Office Template Manager.

• Select Paperless Office to e-mail, fax, or print the report as a PDF document. When you select this option and click Print, the Paperless Office Selection window appears and allows you to define recipient and message options.