Opening Balances > Date Set Analysis

[#1]

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.

Year	Month	DocDate	OBQtyOpening
2016	11	10/31/16	10
2016	11	10/31/16	15
2016	11	11/30/16	11
2016	12	12/31/16	50
2016	12	12/31/16	35

Help Required Please!

[sunny_talwar]

I am not sure I understand what your expected output here is. Would you be able to provide some more example as to what you expect to see?

[#3]

Thanks, actually i have just decided to redesign the whole application.

[#4]

can you please guide me how can i see me previously posted questions / discussions?

[sunny_talwar]

Open this link: shazadnazir