Question

Custom event to send an email to the coordinator on the customer order

  • 1 March 2022
  • 2 replies
  • 335 views
L
Rank
Userlevel 5
Badge +7

Hi,

Please assist on below scenario:

In the case of Customer Orders with a source code of ‘Inter-Site Direct’ and ‘Inter-Site Transfer’, date changes originating from the supply site are conveyed back to the demand site’s Customer Order in IFS in the following order:

 

Supply site (eg: Shop Order) > Supply site Customer Order > Demand site Incoming Purchase Order Confirmation/PO > Demand site Customer Order

 

The Incoming Purchase Order Confirmation (IPOC) on the demand site requires someone to approve the change in order to push the change to the demand site Customer Order.

The person approving IPOC may or may not be the same as the Coordinator on the demand site Customer Order.

Since the approval of IPOC automatically changes the Planned Delivery Date/Time on the demand site’s Customer Order, an email notification is needed to advise the Coordinator on the Customer Order that the date change occurred.

 

How this can be facilitated via a custom event?

Please share your thoughts.

 

Thanks and Regards

Lakmini

This topic has been closed for comments

2 replies

Darshana Herath
Rank
Userlevel 6
Badge +14

@Lakmini Weerakoon 

 

You can create a custom event with an event action that the action type is “Execute Online SQL”

 

Psudo code for the SQL Statement,

 

BEGIN

 

   IF the Planned Delivery Date/Time on the demand site’s Customer Order is changed THEN

 

       command_SYS.Mail('<app owner>', '<email address>', ‘<mail body>’,     NULL, NULL, '', '<mail subject>', NULL, NULL, NULL, NULL);

  

   END IF;

 

END;

 

https://www.linkedin.com/in/darshana-herath
william.klotz
Rank
Userlevel 7
Badge +21

Hi @Lakmini Weerakoon ,

 

We are using IFS Application 10.

 

You could also take a look at the built-in event called ADJUSTED_PO_PEGGINGS and create an action like below to notify the coordinator and/or buyer of a change to pegged quantity or planned ship date.

 

 

Regards,

William Klotz

Terms & ConditionsCookie settings