Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Opening and Closing stock of item

(0) ShareShare
ReportReport
Posted on by 781

Hi,

I want to know the opening and closing stock of an item and receipt again the vendor

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Opening and Closing stock of item

    Hi Sriram,

    "the closing and opening stock of an item is a dynamic data , which changes time to time not like a transaction for which we have an entry journal / voucher from where we can get the details "

    ... this is right

    It depends on the period that is selected what opening or closing balance are calculated (e.g. month, quarter, years...)

    Best regards,

    Ludwig

  • sriram Profile Picture
    781 on at
    RE: Opening and Closing stock of item

    HI Ludwig,

    Ok lets wait for some one to suggest.

    In the meantime, my understanding of the opening and closing inventory is right? please comment

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Opening and Closing stock of item

    I see.

    As I am not a developer I cannot really help you much with the code.

    Let's thus wait for some other community members with a technical background to jump in and provide some feedback.

    Best regards,

    Ludwig

  • sriram Profile Picture
    781 on at
    RE: Opening and Closing stock of item

    Hi ,

    I need some support how to fetch the data , coding etc., to develop the report ffrom the community.

    on the other hand , 

    please correct me , on the following understanding  "the closing and opening stock of an item is a dynamic data , which changes time to time not like a transaction for which we have an entry journal / voucher from where we can get the details "

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Opening and Closing stock of item

    Hi Sriram GS,

    I see.

    And your job is to develop a new report similar to what is used in these two reports, right?

    What is it that you expect exactly from the community in this regards?

    How to create this report or a code sample or something else?

    Best regards,

    Ludwig

  • sriram Profile Picture
    781 on at
    RE: Opening and Closing stock of item

    Hi Ludwig,

    My requirement is similar to combination of the below 2 reports

    1. inventory status report ( China report)

    2. Vendor / Item statistics

    The main aim to know the Purchase of items from a vendor over a specified period, with opening and closing stock of the respective item across all warehouse

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Opening and Closing stock of item

    Hi Sriram GS,

    There is no such report available.

    I do not even know how you would design such a report because the opening and closing stock details do not depend on a specific vendor unless you have a warehouse for each of your vendors.

    Can you let us know how you want to determine the opening and closing stock details?

    Best regards,

    Ludwig

  • sriram Profile Picture
    781 on at
    RE: Opening and Closing stock of item

    Hi Ludwig,

    this report helps to get the details of the items purchased from the specified vendor for the specified

    period

    Need to have opening and closing stock details also

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Opening and Closing stock of item

    Hi Sriram GS,

    Have you tried using the vendor item statistics report?

    Best regards,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 225

#2
Martin Dráb Profile Picture

Martin Dráb 174 Most Valuable Professional

#3
Adis Profile Picture

Adis 132 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans