Get the lowest status for a group of sales orders

poppins
poppins Member Posts: 647
edited 2015-01-20 in NAV Three Tier
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 :mrgreen:

Comments

  • andrewt
    andrewt Member Posts: 73
    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

Categories