cancel
Showing results for 
Search instead for 
Did you mean: 

Warehouse wise back date stock

0 Kudos

Dear All,

I can get warehouse wise stock for all items, but this stock is current stock. My requirement is to get the stock on some back date, e.g. I wanna check the stock on 30th Nov 2012. Can anyone please help me to know that from which DB Table I can get the stock?

Regards,

Shehzad

Accepted Solutions (1)

Accepted Solutions (1)

edy_simon
Active Contributor
0 Kudos

Hi Shehzad,

There is no table stores the stock level for a certain date.

But there is this OINM (it is a table in older SBO versions, starting 8.8 it is a view).

This object stores all the transaction in and out.

You will need to query out from here.

Regards
Edy

0 Kudos

Thanks to all and sorry for late.

Yea Edy, you are correct I also did the same. But we know SQL so we got through that way but someone who do not know SQL then he must go through inventory audit report as suggested by Anu Verma.

Once again thanks to all...

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try with OITW table.

Thanks & Regards,

Nagarajan

Anu
Explorer
0 Kudos

Inventory audit report also gives the inventory as of a specific date

Anu
Explorer
0 Kudos

There is one more way you can try.

Go to inventory transactions, Inventory tracking and posting, choose the warehouse from the drop down. Then go to inventory posting tab, change the date that you want to see your stock. Click update quantities on the bottom right corner. Export it to excel!

Please make sure you do NOT hit on reconcile on the bottom left corner tab.

Good luck!

Anu