3 Replies Latest reply: Dec 30, 2012 3:07 PM by ahmad RSS

    quantities sold

    ahmad
      Dears,

      I need to extract quantities sold from 1/1/2012 up to December 19, 2012 for a specific org. and view (Item Code, Qty sold, Net Amount)

      Any Help ?

      Edited by: ahmad on Dec 23, 2012 1:06 AM
        • 1. Re: quantities sold
          981417
          Dear Ahmad,

          Hope this query helps

          select
          (select segment1 from mtl_system_items_b where inventory_item_id = w.INVENTORY_ITEM_ID and organization_id = :id) Item,
          (select organization_code from mtl_parameters where organization_id = w.ORGANIZATION_ID) org_code,
          w.shipped_quantity
          from wsh_deliverables_v w where w.RELEASED_STATUS_NAME = 'Shipped'
          AND W.CREATION_DATE BETWEEN :PFROM AND :PTO


          Regards,
          Sri
          • 2. Re: quantities sold
            Sanjay Desai
            Hi ahmed,

            You can get the sales for specific org. and period using Material Transaction form in inventory.

            Navigation path is :

            Responsibility = Inventory > Transactions > Material Transactions > Select specific inventory organization > Input Transaction date = 01/01/2012 & 19/12/2009 > Input Transaction Type = Sales order issue > Select FIND button > you will get the required information.

            After getting this information, you can directly export it in excel sheet.

            HTH
            Sanjay

            Edited by: Sanjay Desai on Dec 26, 2012 8:44 AM
            • 3. Re: quantities sold
              ahmad
              Thanks for all..