ACH Batch Inquiry
- Tom Williams
- Emma Greenwood
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.
|
| 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).
|
| Help | Opens the online WIKI help page for the current page.
|
| Inquiry Criteria | Opens Inquiry Criteria window where users can define the following criteria:
|
| Mass Update | Opens the mass update dialog, which allows to mass update the following properties:
|
| 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.
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 |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.