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

API Query Total from Header VS Lines

(1) Share

Report

Posted on by aqeel2020uae

Dears.

Thaks in Advance.

1-I am trying to create WEB API Query Getting Latest Version and Getting Grand Total of PO. After trying to get Lines Total for same version but i want to have column from Lines Sumof Drop Ship Items and Freight seprate columns.

So one Line of Header will be unique with details.

2-Any Other Way to Get Max/Latest Version and sum the Line Based on Filter?

PO_No	PO_Vnd_Name	PO_Date	PO_Currency	PO_Status	PO_Total	Version_NoLinePO_	Po_Line_Tot
PO-WE/2023/1517	AYK TRADING LTD	02/12/2023	GBP	Released	12423.58	3	16364.21
							WRONG TOTAL

Categories:

Business Central

All responses (3)

Answers (0)

aqeel2020uae 62 on at

Like (0)

Report

API Query Total from Header VS Lines

Thanks a lot gdrenteria for your time and efforts and replying me in easy way.

https://community.dynamics.com/profile/?userid=2b1278f4-7438-eb11-a813-000d3a579c39

Aqeel.
Suggested answer

YUN ZHU 73,718 Super User 2024 Season 2 on at

Like (0)

Report

API Query Total from Header VS Lines

Hi, Just to add some information, if Query is difficult to do, it is recommended to use page.

https://yzhums.com/4869/

Hope this helps.

Thanks.

ZHU
gdrenteria 12,250 Most Valuable Professional on at

Like (1)

Report

API Query Total from Header VS Lines

Hi, good day
I hope this can help you, and give you some hints.

How to group data in AL? Best practicies. Performance review.

Best Regards
Gerardo