Skip to main content
Solved

IF statement in import Scenarios

  • December 10, 2024
  • 7 replies
  • 92 views

Forum|alt.badge.img

Hello all. I am using an import scenario tied to a Business event to update Project tasks. If task A gets completed, tasks B,C and D get completed as well.  This works great except not all Projects have task B,C and D. If I run it and a task is not there it errors our.  Is there a way to suppress the error and continue? Is there a way to see if the tasks exists first and if not skip?

I unchecked the “Break on” Check boxes but it still does not work.

My rules for task completion are long, and creating filter/rule and scenario for each possible combination would be almost impossible.

 

Thank you all

 

 

Best answer by keithschm

Yes, a custom object was created to hold the rules. Main task and sub task. The business event was changed to look at that  object to pull the correct tasks yo complete.

View original
Did this topic help you find an answer to your question?

7 replies

darylbowman
Captain II
Forum|alt.badge.img+13

Have you tried ‘Ignore Error’ on the line?

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • 36 replies
  • December 10, 2024

Thank you, yes I did. It still Errors with “ Description cannot be empty’ Like it is trying to insert the task. 

 

 


darylbowman
Captain II
Forum|alt.badge.img+13

Ah, yeah, it will try to insert. I’m not sure if this is possible, but if it is, you probably need to use @@TaskID to update the existing lines. ​@Manikanta Dhulipudi might be able to help.


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

@keithschm Could you please share the import scenario xml file and let me know what are your trying to update?


Forum|alt.badge.img
  • Author
  • Varsity I
  • 36 replies
  • December 10, 2024

Sure, Thank you very much!

 I have business rule and filter that executes import Scenario  that says. If Task ID “A”  gets changed to 100% Then Set Task ‘B,C,D’  to 100% and sets Completion Method to Manual. Works great if the project has  tasks, A,B,C,D.  Some Projects only have A,B,D or A,C,D Etc…  If the Task is not there it looks like it is trying to Insert it as I get an Error “Description cannot be empty”.  I have unchecked both “Break on”, I have Checked “Ignore Error” but it still will not go past if the Task does not Exist.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2754 replies
  • January 24, 2025

Hi ​@keithschm were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Varsity I
  • 36 replies
  • Answer
  • January 24, 2025

Yes, a custom object was created to hold the rules. Main task and sub task. The business event was changed to look at that  object to pull the correct tasks yo complete.


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