0 Replies Latest reply on Apr 7, 2015 2:14 PM by 2747866

    On Hand QTY -Reserved +Available

    2747866

       

      Apps/OS   : R12.1.3  -  , Linux 

      We have modules : project costing, Billing, management module.

      Inventory , po module. 

      AR, AP,FA,CA,GL module.


      ----------------------------

      Is any standard report  available - containing these output...  Item Code, Name,  Reserved qty, Available qty, Total Qty  ( Reserved QTY + Available QTY)

       

      Our  requirement is below example :

      ------------------------------------

      From project module –

       

      For project Number: XPRJ001, Purchase order –PO001 - is created for supplier –SUPL001.

       

      Once we receive the item from supplier against this PO- 

       

      In inventory module – we need to receive it in inventory location- INV001 and reserve it to the same project XPR001 (reserved but not yet issued)          --------------. (Say example received today).    

       

      Need stock report, with

       

      Item code, name, available qty, reserved qty , total qty.  ( in this report reserved qty will be available)

       

      After few days (say example after three days), from inventory we will issue all the items or few items to the same project.  -- Stage 2

       

      During the stage1 – we need the report inventory stock report. In this report  we need identify

       

       

      Item code, name, available qty, reserved qty , total qty.( this report reserved qty will be zero as it is already  issued)