0 Replies Latest reply: May 11, 2016 2:12 AM by anil y RSS

    SAP STOCK REPORT IN  QV- similar to MB5B

    anil y

      Dear members,

      In our company we are trying to make a stock report based on "MSEG" table of SAP in QV.  we had Successful down loaded  the MSEG and all the information is flowing correctly.

      issue we are facing is

      1. the data start date is 31.03.2008 and when we calculate opening stock on any given date it has to calculate from the date of initial upload(31.03.2008).

      2. when a certain period is selected then  we should be able to calculate opening balance as on that date , receipts in selection period , issues in selection period and closing balance as on the end date.

       

      I had tried few combinations but not getting correct values. Any input will be very helpful.

      attaching the QVW for  reference.