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.