Insert excerpt Def - ACH Payment Def - ACH Payment nopanel true
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: 20202023.0308.20 31 and newer
| Table of Contents | ||
|---|---|---|
|
...
| Toolbar Icons | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Excel |
| ||||||||||||||||
| Favorites |
| ||||||||||||||||
| 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 |
| ||||||||||||||||
| Help |
| ||||||||||||||||
| Inquiry Criteria |
| ||||||||||||||||
| Mass Update |
| ||||||||||||||||
| 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 |
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 |
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 |
Database Field: EERPx_MFTransactionBatch.BatchID | ||||||||||||||||
| Batch Created Date |
Database Field: ERPx_MFTransactionBatch.LastUpdated | ||||||||||||||||
| Checkbook |
Database Field: ERPx_MFCheckbook.CheckbookID, ERPx_MFCheckbookTransaction.CheckbookSK, ERPx_MFTransactionBatch.TransactionBatchSk | ||||||||||||||||
| Effective Date |
Database Field: EERPx_MFTransactionBatch.ACHEffectiveDate | ||||||||||||||||
| Last Updated By |
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 |
This only identifies if the text file was created, it does not indicate whether the text file was uploaded to the bank. ...