Last Version of each sales orders in Sales Header Archive

chafor

Hi I'm new to Nav and I would like to return with a Query Object the last version of an order in the table "Sales Header Archive".

I've tried to use the Max method but Nav return an error saying It's only for Decimal field.

Any Idea, how it can be done?

Thank you,

ara3n

You need a new field and set it to true when creating the record new record, and set the other record to false.

chafor

I see like that I would be able to put a filter on the new column in my query I'll use that method as a last resort, since I think it's a bit to expert level for me.

Wouldn't there be a way to add a field in the archived table to convert dynamically the Version_No to Decimal?

I've tried a field Lookup with my partner but we got same problem Nav can't convert the field from integer to decimal.

Thank you,