Skip to Content

Warehouse wise back date stock

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 13, 2012 at 02:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2012 at 02:14 PM

    Hi,

    Try with OITW table.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.