Skip to main content
Answer

ACH export with excel type export

  • April 2, 2024
  • 7 replies
  • 223 views
A
Freshman I

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. 

 

 

Best answer by DavidEichner

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

 

7 replies

DavidEichner
Captain II
Forum|alt.badge.img+13

Hi @aliciacalvillo36 

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

BesT,

 

David

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
A
Freshman I

@DavidEichner 

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

 

 

DavidEichner
Captain II
Forum|alt.badge.img+13

What build are you using?

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
A
Freshman I

@DavidEichner 

 

 23.115.0031 

DavidEichner
Captain II
Forum|alt.badge.img+13
  • DavidEichner
  • Captain II
  • Answer
  • April 2, 2024

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

 

David Eichner, CPA - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
M
Freshman I

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..

A
Freshman I

Hi @mohdeizzuddin77 

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

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved