Finance | Project Operations, Human Resources, ...

GER configurations: "Import from client-bank" error: Evaluating expression for path '$bankGroupId'. Cannot find 'BankGroupId' field in 'BankAccountTable' table

(0) Share

Report

Posted on by Jana K.

Hi,

I've set up standard MS configuration 'Bank statement (RU).version.22.6.xml' from LCS GER configuration, "Import from client-bank" was working well before application update, application is 100% standard - no modifications. Now, after D365FO application update, looks like the import operation cannot find 'BankGroupId' field in 'BankAccountTable' table, but the field is present in the table and filled for each bank account:

Errors on trying to import the txt file

You've received multiple errors.
Session ID: 58bae05a-4abd-44a7-bd7b-2d9cd51030ce
Search timestamp: 2021-10-03T10:44:41.861Z
10.12.2114.24488 : 7.0.6129.77 : 7.0.21267.3
The menu item with name bankclientimport_ru could not be opened.
An error occurred during the 'Model mapping' run. For more information, contact your system administrator.
Evaluating expression for path 'model/$bankAccountFromStatement'.
Evaluating expression for path '$bankGroupId'. Cannot find 'BankGroupId' field in 'BankAccountTable' table

Full re-export of the configuration and full re-setup of related setups did not help.

Please help, no more ideas how to solve this...

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jana K.,

If you mean that the bank statement file that you use is correctly formatted and this issue has been happened after version updating, the issue can be related to the broken GER template. Please try following steps if it applies to the sandbox environment and to check if you can import the file:

1- Run "Restore broken templates" (Organization administration > Electronics reporting > Restore broken template) and wait that it get completed successfully go to

2- Import the bank statement. If you get the same error message, go to step 3

3- If you use standard configuration, delete Bank statement (RU) and its related model mappings and Payment model

4-Delete your user data and perosnalization

5-Log out from the solution

6-Open Private or incognito browser and import Bank statement (RU) from Microsoft Repositories

7-Import the bank statement

I hope it helps!

Was this reply helpful? Yes No
Jana K. 95 on at

Like (0)

Report

Alireza Eshaghzadeh,

Thanks for your answer.

Yes, I mean that the bank statement file that I use is correctly formatted and this issue has been happened after version updating.

But all suggested steps did not help :( same error.

BRGS

Jana K.

Was this reply helpful? Yes No
Suggested answer

Sheela Ningappa on at

Like (0)

Report

Hi,

Please find the below link which might help to resolve the issue:

[D365] The menu item with name could not be opened (robscode.onl)

Thanks,

Sheela

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Jana,

Thanks for update. I assume that you use sysadmin role while testing. You can debugge the import in regards to the error message. According to the error message it cannot find "BankGroupId" field in 'BankAccountTable'. Please check if you can access to this field or this have a value.

Ref. to model mapping PAYMENT MODEL MAPPING TO DESTINATION RU , this field is related to following calculated field:

There is following formula behind this 'Calculated field' which refer to other fields also:

Or you can try to raise a support ticket to get support from Microsoft.

Was this reply helpful? Yes No