Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

higher version in 'Purchase Line Details Archieve'

Posted on by 1,835

Dear All,

I have manually prepared the page the name as 'Purchase Line Details Archieve'. But this page showing the all records...Here I want to see the max version no records only . 

Please have a look in the screenshot. You can understand my exact issue.

I want to show the higher version here. How to do that.?

3323.UU.png

regards,

manish

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: higher version in 'Purchase Line Details Archieve'

    Do you need old versions? If not you may create a procedure in SQL server that delete all versions except last.

    Best performance and no code in NAV

  • manish.yadav Profile Picture
    manish.yadav 1,835 on at
    RE: higher version in 'Purchase Line Details Archieve'

    you mean it is not possible in NAV 2013.

    if it is not possible in NAV 2013., please close this incidents.

    manish

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: higher version in 'Purchase Line Details Archieve'

    I am able to set Max method on Version No. (Integer) field in NAV2016.

  • manish.yadav Profile Picture
    manish.yadav 1,835 on at
    RE: higher version in 'Purchase Line Details Archieve'

    5707.UU.png

    Dear Sir,

    while trying, getting this error message. Plz look in the screenshots.

    manish

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: higher version in 'Purchase Line Details Archieve'

    what is the issue now?

  • manish.yadav Profile Picture
    manish.yadav 1,835 on at
    RE: higher version in 'Purchase Line Details Archieve'

    Hello Dear,

    Version No. is a Integer type field.

    manish

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: higher version in 'Purchase Line Details Archieve'

    Use English language while posting in forum.

    Keep Version No. field also column type and set Method type as Totals and set method as Max

  • manish.yadav Profile Picture
    manish.yadav 1,835 on at
    RE: higher version in 'Purchase Line Details Archieve'

    4628.UU.png

    I have prepared the query in Nav 2013...but maximum version ke liye code kahan likhenge..aur kay likhenge..

    I am unable to set it.

    please help me.

  • Verified answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: higher version in 'Purchase Line Details Archieve'

    Hi

    You can refer the below link how to create query & how to use in Pages

    https://dynamicsuser.net/nav/b/mark_brummel/posts/tip-35-using-queries-in-pages-amp-reports

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: higher version in 'Purchase Line Details Archieve'

    msdn.microsoft.com/.../hh168775(v=nav.90).aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans