Skip to main content
Question

Business Event Not Triggering as Expected When Using CustomerID as Condition (24R1)

  • August 3, 2025
  • 4 replies
  • 80 views
variuxDavidE
Varsity I
Forum|alt.badge.img

Hi everyone,

I’m trying to create a business event to trigger a branch-specific email invoice template from the Invoices and Memos screen (AR.30.10.00). Since Branch is not available as a condition on the Business Event screen, I attempted to use CustomerID as a workaround—our customer IDs are prefixed by branch, so it seemed like a logical substitute.

However, it appears that the Business Event is evaluating the CustomerID field as the database row ID rather than the actual Customer CD (e.g., D1001). Because of this, conditions like CustomerID CONTAINS 'D' fail to trigger correctly.

I confirmed that using RefNbr as a condition works as expected, which leads me to believe this is a limitation with how the Business Event engine handles keys versus user-facing fields.

Has anyone else experienced this behavior in 24R1?
Any workarounds other than changing to branch-specific invoice numbering?

Thanks in advance!

- David Edmonson, Variux.com, Acumatica and Ecommerce Project Management and Turnarounds

4 replies

O
Acumatica Employee
Forum|alt.badge.img
  • Ola Ayanlaja
  • Acumatica Employee
  • August 4, 2025

Hi ​@variuxDavidE How about creating a GI with simple conditions like below (either using the contains or using the branch) and tied the Business Event to it and trigger on Record inserted

 

Chris Hackett
variuxDavidE
Varsity I
Forum|alt.badge.img
  • variuxDavidE
  • Author
  • Varsity I
  • August 4, 2025

​@OlaAyanlaja62 I tried that, but I think my skills in making a Business Event work from a GI still needs some practice. I was able to get the business event to recognize the new record being added to the GI, but it would not actually trigger the email. 

For now I was able to work around the issue by updating the sequence numbers for the branches. I will give your solution more effort and report back. 

- David Edmonson, Variux.com, Acumatica and Ecommerce Project Management and Turnarounds
Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 25, 2025

Hi ​@variuxDavidE 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*.
variuxDavidE
Varsity I
Forum|alt.badge.img
  • variuxDavidE
  • Author
  • Varsity I
  • September 25, 2025

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

No, Acumatica support acknowledged the issue but said that they do not consider it a bug. This screen uses the entity id which is an integer, not the actual AccountCD.

- David Edmonson, Variux.com, Acumatica and Ecommerce Project Management and Turnarounds
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