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

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Verified answer
    CarmenNunes Profile Picture
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans