News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Al Languauge Query-

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

Suggested answer

Al Languauge Query-

(1) Share

Report

Report

Posted on by aqeel2020uae

24

Dears.

I am writing API query object i want to get sum of Quanity and Sales Line Total from Sales Archive table for last version number only.

.Lets say i have 3 Version..i Need last record. Sum(Quantity) + Sum(Total Lines Amount)

I tried with sum and Max method..but not working.

any suggestions. plz.

Thanks in Advance.

Aqeel.

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

aqeel2020uae 24 on at

Like (0)

Report

Al Languauge Query-

Dear

Thanks a lot for your help.

But where i can use filter for document number its givng me max of lines table not for same docuemnt.
Suggested answer

YUN ZHU 75,942 Super User 2024 Season 2 on at

Like (0)

Report

Al Languauge Query-

Hi, try adding two levels of DataItem (same table), using the Max method at the root level to collect lines, and then using Sum method in the child DataItem to get the total amount.

Sorry the example is not exactly the same, it is somewhat similar to the following.

More details: https://yzhums.com/14547/

Hope this can give you some hints.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,476 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans