Inventory

Get Involved. Join the Conversation.

Topic

    Jesus Escobar
    Stock on hand based on a past date or time interval
    Topic posted August 13, 2019 by Jesus EscobarBronze Medal: 1,250+ Points, last edited August 13, 2019, tagged Business Intelligence, Business Intelligence - BI, How-To, Inventory & Cost Management Analytics Cloud, Inventory Cloud 
    15 Views, 2 Comments
    Title:
    Stock on hand based on a past date or time interval
    Summary:
    See on hand stock based on a past date or time interval filter
    Content:

    Hi.

    There is any report or way to get in the stock on hand based on a past date or time interval for example..

    It is required to see the stock and its value at the end of a period (for example, at the end of the year, at the end of the previous period, etc)
     
    It can be per month or week etc. any necessary period.
     
    DATE FILTER    D1 1/8/2019        D2 31/8/2019 
     
    ITEM ON HAND D1 ON HAND D2 DIFFERENCE UOM
    ITEM_1 10 8 -2 UN
    ITEM_2 50 71 21 UN

    That way we will have the stock that was in that moment of time.  D1  or D2

     
    Version:
    Oracle Cloud Application 19C (11.13.19.07.0)

    Comment

     

    • Gerald Goodbody

      Costing has inventory value reports and OTBI on the as of an accounting date dimension, you can take a look at those and see if they meet the requirement.

    • Pradeep Kumar

      Hi,

      You can also view the stock and valuation from UI using below navigation

      Supply Chain Execution > Cost Accounting > Review Inventory valuation

      Or

      whether you are trying to create a custom ?

      Regards

      Pradeep