Skip to main content
Answer

Trigger Business Event of UDf

  • September 18, 2024
  • 7 replies
  • 123 views

Forum|alt.badge.img+3

Hi, All I am trying to trigger event that is to send email when ever udf is updated with new value. The UDF is in the Customer screen as shown below. I have already created a business event and email notifications and I tried adding UDF with API but still no emails. Is this generic Inquiry Relation issue or something else?

 

 

 

Best answer by hgilbert

The multiple line issue occurs when you have a table with a single line connected to a table with multiple related line.
The best example of this is the AP Invoice Table and AP Invoice Tran table. Every AP invoice has one vendor, one invoice number etc - but some of them may have multiple transaction lines. When you connect the two together you see the data from the Invoice table repeated for every line that’s displayed of the Tran table.

A way to work around this is to utilize a subreport.

7 replies

Forum|alt.badge.img+1
  • Varsity I
  • September 18, 2024

Hello ,

Your Generic Inquiry doesn’t look like it has anything in it.
Can you send a screen shot of the Tables and the Results Grid

 


The business event will be triggered when something populates into the Generic Inquiry.


Forum|alt.badge.img+1
  • Varsity I
  • September 18, 2024

If I understand what you’re trying to do correctly, you could duplicate the Customers Generic Inquiry, and add an additional column for the User Defined Field.

Page AR3030PL
 

 

Then in the business event select

 

 

 

In the Trigger Conditions of the Business Event you would then specify Field changed and the table and UDF field.

 

 


Forum|alt.badge.img+3
  • Author
  • Captain I
  • September 19, 2024

Hi,

I have solved this problem . But now every customer is repeating like 100 times in GI. Look at the screen shots.

 


Forum|alt.badge.img+3
  • Author
  • Captain I
  • September 19, 2024

Please guide . I have added value manually to AGDCRan but still nothing shows up in the GI

 

 

 


Forum|alt.badge.img+1
  • Varsity I
  • Answer
  • September 19, 2024

The multiple line issue occurs when you have a table with a single line connected to a table with multiple related line.
The best example of this is the AP Invoice Table and AP Invoice Tran table. Every AP invoice has one vendor, one invoice number etc - but some of them may have multiple transaction lines. When you connect the two together you see the data from the Invoice table repeated for every line that’s displayed of the Tran table.

A way to work around this is to utilize a subreport.


Forum|alt.badge.img+3
  • Author
  • Captain I
  • September 19, 2024

I have already resolved that issue and it looks good to me now. Only trying to fill AGDCRAN column with  values but still null. Trying to figure out what’s the problem


Forum|alt.badge.img+3
  • Author
  • Captain I
  • September 20, 2024

Thanks All. I have found the solution.