Small and medium business | Business Central, N...

The highest version Number

(1) Share

Report

Posted on by SM-29041600-0

Hi All,

I am trying to calculate the sum of the line Amount from the Purchase line archives table but, I need just the highest /version No./ foreach line and with the same /Job No./,
I tried this but it's not working.

Can anyone Help please?
Thank you.

I have the same question (0)

All responses (3)

Answers (0)

Yael Suarez 131 on at

Like (1)

Report
Copy link

Link copied!

Hello, how have you tried to try with

VariableRecord.SetCurrentKey(Version No);
VariableRecord.SetAscending(Version No, true);

substituting the version setrange into your line of code
I hope this can help you

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,039 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

Or using Query may be simpler and more efficient.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-method-property?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
SM-29041600-0 8 on at

Like (1)

Report
Copy link

Link copied!

Hi All,
Thank you very much for your response!
I tried to work with the query, it brings the last version, but I need to sum the line_amount for the records with the same "Job No."

This is my query:

query 50100 "Purchase Line Archive ZWT"

{

QueryType = Normal;

OrderBy =descending(Version_No_);

elements

{

dataitem(Purchase_Header_Archive; "Purchase Header Archive")

{

column(No_; "No.")

{

}

column(Document_Type; "Document Type")

{

}

dataitem(Purchase_Line_Archive; "Purchase Line Archive")

{

DataItemLink = "Document No." = Purchase_Header_Archive."No.", "Document Type" = Purchase_Header_Archive."Document Type";

SqlJoinType = InnerJoin;

column(Document_No_; "Document No.")

{

}

column(Line_No_; "Line No.")

{

}

column(Job_No_; "Job No.")

{

}

column(Version_No_; "Version No.")

{

Method = Max;

}

column(Line_Amount; "Line Amount")

{

}

}

}

}

trigger OnBeforeOpen()

begin

end;

}

Was this reply helpful? Yes No