Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

How can I export direct debit collection in fixed width (not XML)

(0) ShareShare
ReportReport
Posted on by 129

Hi,

Does anyone know how I can produce a direct debit export file in fixed width format?  Whatever I try produces XML.  For clarification, I'm in Great Britain.

Here's my Data Exchange Definition:

pastedimage1680616193328v1.png

The only thing I can think of would be the processing XMLport on the Bank Export/Import Setup but the only one the system will let me use is 1010 (SEPA DD pain.008.001.02).

I've tried duplicating the 1010 XMLport and changing the FormatEvaluate property from Xml to Legacy, and also adding a Format property to FixedText but it's still producing an XML file.

I've produced fixed width files for payment exports before but this is the first time I've tried it for direct debit collections and I'm stumped.

If anyone has any advice, it would be much appreciated. 

(Please don't advise me to raise a ticket with our partner as some people feel the need to do, you're adding no value as I've already done this!)

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,869 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,733 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans