Skip to main content
Solved

ACH export with excel type export

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:

 

View original
Did this topic help you find an answer to your question?

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
1 person likes this
  • Chris Hackett
    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
  • 372 replies
  • 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
1 person likes this
  • Chris Hackett
    Chris Hackett
M
Freshman I
aliciacalvillo36 wrote:

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
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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