Skip to main content
Answer

Sequencing a Letter in ACH Export

  • August 11, 2022
  • 5 replies
  • 84 views
P
Semi-Pro II
Forum|alt.badge.img

Hello everyone,

The bank we are working with requires a Batch Sequence letter. For example, if there were 5 batches exported and uploaded to their ACH portal, the first batch would have letter A, the second letter B etc. The catch is it resets every day, thus the next day if there are 6 batches, the first batch would upload again with letter A.

We are using the standard Export PR Payment to ACH scenario with ACHExportProviderDL. My thoughts are to add another field to the schema which would represent the one character. The problem I am having trouble with is getting a formula to look at both the date and the batch sequence for that date. Does this seem possible to do?

Thanks

Best answer by podonnell11

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

Chris,

I used Source Object Document, and Document.DateSeqNbr -- I believe it may have already been in there. The bank was fine with numeric codes.

 

 

5 replies

DConcannon
Varsity II
Forum|alt.badge.img+2
  • DConcannon
  • Varsity II
  • August 11, 2022

@podonnell11 Can you leverage the Daily Sequence Number from the Batch Header?

 

 

P
P
Semi-Pro II
Forum|alt.badge.img
  • podonnell11
  • Author
  • Semi-Pro II
  • August 12, 2022

@podonnell11Can you leverage the Daily Sequence Number from the Batch Header?

 

 

Good eye, I will create a substitution list … 1 = A , 2 = B etc. and see if this can be a solution.

DConcannon
Chris Hackett
DConcannon
Varsity II
Forum|alt.badge.img+2
  • DConcannon
  • Varsity II
  • August 12, 2022

@podonnell11Thanks, and hopefully the field shows as an available field within Substitutions Lists for you. On 2021R1, it did not for me. You may be limited to using the switch function. I’d like to see what you end up doing.

Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • October 31, 2022

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
P
Semi-Pro II
Forum|alt.badge.img
  • podonnell11
  • Author
  • Semi-Pro II
  • Answer
  • October 31, 2022

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

Chris,

I used Source Object Document, and Document.DateSeqNbr -- I believe it may have already been in there. The bank was fine with numeric codes.

 

 

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