EVS100 import cannot find connected fields

Dears,

I'm reaching out to see if someone has experienced the same and know a solution.

I'm having an Excel-file containing banks and branches. The first sheet contains banks and here import is going well. The seccond sheet contains bank branches. Each bank has a bank number (BKNO) formatted as text. For both sheets BKNO is formatted as TEXT in Excel.

On import, all of the import lines claims that the bank number does not exist. I have checked for blank spaces and there are none.

Any good ideas?

In M3 I find this bank no. in CRS690

Stil, when running CRS691MI_AddBankBranch, I get this.

Find more posts tagged with

General Discussion

Accepted answers

Shirley Zinn

Hi Kristoffer,

I've experienced EVS100 not responding well to '0 in the excel file, which allows for the 'text' of the leading zero.

Bank accounts and branches are also typically Division / Company related. Are you in the right company / division in MNS150?

Regards

Shirley

All comments

unknown

Hi Kristoffer,

I don't have any experience with M3, but in EAM this occurs when organization is empty or filled with different value between bank and branch.

don't know M3 has the organization field at all, but maybe it helps.

Shirley Zinn

Hi Kristoffer,

I've experienced EVS100 not responding well to '0 in the excel file, which allows for the 'text' of the leading zero.

Bank accounts and branches are also typically Division / Company related. Are you in the right company / division in MNS150?

Regards

Shirley

Copyright © 2025 Infor. All rights reserved.