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

Issue with Citi Bank ACH EFT File

(1) Share

Report

Posted on by Hatimali84

338

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.

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

Issue with Citi Bank ACH EFT File

XML files should be importable, hopefully the following standard document can give you some hints.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions?wt.mc_id=DX-MVP-5004336#to-describe-the-formatting-of-lines-and-columns-in-the-file

Thanks

ZHU
gdrenteria 12,290 Most Valuable Professional on at

Like (0)

Report

Issue with Citi Bank ACH EFT File

Hi

I hope this can help you

The EFT export code entered on the bank account does not work with the export format entered on the bank account. (dynamics.com)

Export EFT files error (dynamics.com)

Best

GR
Hatimali84 338 on at

Like (1)

Report

Issue with Citi Bank ACH EFT File

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,
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

Issue with Citi Bank ACH EFT File

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