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?
Please sign in to leave a comment.