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

Exporting a BACS file from business central (fixed text)

(0) Share

Report

Posted on by patrickwantenaar

Does anyone have experience of setting up a BACS export file? I have attempted to do this with a data exchange definition but I'm struggling to build it with the right fixed text allowances and I don't know where to populate all the information that the file is going to need to export or even what that information is.

All the guidance I can find for this points to using AMC Banking but the assisted setup is not working with the below error reason. We are using version 18.

The built in BACS export functionality has just been deprecated in April 2021.

<?xml version="1.0" encoding="utf-8"?>

<ns3:dataExchangeResponse xmlns:ns2="amc/xml/pay03_keyvaluerequest" xmlns:ns3="">nav03.soap.xml.link.amc.dk/" xmlns:ns4="amc/xml/pay03_paymentrequest" xmlns:ns5="amc/xml/pay03_paymentresponse" xmlns:ns6="amc/xml/pay03_entryrequest" xmlns:ns7="amc/xml/pay03_keyvalueresponse" xmlns:ns8="amc/xml/pay03_reportresponse" xmlns:ns9="amc/xml/pay03_tokenresponse" xmlns:ns10="amc/xml/pay03_bankresponse" xmlns:ns11="amc/xml/pay03_global" xmlns:ns12="amc/xml/pay03_entryresponse" xmlns:ns13="amc/xml/pay03_dataexchangeresponse" xmlns:ns14="amc/xml/pay03_reportrequest" xmlns:ns15="amc/xml/pay03_journalresponse">
<return>
<syslog>
<hinttext>Did not get response code 200 (OK) from server. Got: 500 Reason: Server Error Content received: org.apache.http.conn.EofSensorInputStream@d2081be</hinttext>
<text>An error occurred while requested login from the license server (sa/main)</text>
<url>amcbanking.com/.../url>
<syslogtype>error</syslogtype>
</syslog>
<header>
<result>error</result>
</header>
</return>
</ns3:dataExchangeResponse>

All responses (10)

Answers (0)

Community member 2 on at

Like (0)

Report

Exporting a BACS file from business central (fixed text)

Hi,

Have you managed to resolve this please?

I have a problem with fixed text BACS file export, and the suggestions by Vanessa don't resolve it for me.

The problem is that the export file is supposed to have header, detail, and footer lines.

However, even if I specify those in my Date Exchange Definition (DED), I can only select one line for the Payment Method Code in the Payment Journal Line.

So the file will only contain a set of detail lines, or headers, or footers, but not all of them.

This just doesn't make any sense to me.
Community member 2 on at

Like (0)

Report

Exporting a BACS file from business central (fixed text)

Hi @chris197,

Were you able to create the file for HSBC?

I have the same requirement where I need to export the payment file for JP Morgan. Can anyone help?
chris197 50 on at

Like (1)

Report

RE: Exporting a BACS file from business central (fixed text)

As near as I can tell AMC 365 is the worst software ever written. They also have horrible support. Give up. Move on.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Exporting a BACS file from business central (fixed text)

Patrick,

Yes, the actual Data Exchange you re using for HSBC would include the following setups:

Now to make this easier and assist you, I am attaching a handout I give my customers to create the Positive Pay Data Exchange definition.

Hope this helps.

Thanks,
Steve

[View:/cfs-file/__key/communityserver-discussions-components-files/758/Set-Up-the-Data-Exchange-Definitions-Positive-Pay.docx]
patrickwantenaar 45 on at

Like (0)

Report

RE: Exporting a BACS file from business central (fixed text)

Thank you again Steve

HSBC have given us a sample of the file they need to receive. It's a text file. Should the codeunit be different altogether if this is the case? I don't know if this will format correctly when I submit it, but I've pasted below the sample text from the file they sent me.

VOL109EM00 BACSNO 1

HDR1ABACSNOS 1BACSNO09EM0000010001 20001 20005 000000

HDR2F0200000100 00

UHL1 20002999999 000000001 DAILY 001

1234561234567809912345612345678 00000000001DEBIT COMPANY REF FOR BENE BENE NAME

1234561234567809912345612345678 00000000001DEBIT COMPANY REF FOR BENE BENE NAME

1234561234567809912345612345678 00000000001DEBIT COMPANY REF FOR BENE BENE NAME

1234561234567809912345612345678 00000000001DEBIT COMPANY REF FOR BENE BENE NAME

1234561234567801712345612345678 00000000004REF FOR DEBIT ACC CONTRA DEBIT COMPANY

EOF1ABACSNOS 1BACSNO09EM0000010001 20001 20005

EOF2F02000000100 00

UTL10000000000004000000000000400000010000004
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Exporting a BACS file from business central (fixed text)

Patrick,

The choice depends on the file. 1232 is Bank Data Conv. Service and Vanessa is using 1231 a General Export CSV file. I could have chose that one and not the Service and the Service is built to match the Service I am sending too. The same for the Codeunit. I chose the Bank. Conv. vs. 1277 Exp. External Data Gen. Journal. Sorry for the difference but Vanessa's selection would be the optimal choice when Exporting the CSV file and manually sending to Bank.

Hope this helps.

Thanks,

Steve
patrickwantenaar 45 on at

Like (0)

Report

RE: Exporting a BACS file from business central (fixed text)

Hi Steve

Thank you. I have described the error message in my reply to Vanessa. Your screenshot of those data exchange definitions with the first line highlighted has some different configuration to what Vanessa's did, specifically your value for Reading/Writing XMLport is 1232 where hers is 1231 and your value for Ext. Data Handling Codeunit is 1278 where Vanessa's is 1277. What's the significance of this?
patrickwantenaar 45 on at

Like (0)

Report

RE: Exporting a BACS file from business central (fixed text)

Hi Vanessa

Thanks very much for your answer. I have now copied the exact setup you suggested and completed the Bank export/import setup too and set the payment export format on the bank account.

The message I get now when trying to export the bank file now is "There is insufficient memory to execute this function. This can be caused by recursive function calls. Contact your system administrator." On inspecting this error the following appears in the error callstack countless times: ""Export Payment File (Yes/No)"(CodeUnit 1209).OnRun(Trigger) line 25 - Base Application by Microsoft"
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Exporting a BACS file from business central (fixed text)

Patrick,

Adding to what Vanessa replied already... Data Exchanges require a few setups and if they are all not applied, it will not work. As Vanessa noted, did you setup the Bank Import/Export Setup with the new Data Exchange? If you can give us the error messages you are getting when performing the Payment Export, we can help further.

Thanks,

Steve
Suggested answer

Vanessa Garcia on at

Like (0)

Report

RE: Exporting a BACS file from business central (fixed text)

Hello Patrick,

some time ago we build a BACS Data Exchange Definition like this one:

With the right setup, it works.

What are your issues specifically? maybe if you can share the problems, we can try to help you further, but something like the above should work.

Of course you need to setup as well the Bank Export/Import setup pointing to that Data Exchange Definition, Payment Export Format should be correct as well in the bank, etc...

I hope it helps and let me know if I could try to help you further with anything.