My Customer want to show the Available Stock till the date selected.
with this Condition :
STATUS = "I" and RECDATE <= Selected_Date and INVDATE > Selected_Date
For example :
if i select ( march/2014),
i need to see : the stock available stock from 1900 til 31/03/2014.
and if a car received on 20/03/2014 and invoiced on 02/04/2014 -----> i have to show it.
but if a car received on 20/03/2014 and invoiced on 28/03/2014 -----> i dont want to show it.