web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Actual inventory value report

(0) ShareShare
ReportReport
Posted on by 8

Hi All ,

Can i know which report is available in Dynamics to have the actual inventory value and unit cost price  if the client uses standard cost ?

Already crated the inventory value report in the Inventory module ------- Inventory value report setup has an option - Average unit cost - Calculate average unit cost . If this field enables system pickup the average unit cost in the inventory value report than standard cost value .

Any assistance how to over come this issue ?  

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,045 Moderator on at

    Hi,

    I think Inventory value report is the best report in D365 for inventory valuation but for getting standard cost you might need to calculate manually based on total value and quantity .

    Otherwise you can also extract the standard cost for all items separately from item master or cost management

  • lally Profile Picture
    8 on at

    Thanks ,but the items transaction volume is huge and any light which table fields data to be exported/extracted to have total value and qty.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    20,713 Most Valuable Professional on at

    Hi,

    You may try this functionality.

    learn.microsoft.com/.../inventory-aging-report-storage

  • lally Profile Picture
    8 on at

    Hello All ,

    Thanks for the reply ,

    Item transactions exported to excel and done some analysis . It's noticed that inventory transactions cost amount was correct as per the standard cost price is defined ,but inventory value report and inventory aging report shows different total amount value and average cost price .

    Ideally reports should have actual total value and standard cost price.

    Any light why and how to address this issue or which report shows the correct inventory value as per standard cost price ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 616

#2
André Arnaud de Calavon Profile Picture

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

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 331 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans