Load data from different ido into notify statement in Application Event System

I am attemption what seems like a simple task

I have created an even to notify a user if a Customer Order Line is saved in planned status. I want the notify statement to include the credit limit for the customer affected. The event triggers against the SLCoitems IDO, but the Credit Limit value resides on SLCustomers. I am attempting to use the Load IDO Collection event action to capture the credit limit from customers into a variable vCreditLimit and print it in the notify e-mail, but it always returns null.

Where have I gone astray? The event fires and sends the e-mail, but the credit limit is NULL in the output, and I know that is incorrect.

Handler Description

Sequence

Access As

Applies To Initiators

Applies To Objects

Chronology

Keep With

Can Override

Ignore Failure

Synchronous

Transactional

Suspend

Active

Obsolete

Initial State

Initial Action

Applies To Sites

Event Name

Purpose

Triggering Property

Method To Call

_ATRO_Notify CO Line in Planned Status

Form.CustomerOrderLines

SLCoitems

IdoPostItemInsert

Action Sequence	Action Type	Action Description	Parameters
10	Finish		CONDITION(P("Stat") <> "P")RESULT("Order not saved in planned status")
15	Load IDO Collection	Get Credit Limit from Customers	IDO("SLCustomers")PROPERTIES("CreditLimit")DISTINCT(FALSE)FILTER(SUBSTITUTE("CustNum = {0}", FP("CoCustNum")))SET(R(vCreditLimit) = RESULT)
20	Notify		TO("davshe")SUBJECT("TEST")BODY(SUBSTITUTE("Credit Limit: {0}", FV(VCreditLimit), ""))SAVEMESSAGE(FALSE)PAYLOADACCESS(HIDDEN)

Find more posts tagged with

General Discussions

Accepted answers

unknown

Hi ReesH2. That fixed it! Thank you! Can you please remind me how to activate the Event Handler Status. I never see any results on that form. I know there's a setting I need to change to see output.

Rees Howel

Good point. I was being too literal minded. I thought Dave was getting an Event Status record with no Event Handler Status from his description.

The recommendation from Support would be to only make this change in your Test/Bike system not production. Otherwise the Event tables get huge and can impact performance (and they're a pig to purge - had to do that once, not to be repeated if at all possible).

All comments

Yao Jiang

Try vCreditLimit instead of VCreditLimit

unknown

I was really hopeful that was the issue, but it didn't help. Still getting a NULL value back from my LOAD IDO COLLECTION. Should I be using LOAD IDO ROW? Do I need to set my CustNum somehow? I was under the impression that it would pick that up from the event.

unknown

I did change my FP from CoCustNum back to just CustNum because I did another test to prove that CustNum had the data I needed.

monthly_proactive_com201101.pdf

Rees Howel

Hi Dave

Couple of things. For this kind of thing I'd favour using Load IDO Row

IDO("SLCustomers")PROPERTIES("CreditLimit")FILTER(SUBSTITUTE("CustNum = {0}", FP("CoCustNum")))SET(RV(vCreditLimit) = "CreditLimit")

Also, the substitute statement in your Notify action has FV in front of the Credit Limit variable. Mine doesn't and returns the expected value.

TO("reesh2")SUBJECT("Test")BODY(SUBSTITUTE("Credit Limit = {0}", V(vCreditLimit)))SAVEMESSAGE(FALSE)

I suspect the FV is main problem. If you check the variable values in Event Handler Status, it should show whether it's the variable value or its use which is causing the problem.

Regards

Rees

unknown

Hi ReesH2. That fixed it! Thank you! Can you please remind me how to activate the Event Handler Status. I never see any results on that form. I know there's a setting I need to change to see output.

Rees Howel

Really? I don't recall ever needing to.

Which version are you on?

acl

process defaults -

Rees Howel

Good point. I was being too literal minded. I thought Dave was getting an Event Status record with no Event Handler Status from his description.

Copyright © 2025 Infor. All rights reserved.