Get the lowest status for a group of sales orders

poppins

Hi everyone,

I have added a custom field "StatusX" in table 36 of type option (op1,op2,op3)
In another specific table, I need to create a field that determines the lowest status for a given group of sales orders.
For example:
If I have order A with StatusX=op3, order b with StatusX=op1 and order C with StatusX=op2, I should get op1 in my field.
Is that possible?

Thanks in advance

andrewt

I would suggest using a flowfield in your "SpecificTable" of type option with the same option string then StatusX from table 36 and Calc Method "Min". Use appropriate table filters for the source table on your flowfield definition to define the group of sales orders.

Hope this helps
Andrew