Credit ACH Processing

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

Features 

The features of 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.

Prerequisites

None.

Steps

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

1.  Login to your salesforce account.

2. Create a CL Contract.

   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: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