4 Replies Latest reply: Feb 1, 2017 5:53 AM by Sunny Talwar RSS

    Opening Balances > Date Set Analysis

    Shazad Nazir

      Hi Experts,

       

      From data mentioned below, how can i get the opening balances (Based on column DocDate) for start of every month, for OBQtyOpening.

      Perhaps I need a temporary table of dates for opening balance for which the script will get Lesser Than value comparing with column DocDate again, (just loud thinking)

      e.g. getting value of column OBQtyOpening comparing with DocDate < 11/01/16 Opening Balance of:

      1. DocDate < 11/01/16
      2. DocDate < 12/01/16
      3. DocDate < 01/01/17

       

      * OR YTD option may also help in this scenario i.e. e.g. a Date is selected 12/01/16. how can i get the value of OBQtyOpening lesser than selected date.

       

       

      YearMonthDocDateOBQtyOpening
      20161110/31/1610
      20161110/31/1615
      20161111/30/1611
      20161212/31/1650
      20161212/31/1635

       

      Help Required Please!