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>
As near as I can tell AMC 365 is the worst software ever written. They also have horrible support. Give up. Move on.
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]
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
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
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?
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"
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
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.
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156