web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... how to get the sum of ...

Finance | Project Operations, Human Resources, ...

Suggested Answer

how to get the sum of cost amount from inventTrans table with group by Warehouse in d365fo.

(0) Share

Report

Report

Posted on by Munib Ahmed

31

I want sum of cost value but the cost value is not field actually its a method i want the sum of that by warehouse you can group by warehouse. I want qty, cost value and i get the qty field sum by this method and it worked:

And i tried this method for cost value but it is not working:

please suggest me any solution for getting sum of cost value from InventTrans by warehouse.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Munib Ahmed 31 on at

Like (0)

Report
Copy link

Link copied!

HiGirishS,

Can you help with this problem.
I want sum of cost value but the cost value is not field actually its a method i want the sum of that by warehouse you can group by warehouse. I want qty, cost value and i get the qty field sum by this method and it worked:

And i tried this method for cost value but it is not working:
please suggest me any solution for getting sum of cost value from InventTrans by warehouse.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 306,446 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Munib,

You can better use the table InventSum as a base to create these queries. You can then directly query for the sum of some quantity and value fields. It is easier and much better for performance considerations.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 382 Super User 2026 Season 1

#2

Martin Dráb 265 Most Valuable Professional

#3

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans