higher version in 'Purchase Line Details Archieve'

(0) Share

Report

Posted on by manish.yadav

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

I have the same question (0)

All responses (17)

Answers (6)

Indikauk 1,759 on at

Like (0)

Report

Archive line has "Version No." & Archive Header has "No. of Archived Versions" just compare "Version No." = "No. of Archived Versions" you need to write proper code and you can get filter only the last no version no.

Thanks,

Indika.

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

or you can create a query object to get the max version no.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

As Mohana suggested create Query in system and use that query to display the records.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

I have done in sql server 2012 query. My task is I want to do implement in NAV page.

manish

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

you need to create query object in NAV and not in SQL

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

I do not know..how to create query object in NAV. Please suggest me how to do it.

manish

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Look at this link for creating queries

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

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

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

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

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.

Was this reply helpful? Yes No