Line Loop - update FMS before run?

Answered

Keith Beall

• September 24, 2019 15:22

I have a line loop running on Sales order that compares line quantity to a UDF which is updated via Formatted Search.  

On some orders (imported from EDI) the UDF doesn't get set by the Formatted search.  This then causes an error as the line loop has to divide quantity by the UDF (order multiple), so empty field results in divide by zero.

Is there a way to update the field during the line loop (i.e. if value is zero then update the FMS) but crucially before the check which the line loop is there for?  Or should I be setting a separate line loop before the original one triggers?

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • February 18, 2020 16:39

  Hello Keith,

  We don't suggest the use of formatted searches in the windows where you have Boyum configurations, I suggest to use a B1 validation with a Set command instead.

  This video has more information regarding this issue:

  https://youtu.be/VXTx6ULH348
• 

  Keith Beall

  • July 22, 2022 13:25

  A very late thank you, this did exactly what I needed!

Please sign in to leave a comment.