Skip to Content
avatar image
Former Member

Opening Stock

Hi, I created a Stock report based on date. I want to have opening balance based on either year/month selected. Logic would be, if user has selected the Jan 2015, then opening balance should be sum of all transaction till DEC 2014 . I am not sure how to model in HANA. However it doesnt work as expected. Appreciate if anyone had handled this earlier, would provide insight. Note: We are not BW customers Regards Ben

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 18, 2016 at 11:53 AM

    Hi Ben Li,

    I have two questions.

    1. How the user will give Inputs? 201501 or Jan 2015?

    2. User gives Jan-2015, sum of all transactions has to be calculated till DEC 2014. It is fine.

    If User gives Feb-2015, How the Opening balance has to be calculated. Till Dec-2014 or Jan-2015??

    This high level idea to design the model.

    1. Create Input Parameter for year/month prompt.

    2. Apply Filter on year/month with Input Parameter.

    Make the condition as year/month < $Input_Parameter$.

    3. So If you select the Year/Month value, It would sum of all transactions till the previous month.

    Regards,

    Muthuram

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 29, 2016 at 06:07 PM

    Hi Ben li,

    Did you implemented this ? Can you please help me on this , I have similar requirement.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded