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

Direct Debit Payment Export File UK

(0) Share

Report

Posted on by Matt Smith - Cha Ltd

Good afternoon,

I have created a DD collection file with all the entries that should be there (customer invoices).

The bank card set-up is using SEPADD as the export format and will only allow EUR currency.

I need to be able to use GBP as the currency and it looks as though the SEPA export format will not allow this.

Does anyone have any pointers as to how to set-up a UK payment export file? I believe I may have to set-up a data exchange definition as per below?

I am not sure of what code units I should be using here to set this up.

If anyone has previous experience of setting this up or any article's, would be very appreciated.

Regards,

Matt

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

ArturV 225 on at

Like (0)

Report
Copy link

Link copied!

Hi Matt,

What version do you have? In one of the recent updates a new fields has been added to the General Ledger Setup. It's called the "SEPA Non-Euro Export". This should solve your case.

Was this reply helpful? Yes No
Matt Smith - Cha Ltd 65 on at

Like (0)

Report
Copy link

Link copied!

Hi ArturV,

Thanks for the reply.

Below is the version we have:

Looks like no update is pending. I dont seem to have the option to select SEPA non euro export. Should this be listed in the available payment export file drop down?:

Regards,

Matt

Was this reply helpful? Yes No
Matt Smith - Cha Ltd 65 on at

Like (0)

Report
Copy link

Link copied!

OK solved - Like you said Arthur the following option needs to be set to 'on' within the gerenal ledger setup screen as per below, the export format should be kept to SEPA DD as this now allows non EU currency:

You may have to select 'show more' within the general fast tab to show these options.

One last question - Is there anyway to change the export format form XML to CSV?

Regards,

Matt

Was this reply helpful? Yes No
Matt Smith - Cha Ltd 65 on at

Like (0)

Report
Copy link

Link copied!

Another problem that I can see with the export file is that only the account number is pulling through in the <iban> element. Is there a way to pull through the sort code also?

Was this reply helpful? Yes No
Suggested answer

t3o 5 on at

Like (0)

Report
Copy link

Link copied!

There is a second field on the General Ledger Setup - "SEPA Export w/o Bank Acc. Data". If you turn this on, this gets the output to pull through the Sort Code and Account No. in place of the SWIFT and IBAN Nos.

Was this reply helpful? Yes No