Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SAP STOCK REPORT IN QV- similar to MB5B

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.

0 Replies