Hi,
I want to know the opening and closing stock of an item and receipt again the vendor
Hi,
I want to know the opening and closing stock of an item and receipt again the vendor
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
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
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
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 "
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
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
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
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
Hi Sriram GS,
Have you tried using the vendor item statistics report?
Best regards,
Ludwig
Abhilash Warrier
225
Martin Dráb
174
Most Valuable Professional
Adis
132
Super User 2025 Season 1