How can we help you today?

Start a new topic
Discussions Raiser's Edge ImportOmatic

Financial Relationships Bank Issues

 Alright folks,

So I am setting up a Direct Debit Import and I am getting the following message:
Required Field  Missing : Bank
The issues is I have added the Bank Financial Relationship field in my import, selected the 'Add Banks to table if it does not already exist' So I am not sure what the problems is.
Anybody have any thoughts ?

Thanks
John

4 CommentsSorted by Oldest First
Hi John, Are you importing the field Primary Bank = "Yes"? We had to add these to our imports at some stage after we had an issue with DD payments.
Hi John,

Do you also have the bank name mapped to Record Type = Gift field and Value type = Bank: Financial Institution?

If not, you can use a virtual field to copy the bank name. In Virtual fields, right click and choose Insert Virtual Field. Map it to the gift field and use the Function = Copy field. The Seed will be the column letter than contains the bank name in your data file. In the below example, it's in column F:

 

image


 

Do the same for the other pieces of the bank - account number, branch, etc.

Please let me know if you have any other questions.

 

Thank you,
Amanda
Omatic Software

Hi Amanda,

Thanks for this, I now have a separate issue to this regarding the importing of banks and bank relationships.

I am importing new direct debit mandates and the following error is coming up Line 1: Bank 'Halifax PLC' with routing number '11-05-10' did not exist on the constituent record. Configuration settings do not allow for it to be added.

At present we are bringing in around 2000 new mandates, of them 50% went through fine, the rest seem to get rejected for an unknown reason as some of the exceptions already have the bank as a financial Institution on RE and some don't. We exported the Fin Institutions as the Financial Institution Name which is the bank name on importotmatic would some times differ, so in the case of bringing in existing institutions we did a match on sort code to get the correct bank name. This seems to work for some of them. Basically there is no rhyme or reason to why these exceptions are occuring...

A slight update, we think the issues is that the banks are being added but for some reason the bank relationship cannot be created for some constituents, but its very sporadic and there is not commonality in this.

Please help :)
John
Hi John,

If the bank name, branch name or sort code are different from an existing bank in RE, it is seen as a different bank. Are you able to add the branch name to the file as well? Also, make sure that the bank name is a perfect match to the bank name on the record.

Once you're down to an exception file that consists of brand new banks, you can go into your IOM profile under General Settings and select to Add bank to Banks table if it does not already exist.

Please let me know if you have any other questions.

Thank you,
Amanda
Omatic Software
Login or Signup to post a comment
More topics in ImportOmatic
See all 1194 topics