Skip to main content

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.

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

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.

 

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

No, I was not.

Reply


Terms & ConditionsCookie 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