Stock Report

[Former Member]

Hi All,

I want to know what was my instock for an Item on a given date. How do I retrieve that? Say Today I want to see for a particular Item what was my instock qnty in a warehouse on 31st August08.

Regards,

Raj.

[Former Member · Accepted solution]

hii

refer this thread

gud luck

Riyaz

[Former Member · Accepted solution]

Hi Riyaz,

I intend to have customized report Item group wise total in the format

Item code Item group Opening Qty In qnty Out Qty Closing Balance

The Opening Qty = ( Closing Balance+In-Out)

The In and Out qty can be obtained from OINM

But the issue is the closing Balance, The Instock of an item at a particular date!! From where to retrieve that via query? I have seen the audit report and that is the reason I find this should be possible. But I require guidance as I have tried all ways out from my end but stuck!!

Raj

[Former Member]

What you requested report is very complicated by a single SQL query. That is because you have to rebuild all your inventory transactions to filter out the transactions between your report date to current date. You may need to use a temporary table to complete it.

Thanks,

Gordon

[Former Member]

Hi Gordon,

I also do feel the same, thanx that it is reinforced by you. Can you give me the suport to proceed for this. As this is a very normal report which the industry types ask for to submit to the bank especially smbs running on bank loan. They cannot generate the stock report on the particular date as supposed as due to small employee strength document posting remains pending. So they generate the report at a later date of the stock status at that time.

I have taken a task to make this report. If you can suggest me how to proceed, if you have an idea then we can proceed for the same to make a sensible thing. I would be obliged for your support in this regards.

I have no idea of after creating a temporary table, how to put the relvant data there. I will seek your guidance in this regards.

Regards,

Raj

[Former Member]

Avtar singh ji,

The system reports do not meet the requirement as I intend to make the report group wise. The audit report is ok but it does not show the entire item list but rather only the items undergone transaction in the specified date of report generation. So, what gordon suggested does make sence to me. But I need some guidance to proceed. If you have any idea about how to proceed then it will be a valuable guidance for me. I hope you are aware of the indian business scenario and this is a report normally required in all indian smbs. So this will be a base for all the consultants to use. I will seek your suggestions if any useful in this regards.

Regards,

Raj

[Former Member]

Debra,

If you do your stock audit report with a posting date range from = blank and to = the date you want to see to, then you will get a report showing qty and value on hand as at that date, which should agree to the General Ledger balance.

This would be the normal reporting to accountants or banks to support asset values?

[Former Member]

Unfortunately, I donu2019t think here is the right place to handle this kind of queries. It may become a small project. You have to try your own first. I am ready to answer your further questions when you start you task. The first step would be to understand how system calculates the inventory value. Then you will know how to proceed after creating temporary table.

Thanks,

Gordon

[Former Member]

Hi

Please note down

Please use the Inventory posting list and fill date and select warehouse and items according to your choice after u get report uncheck the monthly ,yearly subtotal .

I hope this will work

If not plz let me know I will help u

Avtar Singh Saini

[Former Member]

hi

please note

Go to Reports >inventory >Inventory Status and select the item for which u want to see the stock it will provide the details

if you want a range of items please select the range instead of same item in both column .

if u want inventory for a item group select that group

if u want inventory for items according to there properties select the properties

i hope this will help u

u can also go for inventory in warehouse report to see the warehouse wise stock of item or items

please let me know if it did not help u

i will help you

Avtar Singh Saini

[Former Member]

Avtar Sigh Ji,

The reports you mentioned will give me the current stock. I want to see the back date stock!! Like as what was my instock in a date say 2 months back from today.

Regards,

Raj

[Former Member]

Hi debraj,

The inventory audit report can provide you date wise selection criteria. The only thing you need to keep in mind is that change the "system date" to "posting date".

Regards,

Joseph