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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Quantity and value report of inventory

(0) ShareShare
ReportReport
Posted on by 432

Hello everyone!

I have a question - do you know any report in BC that can show me quantity and value of the inventory on exact day? And also split this outcome per locations? It can be also combination of two/three reports.  I have tested Inventory valuation and Item expiration quantity but I am looking for the best option. 

Thank you in advance for your answers! 

I have the same question (0)
  • Suggested answer
    Dynamics 365 Profile Picture
    6 on at

    Hi

    You can use Inventory Valuation Report from Base.

    pastedimage1672216815965v2.png

    pastedimage1672216850894v3.png

    pastedimage1672216806955v1.png

    Please Verify my answer if you found relevant.

    Hope it will help you.

    Thanks

  • Suggested answer
    Manan_Shah Profile Picture
    1,461 on at

    Hi Antonio,

    I suggest you can use Inventory Valuation. which have enough details what you are looking for. else you have build custom report. 


    Many Thanks,
    Manan 

  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 Moderator on at

    I agree with Aman, use the Inventory Valuation Report. You can also export the report to Excel if you want to process your data further.

  • Suggested answer
    Dallefeld Profile Picture
    235 User Group Leader on at

    Inventory Valuation report is great.

    It is important to understand that for inventory received but not invoiced, the quantity is included as well as an expected cost.

  • Suggested answer
    DAnny3211 Profile Picture
    11,423 Super User 2026 Season 1 on at

    hi

    as far as I know it should be the Inventory Valuation Report

    DAniele

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,250 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,799 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,390

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans