ACHReturnDetail ( returnCode )

Take in an ACH return code, "R01", "R02", etc, and then return a brief description.

Average rating: 5.0 (1 vote) Log in to vote

Robert D Trammel - Show more from this author
https://www.linkedin.com/in/robertdtrammel/

Sample input:

ACHReturnDetail( "R01" )
ACHReturnDetail( "R03" )

Sample output:

Insufficient Funds
No Account / Unable to Locate Account

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

//Pulled from https://www.gettrx.com/completed-ach-return-codes-list/

Case(
   returnCode = "R01"; "Insufficient Funds";
   returnCode = "R02"; "Account Closed";
   returnCode = "R03"; "No Account / Unable to Locate Account";
   returnCode = "R04"; "Invalid Account Number";
   returnCode = "R05"; "Unauthorized Debit to Consumer Account";
   returnCode = "R06"; "Returned per ODFI’s Request";
   returnCode = "R07"; "Authorization Revoked by Customer";
   returnCode = "R08"; "Payment Stopped";
   returnCode = "R09"; "Uncollected Funds";
   returnCode = "R10"; "Customer Advises Not Authorized";
   returnCode = "R11"; "Check Truncation Entry Return";
   returnCode = "R12"; "Branch Sold to Another DFI";
   returnCode = "R13"; "Invalid ACH Routing Number";
   returnCode = "R14"; "Representative Payee Deceased";
   returnCode = "R15"; "Beneficiary or Account Holder Deceased";
   returnCode = "R16"; "Account Frozen";
   returnCode = "R17"; "File Record Edit Criteria";
   returnCode = "R18"; "Improper Effective Entry Date";
   returnCode = "R19"; "Amount Field Error";
   returnCode = "R20"; "Non-Transaction Account";
   returnCode = "R21"; "Invalid Company Identification";
   returnCode = "R22"; "Invalid Individual ID Number";
   returnCode = "R23"; "Credit Entry Refused by Receiver";
   returnCode = "R24"; "Duplicate Entry";
   returnCode = "R25"; "Addenda Error";
   returnCode = "R26"; "Mandatory Field Error";
   returnCode = "R27"; "Trace Number Error";
   returnCode = "R28"; "Routing Number Check Digit Error";
   returnCode = "R29"; "Corporate Customer Advises Not Authorized";
   returnCode = "R30"; "RDFI Not Participant in Check Truncation Program";
   returnCode = "R31"; "Permissible Return Entry (CCD and CTX only)";
   returnCode = "R32"; "RDFI Non-Settlement";
   returnCode = "R33"; "Return of XCK Entry";
   returnCode = "R34"; "Limited Participation DFI";
   returnCode = "R35"; "Return of Improper Debit Entry";
   returnCode = "R36"; "Return of Improper Credit Entry";
   returnCode = "R37"; "Source Document Presented for Payment";
   returnCode = "R38"; "A stop payment was placed on the source document of the transaction.";
   returnCode = "R39"; "Improper Source Document";
   returnCode = "R40"; "Return of ENR Entry";
   returnCode = "R41"; "Invalid Transaction Code";
   returnCode = "R42"; "Routing Number / Account Number Mismatch";
   returnCode = "R43"; "Invalid DFI Account Number";
   returnCode = "R44"; "Invalid Individual Identifier";
   returnCode = "R45"; "Invalid Individual Name";
   returnCode = "R46"; "Invalid Representative Payee Indicator";
   returnCode = "R47"; "Duplicate Enrollment";
   returnCode = "R50"; "State Law Affecting RCK Acceptance";
   returnCode = "R51"; "Item is Ineligible, Notice Not Provided";
   returnCode = "R52"; "Stop Payment on Item";
   returnCode = "R53"; "Item and ACH Entry Presented for Payment";
   returnCode = "R61"; "Misrouted Return";
   returnCode = "R62"; "Incorrect Trace Number";
   returnCode = "R63"; "Incorrect Dollar Amount";
   returnCode = "R64"; "Incorrect Individual Identification";
   returnCode = "R65"; "Incorrect Transaction Code";
   returnCode = "R66"; "Incorrect Company Identification";
   returnCode = "R67"; "Duplicate Return";
   returnCode = "R68"; "Untimely Return";
   returnCode = "R69"; "Multiple Errors";
   returnCode = "R70"; "Permissible Return Entry Not Accepted / Notice Not Provided";
   returnCode = "R71"; "Misrouted Dishonored Return";
   returnCode = "R72"; "Untimely Dishonored Return";
   returnCode = "R73"; "Timely Original Return";
   returnCode = "R74"; "Corrected Return";
   returnCode = "R75"; "Return Not a Duplicate";
   returnCode = "R76"; "No Errors Found";
   returnCode = "R77"; "Non-Acceptance of R62 Dishonored Return";
   returnCode = "R78"; "Non-Acceptance of R68 Dishonored Return";
   returnCode = "R79"; "Incorrect Data in Return Entry";
   returnCode = "R80"; "IAT Entry";
   returnCode = "R81"; "Non-Participant in IAT Program";
   returnCode = "R82"; "Invalid Foreign Receiving DFI Identification";
   returnCode = "R83"; "Foreign Receiving DFI Unable to Settle";
   returnCode = "R84"; "Entry Not Processed by Gateway";
   returnCode = "R85"; "Incorrectly Coded Outbound International Payment";
)

Take in an ACH return code, "R01", "R02", etc, and then return a brief description of what that error means. This was created because we moved from one ACH processor to another, and the new processor did not provide the extra detail.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ACHReturnDetail ( returnCode )

Comments

Support this website.

Support this website.