on 12-12-2012 1:47 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try with OITW table.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.