mibuso.com
Home› NAV Three Tier
Options

Last Version of each sales orders in Sales Header Archive

chaforchafor Member Posts: 3
edited 2013-11-22 in NAV Three Tier
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,

Comments

  • Options
    ara3nara3n Member Posts: 9,256
    You need a new field and set it to true when creating the record new record, and set the other record to false.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    chaforchafor Member Posts: 3
    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. :wink:

    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,
Sign In or Register to comment.