web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Data Exchange definiti...

Small and medium business | Business Central, N...

Suggested Answer

Data Exchange definition - Concatenate 2 fields for payment export file

(0) Share

Report

Report

Posted on by October Sky

548

Hi

I wish to create a payment export file format via a Data Exchange definition. One of the Bank fields is a combination of branch code and account number. Is there any way to achieve this concatenation of 2 fields in Data exchange definitions without customisation?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (0)

Report

Hi

I have not been able to do it personally, I have read that due to transformation and coding rules you could surely reach what was mentioned.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions#transformation-rules

One example about that

https://www.cloudfronts.com/blog/d365-business-central/custom-transformation-rule-for-ach-using-al-extension-in-business-central/

I also found a somewhat similar question and here are some answers from other colleagues.

https://community.dynamics.com/forums/thread/details/?threadid=71a533fe-c1ef-4309-a101-3c6fb6e54b56

Best Regards

Gerardo

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 3,098

#2

Jainam M. Kothari 1,556 Super User 2025 Season 2

#3

YUN ZHU 1,108 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans