web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Adding unavailable fields to Data Exchange Definition Field Mapping for EFT Payment Export

(6) ShareShare
ReportReport
Posted on by 90
Hello,
 
I am creating an EFT payment export data exchange definition so that payments are exported to a .txt from the payment journal. The specifications provided by the bank for the file require fields that not available in the Table "Payment Export Data" which I know to use on Field Mapping page. I need the ability to get the below fields to insert into the EFT export file:
- Vendor No. from Vendor Bank Account table (code[20].
- A custom field from the Bank Account Card table called File ID Modifier (integer).
- Total $ amount of the payment export file (decimal).

I can do a good amount of development myself, but I have never messed around with development in this EFT export process. As such, I would like to know what other objects I need to extend to be able to map the fields mentioned and ensure they appear on the payment export. I know I need to extend the Table "Payment Export Data" but do I also need to extend or create my own versions of the Pre-mapping codeunit, Mapping codeunit, and Post-mapping codeunit? Any guidance and examples for this will be greatly appreciated!
I have the same question (0)
  • Jainam M. Kothari Profile Picture
    15,732 Super User 2026 Season 1 on at
    Hello,
     
    To include additional fields in an EFT payment export, you need to extend the Payment Export Data table with your custom fields and then use event subscribers in a custom codeunit to populate them during the export process, rather than replacing standard codeunits.
     
    Typically, you hook into events in the pre-mapping and post-mapping stages to fetch values from related tables (Vendor Bank Account for Vendor No., Bank Account for File ID Modifier) and calculate totals for the batch.
     
    This ensures that your fields appear in the Data Exchange Definition without disrupting standard logic.
  • Verified answer
    OussamaSabbouh Profile Picture
    12,803 Super User 2026 Season 1 on at
    Hello,
     
    You only need two things:
     
    1. Extend “Payment Export Data” with your 3 extra fields.
     
     
    2. Subscribe to the Data Handling codeunit (shown on your Data Exchange Definition) to fill those fields.
     
     
     
    You do NOT need your own pre-/mapping-/post-mapping codeunits unless the bank format is extremely custom.
     
    After you fill the fields in your subscriber, they automatically appear on Field Mapping and can be added to the TXT export.
     
    Regards,
    Oussama Sabbouh
  • Gerardo Rentería García Profile Picture
    25,555 Most Valuable Professional on at
  • Suggested answer
    Valentin Castravet Profile Picture
    32,152 Super User 2026 Season 1 on at
    The system already includes those three fields as part of the standard functionality. Check the existing data exchange definitions for EFT and you’ll see all three fields there, so you don't have to customize the system to add them.
     
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,219 Super User 2026 Season 1 on at
    Hi,
     
    If you check the standard EFT Data Exchange Definitions and find all three fields already mapped, then you can reuse them without customization. But if any field is missing (especially the custom one), customization is required.
     
    Thanks
    Rishabh
  • NX-14051948-0 Profile Picture
    90 on at
    Thank you for all the responses!

    Some responses are indicating that all the fields are there. So maybe I need to guidance as from my understanding is that the codeunit 1273 "Exp. Pre-Mapping Gen. Jnl." handles the movement of data from the general journal or other tables to the Payment Export Data table. If that is correct, then I am not seeing any code that maps the Vendor No. to the Recipient ID (which I assume is the field that will store it in) or the $ Amount from the Payment Journal. Is there another codeunit that would map that or am I missing something simple?

  • Suggested answer
    Valentin Castravet Profile Picture
    32,152 Super User 2026 Season 1 on at
    Don't check the codeunit, but as mentioned check the data exchange definitions that Business Central comes with. You will find your fields in there.
     
  • NX-14051948-0 Profile Picture
    90 on at
    I have seen the recipient ID in the table but I don't have a clear indication as to what exactly it is being populated with. So even though I am not seeing any code populating this field, it just populates? What about the Total Amount for the Payment Journal. What field on the table is that?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans