web

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

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 value from inventTrans table with respect to 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. and then i wanted this field into view i defined the inventTrans in a query of a View. 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)

Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

how to get the sum of cost value from inventTrans table with respect to Warehouse in d365fo.

Hi, You can create Display method in View for costValue.

https://vishaldobariya.wordpress.com/2019/03/08/display-method-on-views-and-ssrs-reports-d365fo/

Was this reply helpful? Yes No
Munib Ahmed 31 on at

Like (0)

Report

how to get the sum of cost value from inventTrans table with respect to Warehouse in d365fo.

Hi,

I already added the method but it is not working correctly.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

André Arnaud de Cal... 734 Super User 2025 Season 2

#2

CA Neeraj Kumar 636

#3

Martin Dráb 553 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans