Configure ACH Settings On Bank (Canadian)

Pre-requisites

Step-by-Setp Guide









Navigate to the Bank Account Master (Master Table -> Miscellaneous -> Bank Accounts)

Make sure the check box for "Canadian Bank is checked

Navigate to the ACH Settings tab and fill in the bank info.



NOTE, the file name follows a certain format.  The prefix should be "TT03800" then follow by the first five digits from "Origin Number" field.  For testing, the prefix should be "TF03800".



Mapping

Record A

Field

Example

Description

Field

Example

Description

Origin Number (10 length)



Field 3 - User's number

Record C

Field

Example

Description

Field

Example

Description

Origin Name (15 length)



Field 11 - Abbreviated user's name

Origin Name (30 length)



Field 13 - User's name

Origin Number (10 length)



Field 14 - User's number

Destination Number (19 length)



Field 15 - Transaction reference number

Routing Number (9 length)



Field 16 - User's institution

Account Number (12 length)



Field 17 - Return account number

Entry Description (15 length)



Field 18 - User's general info

Record Z

Field

Example

Description

Field

Example

Description

Origin Number (10 length)



Field 3 - Control number

Misc

Ticket - ERP-18425

Spec -