News and Announcements icon

Dynamics 365 CommunityForums Business Central forum How filter sales order...

Business Central forum

Suggested answer

How filter sales order only the last version no

(0) Share

Report

Report

Posted on by Manuel Lozada

465

Hi community,

Do you know how i can filter archive sales orders only the last version?

I try to show in my cue, but still brings all version

If you know how, i will appreciate it.

Categories:

Project management

Reports and Business Intelligence

Integration to Power BI, Power Apps, Power Automate and Dataverse

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

TeddyH 12,861 Moderator on at

Like (0)

Report

How filter sales order only the last version no

You need to loop through each order no, get the latest version, and use that version to filter on it.

Example on how to get the latest version.

SalesHeaderArchive.SetRange("Document Type", DocType);
SalesHeaderArchive.SetRange("No.", DocNo);
SalesHeaderArchive.SetRange("Doc. No. Occurrence", DocNoOccurrence);
SalesHeaderArchive.FindLast();
exit(SalesHeaderArchive."Version No.");
Suggested answer

YUN ZHU 69,864 Super User 2024 Season 2 on at

Like (0)

Report

How filter sales order only the last version no

Hi, is it possible to try getting the final version number first and then filtering with it?

For example,

FieldRef.GetRangeMax() Method

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/fieldref/fieldref-getrangemax-method

Record.GetRangeMax(Any) Method

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-getrangemax-method

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2

Martin Dráb 228,552 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans