Skip to main content
Question

Remittance Advice for ACH Prepayments


Forum|alt.badge.img

ACH payments are our primary means of remittance.  Our ACH payments are accompanied by an emailed Remittance Advice (triggered by a Business Event).  This has worked without issue for the two years we have been on Acumatica.  For the same amount of time we have been trying to get Acumatica to email a Remittance Advice when making an ACH payment for a Prepayment (out of Purchase Order). 

At first we tried making Active a stock Business Event, “Email Vendor ACH Prepay Advice,” which did not work.  We have subsequently tried numerous modifications.  Requests for Vendor Prepayments are fairly infrequent.  Sometimes weeks pass between a failed attempt, a modification and the occasion to try again. 

At any rate, here is what has most recently failed:

 

Anyone have the magic combination to cause Acumatica to email a Remittance Advice for an ACH Prepayment?

14 replies

jhouser
Captain II
Forum|alt.badge.img+1
  • Captain II
  • 103 replies
  • January 27, 2024

Hi @TSIJeff - I noticed a couple things you could check:

  1. I would assume Prepayment hasn’t been applied to a document yet, if it’s being created from a PO. In that case, it would have the status of Open, not Closed. 
  2. I think you want New Field Value for the second row, like the others. 
  3. Double check payment method. Are you using FEDWIREBA or FEDWIRE?

If trying/checking the above doesn’t work, please attach an XML export of your business event. 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 25 replies
  • January 29, 2024

Excellent suggestions.  I have yet to wrap my head around the logic - what’s there is a guess.  I’ll give your suggestions a try.

The payment method is a misnomer I don’t particularly care for, but it was how it was set up. FEDWIREBA and FEDWIRE are parlance for ACH (which is most assuredly not a wire transfer); the BA addition merely notes a Balanced NACHA file, required by our bank.


jhouser
Captain II
Forum|alt.badge.img+1
  • Captain II
  • 103 replies
  • January 29, 2024

@TSIJeff Sounds good, give 1 and 2 a try and let me know


Forum|alt.badge.img
  • Author
  • Freshman II
  • 25 replies
  • February 15, 2024

Finally had occasion to process another ACH Prepayment - no email.  I went to the Business Event History to look for a failure and the result was “No records found.”

Open for suggestions.  Really, really seems like this would be something addressed out of the box by Acumatica.


jhouser
Captain II
Forum|alt.badge.img+1
  • Captain II
  • 103 replies
  • February 15, 2024

@TSIJeff I can look at this further if you export your business event as an XML and attach the file in a comment. 

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 25 replies
  • February 15, 2024

Thank you for the offer.  Attached. 


jhouser
Captain II
Forum|alt.badge.img+1
  • Captain II
  • 103 replies
  • February 15, 2024

Okay, I got it to trigger and create an email. But there are 3 things I changed, which you should check:

 

  1. Check conditions on your business event. For line 2, you need to select the payment method you’re using (see below where I selected ACH). If you’re not going to limit to certain payment types, just remove that row. For line 3, verify whether status should be open or closed. If you’re applying these prepayments to documents, status when released will be closed. If not applying, verify prepayment is released and in Open status. 

           

 

  1. Make sure Vendor’s remit email address is populated:

       

 

 

  1. Make sure you have a From email on your email template. Must select one from your Email Accounts. If you don’t have any set up it won’t work. 

           

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 25 replies
  • February 15, 2024

Thank you for reviewing this.  I can confirm the Value 1 payment type is correct (FEDWIREBA) - use of this payment type is the only instance where we would need the Remittance Advice to go out.  The Status should be Open as, at the time of the Event there is not yet a document to which the payment is applied.

I can confirm the Vendor email addresses are populated.

I can also confirm the From address is populated as this is the same Template used for our normal ACH operations (and that works without issue).  Perhaps that is the issue (dual use of the same Template):

Could the problem be that some of these fields are not the same in a Prepayment, causing the system to abort?


jhouser
Captain II
Forum|alt.badge.img+1
  • Captain II
  • 103 replies
  • February 15, 2024

Sorry, I now realize it removed payment method and From address when I imported, since neither of those values exist in my test environment. 

You could try with a new separate template. Beyond that, I would suggest reaching out to your Acumatica support provider, as it’s difficult for me to troubleshoot further without access to your site. 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 25 replies
  • February 15, 2024

I really appreciate your willingness to help.  I have indeed reached out to our VAR.  They’re stumped, too.  I will continue to experiment.  Thank you.


dsimmerly
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 113 replies
  • February 15, 2024

@TSIJeff  I have had success creating multiple ACH Payment Notification Business Events by  starting with a GI of Payments with condition for status closed and payment method ACH. Then the Business Events is set to trigger on a new record on the GI.  An alternative method to try.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2546 replies
  • March 29, 2024

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 25 replies
  • May 31, 2024

Still hammering away on this. The infrequency of prepayment events and no real way of running experiments greatly slows the reasoning process. I tried a back-to-basics approach with today’s opportunity. I attempted to mirror the logic found in our successful BE that emails remittance advice to ACH payment of bills:

 

Another failure - the lack of any logging makes every attempt a shot in the dark. There are no failure messages or any other explanation why this BE was ignored.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 25 replies
  • July 26, 2024

Not giving up!  

Here's what I can't understand: the ACH payment itself should be sufficient to trigger the emailed Remittance Advice, independent of whether the payment is the result of a Bill or a Prepayment.

Consider the Screen Name in the Business Event for ACH Remittances: 

It is the Checks and Payments Screen, AP302000. If we go to that screen and review the last two entries we have a payment for a Prepayment ($35,575.00) preceded by a payment for a Bill ($850.00):

The stipulations in the Business Event have it looking for any entry with a Payment Method of FEDWIREBA that has a Status field value changed to Closed.  We see that in both instances we have matching Method and Status, yet the Bill payment generated a Remittance Advice whereas the payment on the Prepayment did not. No difference with respect to the Business-Event referenced Screen.

What gives?  Anyone?


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