Skip to main content
Question

How to send an email notification to the user when the bill count exceed more than 2?


Forum|alt.badge.img

Hello,

One of our customer has the below requirement.

In the Bills and Adjustment form, we have enabled a new field to record the  contract number. Our customer is getting bills (Supplier invoices ) for utility expenses from their suppliers and our customer is recording each bill against a particular contract number. If the bill count is exceed 2 for a particular contract the user needs to get notified through an email. 

As an example:

Lets assume we received a utility bill from supplier ABC for the contract 001. 

Then again we received another bill from the supplier ABC for contract 001. At this point, we have two bills against for the contract 001. Assume we are getting third bill for the contract 001. Once we entered the third bill to the system, system should generate and email.

How can we cater this requirement?

TIA

Michelle

2 replies

Forum|alt.badge.img
  • Jr Varsity II
  • 13 replies
  • January 6, 2025

Hi ​@MWijesuriya43 

Creating a business event with the conditions that when the Bill count is equal to 3 , the BE   should trigger and send out an email. 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 16 replies
  • January 6, 2025

@TitileGama,

 

I tried this way. But I have encountered with an problem. I added schedule to the business event and every time the business event triggered it generate emails for all the records in the Generic inquiry. But my requirement is to generate the email only for the newly added records. When I use the trigger condition as the Insert new record, I couldn’t give the condition of “Greater than 3”. 

Do you have any suggetion on this.

Thanks!


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