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

• 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

• ACH Effective Date: 

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

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