Can I use FINDLAST function on date and time?

PanJ
PanJ Member Posts: 34
in NAV/Navision Classic Client
Hello guys,

I have a question.
I have to attach the last modify user's signature on report so l check it by this ..

igg7twwn6wqz.jpg


"ApprovalEntry" keeps the last Entry No. of Approval Entry that filtered by Sales Quotation No. and status = Released.
we had no problem until this below happened

dx5rwmm3enr8.jpg


by Last Date-Time modified Entry No. 2380 was created before Entry No. 2381.

I would like to know is there the way that l can check last Date-Tim Modified instead of Entry No.?

Thank you for your help.

Answers

  • navdeveloper
    navdeveloper Member Posts: 23
    Hi,

    What about adding 'Last Date-Time modified' as a key and using 'SetCurrentKey'?

    Cheers
  • lubost
    lubost Member Posts: 633
    Navision ask every index to be unique and do that by adding primary key at the end of each index. So, you have to take it into considerantion.
  • PanJ
    PanJ Member Posts: 34
    Thank you guys, I'll try your advice. :)
  • sorenhinrup
    sorenhinrup Member Posts: 136
    To secure the unique key for this table I suggest you make a key as this: "Last Date-Time Modified, Entry No." This will sort your table on the date first and then the entry number.
    And as previously mentioned by navdeveloper use the setcurrentkey on the report.
  • lubost
    lubost Member Posts: 633
    If Entry No. is the primary key, you should create key with "Last Date-Time Modified" only. Entry No. will add NAV automatically by design.

Categories