Credit ACH processing

Overview

Credit ACH Processing Job processes the loan disbursal transaction on a loan to generate the ACH file.

Features 

The features of the Credit ACH Processing job are:

• It processes the disbursal transactions and creates an ACH file for every bank.

• It can process up to 1000 transactions per day.

• It makes use of the Recurring ACH fields in a loan account, the Bank details and ACH Parameters custom settings to fetch the required data for ACH.

• It is linked to run after the ACH Processing Job and before the SOD Accounting job. 

  Note:

  ACH Processing Job is used for payment processing.

Custom settings

The custom settings required for Credit ACH Processing are as follows:

• ACH Parameters

• Metadata segments

ACH Parameters

This includes the fields such as ACH ID, Days in advance to create a file, Fed Tax ID, Folder name and Organization name.

This can be illustrated as shown in the image below:

Metadata segments

The ACH file has various segments, this setting includes the name of each segment with the name of object corresponding to the segment.

Credit ACH Processing

Prerequisites

None.

Steps

Perform the following steps to understand how Credit ACH Processing works:

1.  Log in to your salesforce account.

2. Create a CL Contract.

   Note:

   For more information about creating a CL contract, refer to section Creating a CL Contract in chapter Contract Management.

   Note:

   Please note, the loan account for disbursal transaction should have the status, Active- Good Standing. Also, ensure that you enter relevant information under ACH Details namely, ACH Account type, ACH Relationship type, ACH Routing number, ACH Account number, ACH Bank name. This is imperative for the ACH file generation.

3. Click Transactions, Funding.

4. Click New loan disbursal transaction.

5. Enter the Mode of Payment.

   Note:

   Ensure that you enter ACH as the Mode of payment. This is imperative for Credit ACH Processing.

6. Click Save.

   Now, you must run the Credit ACH Processing job.

Run Credit ACH Processing Job

Prerequisites

None.

Steps

Perform the following steps to run the Credit ACH Processing job:

1. Login to Salesforce Account.

2. Click Service Configuration.

3. Go to ACH.

4. Click Run Credit ACH Process. 

5. Enter the Batch size.

6. Enter the Credit Date.

   Note:

   Here, all the records till the specified Credit date are processed. 

7. Click Credit ACH Processing.

8. Click Refresh Result view.

9. Go to Documents.

10. Go to Folder.

11. Select Shared folder for ACH.

12. Click Go and the ACH file is generated.

13. Click View to view the ACH file.

    Also, if you go the previously created Loan Disbursal Transaction detail, you see that Sent to ACH is selected.

    This indicates that the ACH transaction has been processed. 

Custom Query Support for Credit ACH Processing Job

Custom Query option for Credit ACH Processing Job is provided to change the criteria to pick disbursement records for ACH file generation.

Prerequisites

None.

Steps

Perform the following steps to run a custom query for a credit ACH processing job:

1. Create a class in the org. 

2. Implement IBatchJobQuery interface. 

3. Implement getQuery method of IBatchJobQuery interface.

4. In getQuery method, put a condition on the basis of JOB_NAME that actually returns a String query as output.

   Note:

   This interface displays the getCustomJobQuery method where you need to check for jobName and should return the query on the basis of that:

   Copy

   public class CreditACHProcessingCQ ��implements IBatchJobQuery {public String getCustomJobQuery(String jobName,Custom_Job_Query__c customJobQuerySetup) {if(jobName.equalsIgnoreCase(CustomLogicUtil.JOB_CREDIT_ACH_PROCESSING)) {return 'Query Here';}return null;}}

5. Create entry for the this class created in first step, in Batch Job Query Class field under Custom Settings, Custom Logic Parameters.

   The query provided there in the Custom Class CreditACHProcessingCQ, will be fetched for processing records in Batch Job.

Field reference