Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

higher version in 'Purchase Line Details Archieve'

(0) ShareShare
ReportReport
Posted on by 1,893

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
    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
    1,893 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
    60,226 Super User 2025 Season 1 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
    1,893 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
    60,226 Super User 2025 Season 1 on at
    RE: higher version in 'Purchase Line Details Archieve'

    what is the issue now?

  • manish.yadav Profile Picture
    1,893 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
    60,226 Super User 2025 Season 1 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
    1,893 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
    5,569 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
    60,226 Super User 2025 Season 1 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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans