Skip to main content

Notifications

Announcements

No record found.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans