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, ...
Answered

How can i get a report for the weighted average cost of items

(0) ShareShare
ReportReport
Posted on by 25

Hi guys,

i need to know a away to get a report of WAC (weighted average cost) of the items. thanks

I have the same question (0)
  • MATTGUO Profile Picture
    22,349 Moderator on at

    Hi Hesham,

    Do you need a report to display all the transactions for all items of weighted average cost model?

    Could you give more details about your requirement?

  • Hesham Attieh Profile Picture
    25 on at

    Hi Mattguo; appreciate your support

    i need to display all item codes along with their weighted average cost (not latest item price) in one page

    FYI;

    what i can get currently is the latest price of all items in one report, from 

    Cost management > Inquiries and reports > Predetermined cost reports

    i want the same, but WAC instead of latest item price

    thanks in advance

  • Verified answer
    Rahul Mohta Profile Picture
    21,042 on at

    one the best place is to use inventory value report storage

    it's a feature which needs to be enabled

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Hesham,

    Doesn't the inventory value report give you that information?

    Best regards,

    Ludwig

  • Verified answer
    MATTGUO Profile Picture
    22,349 Moderator on at

    Hi Hesham,

    As mentioned by others above, please check inventory value report.

    Create the format in Cost management > Inventory accounting policies setup > Inventory value reports with Calculate average unit cost , and then create report in Cost management > Inquiries and reports > Inventory accounting - status reports > inventory value.

  • Hesham Attieh Profile Picture
    25 on at

    thank you so much,

    problem solved guys with this way, really appreciate your help

  • Verified answer
    MATTGUO Profile Picture
    22,349 Moderator on at

    Hi Hesham,

    Thank you for your response, please leave a little time to verify the helpful answers.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

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

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans