18 Replies Latest reply: Jun 26, 2017 2:07 AM by tarun bisen RSS

    Calculation for the next day opening stock

    tarun bisen

      Dear all,

       

      I am stuck in finding the next day opening stock. Can any one help me to do the following calculation working.

      their are three table or file which I have loaded  in the QV

      Loaded tables in qv.PNG

      Calculation should

      Opening stock + Production - Sales = Closing Stock

       

      Closing Stock will be the opening stock for the next day. same formula for the next day this will go on day wise month or year.

       

      Day end Closing Stock will be next Day opening Stock

      Month end Closing Stock will be next month 1st day Opening Stock

      Year end Closing Stock Will be next year 1st month 1st day Opening Stock

       

       

      Result should look like this

      Result want.PNG