Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

The Fisherman ACH Page is used to configure Fisherman and Fisherman Loan Account Addresses to accept ACH Payments. ACH Payments can only be processed for account Address ID's that have been setup for ACH. The purpose of this page is to add, edit, and remove address id's for ACH.

Software Version: 2021.03.17 and newer

Page Header

Toolbar IconsDescription
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Cancel

Cancels the current unsaved changes and returns the view from Edit mode to Read only mode. This toolbar icon is only displayed when the view is in edit mode.

Delete Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted! 

Edit Puts the list view in edit mode allowing all editable fields to be modified at one time. To get out of edit mode you must either Cancel or Save your changes.
Excel Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 
Favorites Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Help Opens the online WIKI help page for the current page. 
New Inserts blank lines that allow adding multiple new records.
Process Prenote

Generates a .txt file with the bank account information for any selected Fishermen.  The 'SEC Code' must be set to a Prenote type in order to process a prenote for an account.  A 'Default Fisherman Checkbook ID' must be specified on the Preferences page in order to process a prenote, else the message "A default checkbook must be set in order to create a Prenote. Please navigate to Fisherman Accounting  Preferences → Settlement Defaults." will be displayed. Clicking the button will also populate the 'Prenote Sent’ field with the current date and time for the selected eligible Fishermen. Users will need to manually switch the Fisherman out of "Checking - Prenote" or "Savings - Prenote" after the Prenote file has been successfully processed by the bank.

(lightbulb) There is no limit to the number of times the Process Prenote button can be used for the same Fisherman. Users may resend the Prenote verification file when account details are updated provided the SEC Code is set to a Prenote Checking or Savings type.

For additional information on how prenotifications work, please click here.

Quick Filter
Error rendering macro 'excerpt-include' : No link could be created for 'Quick Filter'.
Save Saves all changes made on the page.
Saved Column Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records.
Account #

A text box to store the bank account number that the ACH payments will be deposited into. This defaults to blank, is required, and must be <= 100 characters. If missing, the message "[VendorID]: SEC Code, Bank, Name on Account, Routing # and Account # are required." will be displayed on Save. Note: the message is intended to show the complete list of all required, not just the missing ones. This field is always editable when the page is in edit mode.

(lightbulb) A partial Account Number is displayed by default. To view the entire Account Number, hover over the field.

Database Field: ERPx_APVendorACH.AccountNumber

Address ID

A single-select load on demand lookup to assign the Address ID that is being configured for ACH. This defaults to blank and is required. If not assigned, the message "You have Records that do not have an Address ID value selected." will be displayed on save. This field is only enabled when adding a new record, it is not editable for existing records. If you need to change the Address ID, you must delete the record and re-enter it correctly.

This lookup contains a blank value, the current assigned value, an option for ALL (only if the Fisherman has more than one Address), and a list of all the 'Active' Address ID's that belong to current Fisherman.

Database Field: ERPx_APVendorACH.VendorAddressSK 

Bank

A text box to identify the name of the financial institution where the account is held. This is required and must be <= 100 characters. If missing the message "[VendorID]: SEC Code, Bank, Name on Account, Routing # and Account # are required." will be displayed on Save. This field is always editable when the page is in edit mode.

Database Field: ERPx_APVendorACH.BankID 

Default Payee

A Yes/No lookup to identify whether or not the Address ID is the default address for Payments. This is a looked up value that is not editable from this page.

A value of "Yes" means that the Address ID is configured as the 'Payment Default' on the Fisherman master file. A blank value means that the Address ID is not configured as the 'Payment Default'

Database Field: ERPx_APVendorACH.IsRemitToAddress where IsRemitToAddress = 1

Default Payment Type

A single-select standard lookup to assign the preferred method of payment for each Address ID. This allows an Address ID to receive Checks but still have an option to process as ACH when needed.

This defaults to Check which is required to process a Prenote for the account and can then be updated to ACH after Save if needed.  This is required and is always editable when the page is in edit mode.

This lookup contains two values: 'Check' and 'ACH'.

Database Field: ERPx_APVendorAddress.DefaultPaymentTypeSK 

Name on Account

A text box to store the name of the bank account that the ACH payments will be deposited into. This defaults to blank, is required, and must be <= 250 characters. If missing, the message "[VendorID]: SEC Code, Bank, Name on Account, Routing # and Account # are required." will be displayed on Save. Note: the message is intended to show the complete list of all required, not just the missing ones. This field is always editable when the page is in edit mode.

Database Field: ERPx_APVendorACH.AccountName

Prenote Sent

Identifies the date and time the prenote verification file is generated. If the 'SEC Code' is set to "Checking - Prenote" or "Savings - Prenote" and this field is not populated, then the user knows they have not attempted a prenote verification. This is a non-editable text box that is not required. It defaults a blank. It is a system assigned value for information only and is never editable.

Database Field: ERPx_APVendorACH.PrenoteSentDate

Routing #

A text box to store the routing number for the bank that the ACH payments will be deposited into. This defaults to blank, is required, must be a valid routing number, and must be <= 25 characters. If missing, the message "[VendorID]: SEC Code, Bank, Name on Account, Routing # and Account # are required." will be displayed on Save. Note: the message is intended to show the complete list of all required, not just the missing ones. If the routing number is not valid, the message "[VendorID]: Invalid Routing Number ([current routing number value])" will be displayed on Save. This field is always editable when the page is in edit mode.

Database Field: ERPx_APVendorACH.RoutingNumber

SEC Code

A single-select standard lookup to assign what type of ACH transaction the account is configured for. This defaults to blank but is required.  The only options that are available on a New record initially are 'Checking - Prenote' and 'Savings- Prenote'.  If not assigned, the message "[VendorID]: SEC Code, Bank, Name on Account, Routing # and Account # are required." will be displayed on Save. will be displayed. Note: the message is intended to show the complete list of all required, not just the missing ones. If this field is set to "Savings - Prenote" or "Checking - Prenote", then the 'Default Payment Type' cannot be set to "ACH". Else the message "Default Payment Type cannot be set to ACH when the SEC Code is a Prenote type." will be displayed on Save.  This field is always editable when the page is in edit mode.

This lookup contains all the values in the ACHAccountType Enumeration Class. On new rows, the "Checking" and "Savings" options will not be available until the record has been saved.

Database Field: ERPx_APVendorACH.ACHAccountTypeEN

Vendor

A single-select load on demand lookup to assign the Fisherman / Loan account that is being configured for ACH. This defaults to blank and is required. If not assigned, the record will be cancelled on Save. This field is only enabled when adding a new record, it is not editable for existing records. If you need to change the Fisherman, you must delete the record and re-enter it correctly.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' APVendors with a VendorTypeEN <>1 

Database Field: ERPx_APVendorACH.VendorSk

Vendor Class

A label to identify the the Vendor Class property of the Fisherman that is assigned. This is a looked up value that is not editable from this page.

Database Field: ERPx_APVendor.VendorClassSK

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels