Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Munib Ahmed

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 (2)

Answers (0)

Munib Ahmed 31 on at

Like (0)

Report

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... 301,146 Super User 2025 Season 2 on at

Like (0)

Report

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

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates