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

Notifications

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 564
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 95,331 Super User 2025 Season 2 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 564 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... 25,157 Most Valuable Professional on at
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,331 Super User 2025 Season 2 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans