logic

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

debit credit

11/2006 0 0

to

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.

please urgent.