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 :
Small and medium business | Business Central, N...
Answered

Stock report by months

(0) ShareShare
ReportReport
Posted on by 5

How can I make a report with the stock I had each month?
For example the stock of a product the first of each month.
Is this data in a table to export it to Power BI?

Thank you

  • Verified answer
    CarmenNunes Profile Picture
    Microsoft Employee on at

    Hello

    You can have a full picture of your Stocks via Inventory Valuation Report. With this report you will be able to extract information with different filters:

    -Starting and Ending Date

    -Range of Items or all

    -For specific Inventory Posting Group or All

    This report is based on Data achieve at Table 5802 Value Entry, which allow you to know the real value of your Inventory (increases and decreases) during a period of time.

    Beside Table 5802 you can also check Item Entries at table 32 , however in this table you have less information regarding Inventory Valuation.

    Hope this help you.

  • Max Prower Profile Picture
    15 on at

    Hi Carmen,

    is there's a way to see the inventory values

    per each item (raw/wip)

    per each month

    for the last 12 months ?

    This could be useful to analyze the evolution of the stock per item during a time fence.

    Is there other way to advice to have this kind of info?

    Thanks

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 Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 676 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 483 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 310 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans