Skip to main content
Question

Batch Payment Export to CSV file


Forum|alt.badge.img

On the Batch Payment screen there is an Export option that calls and Export by Scenario specified in the Payment Method for the batch.  The bank does not want a typical ACH file, they just want a comma-delimited file of the detail lines, like this:

Business / Individual,Privacy,Payee,Routing Number,Account Number,Checking or Savings,Date,Dollar Amount,Credit/Debit,Note to Payee
I,P,Atomic Systems,123456789,444444444,Checking,4/19/2024,9.06,C,
I,P,ABC Retailer,341256339,55555555,Checking,4/13/2024,12.45,C,

Has anyone accomplished an export like this? 

I know that we could do it from a GI, but the customer wants to do it from the Batch Payment screen.

Thank you in advance.

4 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • August 20, 2024

Should be straight forward

  1. Create a Data Provider of Type csv
  2. Create an Export Scenario (copy ACH if you want) remove all ACH stuff and just have the fields you need and use the data provider in step 1.
  3. On the Payment Methods>Setting for Use in AP>Set Export Method to Export Scenario then select your Export Scenario that you created in step 2

Forum|alt.badge.img
  • Author
  • Varsity I
  • 25 replies
  • August 26, 2024

The issue isn’t the CSV file.  The issue is that the ACH data isn’t available on the Batch Payments screen to export to the CSV file.  I can’t follow how the out of the box export scenario works to get and format the data that it does.

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • September 10, 2024

Hi @johnw51 were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Varsity I
  • 25 replies
  • September 10, 2024

No, I was not.


Reply


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