Skip to main content
Solved

Is it possible to automatically check/uncheck this 'Release for material Planning' depending on the Customer Order Header status?

  • November 29, 2021
  • 1 reply
  • 206 views

Forum|alt.badge.img+4

 The field on Customer Order Lines 'Release for Material Planning' where if unchecked, item is not considered by MRP.

 

Is it possible to automatically check/uncheck this 'Release for material Planning' depending on the Customer Order Header status?

Checkbox OFF all lines if customer order header is blocked or planned?

Checkbox ON all lines if customer order header is any other status?

 

Best answer by william.klotz

Hi @Manjari Nigamuni ,

 

I’m not aware of IFS having the built in functionality you’ve described but you could accomplish it by creating a custom event and event action.  You may want to trigger your event when a new order line is added to a customer order then on the event action only run the action when the customer order header is set to planned state.    It would require you to create some PL/SQL code and you’d most likely have to run the code in the background to avoid the mutating trigger notification from Oracle.    While we haven’t done this ourselves we have several custom events and event actions when customer order lines are added or changed and it works well.

 

Regards,

William Klotz

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

william.klotz
Superhero (Customer)
Forum|alt.badge.img+21
  • Superhero (Customer)
  • 479 replies
  • Answer
  • November 29, 2021

Hi @Manjari Nigamuni ,

 

I’m not aware of IFS having the built in functionality you’ve described but you could accomplish it by creating a custom event and event action.  You may want to trigger your event when a new order line is added to a customer order then on the event action only run the action when the customer order header is set to planned state.    It would require you to create some PL/SQL code and you’d most likely have to run the code in the background to avoid the mutating trigger notification from Oracle.    While we haven’t done this ourselves we have several custom events and event actions when customer order lines are added or changed and it works well.

 

Regards,

William Klotz


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