ACH (Automated Clearing House) is a network used for electronically moving money between bank accounts across the United States. It's run by an organization called Nacha (previously NACHA - National Automated Clearing House Association), and may also be referred to as the ACH network or ACH scheme.

The purpose of this inquiry is to view ACH Batches that have been created from Accounts Payable and/or Fisherman Accounting and to generate/re-generate the ACH Text file that gets sent to the bank. The records are grouped by the Checkbook the payments were issued against.

Software Version: 2023.08.31 and newer

Page Header

Toolbar Icons	Description
Excel	Export the contents of the list view 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 only the filtered contents 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. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
Generate ACH File	Generates (or re-generates) an ACH text file for each of the record(s) selected. The file(s) can be downloaded and or uploaded to the bank. To help ensure the ACH text files are not rejected by the bank, a warning message will appear if any of the ACH Batches selected contains a "Payment Date" that occurs in the past or on a weekend. This message can be ignored, and the text files will be generated, or the user can use Mass Update to edit the 'Effective Date' to a different date. Changing the 'Effective Date' only impacts the ACH text file, the 'Payment Date' that was initially used for posting the payments remains the same.
Grid Layout	Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). The bolded view is the default view, which will determine the view will automatically display in when opened.
Help	Opens the online WIKI help page for the current page. This icon is only visible on pages that are documented in the online help.
Inquiry Criteria	Opens Inquiry Criteria window where users can define the following criteria: Checkbook Show Batches with Generated ACH Files If "No" (default), ACH Batches that have generated an ACH File will be excluded. If "Yes", ACH Batches that have generated an ACH File will be included. Date From Date To
Mass Update	Opens the mass update dialog, which allows to mass update the following properties: ACH Effective Date: The ACH Effective Date is the data that will be submitted to the bank as the Payment Date in the ACH text file. This is the date that the funds "should" leave your account and be sent to the recipient. This defaults from the 'Payment Date' used when the payments were posted but can be changed in the event the 'Payment Date' occurred in the past, on a holiday, or on a weekend.
Fields	Description
Checkbox	Used to select one or more records for Mass Update or Delete.
ACH File Generated	A Yes/No field to identify whether an ACH text file has ever been created for the Batch. If "No", the ACH Batch has never had an ACH text file created and both the 'ACH File Generated Date' and 'ACH File Generated By' fields will be blank. If "Yes", the ACH Batch has had one or more text files created and both the 'ACH File Generated Date' and 'ACH File Generated By' fields will be populated. This only identifies if the text file was created, it does not indicate whether the text file was uploaded to the bank. This will be "No" if there is no record for the Batch in ERPx_GLACHFile Database Field: EERPx_MFTransactionBatch.ACHGeneratedBy
ACH File Generated Date	Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. This will only be populated if the text file was created, else it will be blank. Database Field: ERPx_GLACHFile.CreatedDateTime, ERPx_MFTransactionBatch.TransactionBatchSK
ACH File Generated By	Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. This will only be populated if the text file was created, else it will be blank. Database Field: ERPx_GLACHFile.CreatedBy, ERPx_MFTransactionBatch.TransactionBatchSK
Batch	Displays the name of the batch. from the Batch ID field on the Process Payments record view formatted as [User First Name] + [User Last Name] + [Batch Number + 1] . This field is required and is never editable by a user. Database Field: EERPx_MFTransactionBatch.BatchID
Batch Created Date	Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_MFTransactionBatch.LastUpdated
Checkbook	Identifies the Checkbook assigned to the transaction. Database Field: ERPx_MFCheckbook.CheckbookID, ERPx_MFCheckbookTransaction.CheckbookSK, ERPx_MFTransactionBatch.TransactionBatchSk
Effective Date	The ACH Effective Date is the data that will be submitted to the bank as the Payment Date in the ACH text file. This is the date that the funds "should" leave your account and be sent to the recipient. This defaults from the 'Payment Date' used when the payments were posted but can be changed in the event the 'Payment Date' occurred in the past, on a holiday, or on a weekend. Database Field: EERPx_MFTransactionBatch.ACHEffectiveDate
Last Updated By	Identifies the name of the user that last updated the line item on the transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. This will be the last user to post the ACH Batch or edit the 'Effective Date'. Database Field: EERPx_MFTransactionBatch.LastUpdated
Payment Date	Identifies the date the payment will be applied, formatted from the users 'Date Format' preference. This is a date picker that defaults to the current date. It is required and if missing, will default to current date on Save. This date will automatically populate the 'Payment Date' field on the Process Payments Record View. This field is editable until payments are assigned, after this the field is disabled on Save. Database Field: EERPx_MFTransactionBatch.BatchDate
Posted ACH Amount	A text box to show the amount of the ACH Batch. This will be the total of all the ACH payments that were included in the batch. Database Field: EERPx_MFTransactionBatch.ACHTotal
Posted ACH Count	A text box to show the count of ACH payments in the ACH Batch. This will always be >= 1. Database Field: EERPx_MFTransactionBatch.TransactionCount

Page Header

Related Topics

Page Definitions

Technical Details

Browser not supported