Skip to main content
Solved

ACH export with excel type export

  • 2 April 2024
  • 7 replies
  • 115 views

I am looking to see if it is possible to create an excel export for ACH batch payments and get it to export an excel file instead an txt file.

 

Thank you. 

 

 

7 replies

Userlevel 7
Badge +12

Hi @aliciacalvillo36 

Have you set up the export scenario yet?  If so, can you share a print screen of that?

BesT,

 

David

@DavidEichner 

Here is my export…. i believe the issue may be with getting the batch number

 

 

Userlevel 7
Badge +12

What build are you using?

@DavidEichner 

 

 23.115.0031 

Userlevel 7
Badge +12

Try using   =Provider.GetBatchNbr() like in this example:

 

I am looking to see if it is possible to create an excel export for ACH batch payments and get it to export an excel file instead an txt file.

 

Thank you. 

 

 

Hi @aliciacalvillo36, the forum has been tick as solved. Can you share with me XML for the data provider & export scenario? I want to explore this same method..

Hi @mohdeizzuddin77 

I was unable to create an excel export from the ACH scenario.  I ended up just creating an export from a GI. 

Reply