web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Issue with Citi Bank A...
Small and medium business | Business Central, N...
Suggested Answer

Issue with Citi Bank ACH EFT File

(1) ShareShare
ReportReport
Posted on by Hatimali84 679
Hello everyone,
WE are setting up an Electronic payment (EFT) for one of our client for CIti Bank. Citi Bank have a very different file, a flat file with no header or footer (dummpy info). We have configured the data exchange (include field mapping) and bank import export, vendor bank account but we get the below error. 
 
 
 
 
 
The generate file should be like this.
#CA#ACH#20201112#####CAD#11.12##2011111119###########20201112##1112CAACHCI01#CROSSREF####460#######ORIGSHORT#ORIGLONG######123456789112#BENE NAME######86000000
 
I have never setup this kind of file before so no sure what I am missing here. The Bank only provided the above information to setup. 
 
 
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,212 Super User 2026 Season 1 on at
    This seems to be impossible to do except by customization.
    In the customization, you must first remove all #, and then you need to clarify the meaning of each field before you can import it. I recommend that you contact your partner to resolve this issue.
     
    Thanks.
    ZHU
  • Hatimali84 Profile Picture
    Hatimali84 679 on at
    Hi Yun Zhu,
     
    Thank you for your response. 
     
    We tried to get the details in line and also removed the place holders and added the Pad instead and changed some details as per their requirements.
    Specs:
    North America - Canada:
          ACH Debit, ACH Credit/GIRO:
    The use of characters is restricted to 0-9,  A-Z , "=" , "-" , "$", ".", "&", ","
     Note: “*” is not permitted in ACH Debit, ACH Credit/GIRO payment methods
    In addition to the above characters “Space” is a valid character only for following fields
    Cross Reference Number
    Beneficiary Name (ACH Credit)
    Debit Party Name (ACH Debit)
    Beneficiary Bank Name (ACH Credit)
    Debit Bank Name (ACH Debit)
    Originator's Short Name
    Originator's Long Name
    Use of other characters is prohibited.
     Allow lower case alpha to be entered by user, however the application automatically converts lower case letters to upper case upon entry
     
    and they also provided an XML file which i dont know what to do as its not getting imported in BC.
     
    <?xml version="1.0" encoding="UTF-8" ?>
    <Document xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03">
        <CstmrCdtTrfInitn>
            <GrpHdr>
                <MsgId>CASH00100059</MsgId>
                <CreDtTm>2017-03-16T22:00:30</CreDtTm>
                <NbOfTxs>1</NbOfTxs>
                <CtrlSum>0.01</CtrlSum>
                <InitgPty>
                    <Nm>Citi Company</Nm>
                    <PstlAdr>
                        <Ctry>US</Ctry>
                    </PstlAdr>
                </InitgPty>
            </GrpHdr>
            <PmtInf>
                <PmtInfId>CASH00100059</PmtInfId>
                <PmtMtd>TRF</PmtMtd>
                <BtchBookg>true</BtchBookg>
                <PmtTpInf>
                    <SvcLvl>
                        <Cd>NURG</Cd>
                    </SvcLvl>
                    <CtgyPurp>
                    `    <Prtry>450</Prtry>
                    </CtgyPurp>
                </PmtTpInf>
                <ReqdExctnDt>2017-03-16</ReqdExctnDt>
                <Dbtr>
                    <Nm>Citi Company Name</Nm>
                    <PstlAdr>
                        <Ctry>CA</Ctry>
                    </PstlAdr>
                    <Id>
                        <OrgId>
                            <Othr>
                                <Id>XXXXXX</Id>
                            </Othr>
                        </OrgId>
                    </Id>
                </Dbtr>
                <DbtrAcct>
                    <Id>
                        <Othr>
                            <Id>1234567890</Id>
                        </Othr>
                    </Id>
                    <Ccy>CAD</Ccy>
                </DbtrAcct>
                <DbtrAgt>
                    <FinInstnId>
                        <BIC>CITICATTBCH</BIC>
                    </FinInstnId>
                </DbtrAgt>
                <ChrgBr>SHAR</ChrgBr>
                <CdtTrfTxInf>
                    <PmtId>
                        <InstrId>A02BOOK000012</InstrId>
                        <EndToEndId>00000185</EndToEndId>
                    </PmtId>
                    <Amt>
                        <InstdAmt Ccy="CAD">0.01</InstdAmt>
                    </Amt>
                    <CdtrAgt>
                        <FinInstnId>
                            <ClrSysMmbId>    
                                <MmbId>000012345</MmbId>
                            </ClrSysMmbId>
                        </FinInstnId>
                    </CdtrAgt>
                    <Cdtr>
                        <Nm>Target Payee Name</Nm>
                        <PstlAdr>
                            <Ctry>CA</Ctry>
                        </PstlAdr>
                    </Cdtr>
                    <CdtrAcct>
                        <Id>
                            <Othr>
                                <Id>87654321</Id>
                            </Othr>
                        </Id>
                    </CdtrAcct>
                </CdtTrfTxInf>
            </PmtInf>
        </CstmrCdtTrfInitn>
    </Document>
     
    Any idea on this. 
     
    Regards,
     
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 26,110 Most Valuable Professional on at
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,212 Super User 2026 Season 1 on at

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,012 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 986 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 659 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans