i require some logic.
my requirement is i have to fetch debit and credit values from LFC1 table
i need to fetch only vendor from last 15 months there is no transaction.
for eg: today date is 09/01/2008
15 months back means 09/11/2006
inbetween these two dates i.e., 09/11/2006 to 09/01/2008 there is no transaction , means
11/2006 0 0
01/2008 0 0
i need to get this 15 months debit and credit details , only if the values are zeros for both credit and debit.
please help how to write logic.