Problem Creating logic for a given Scenario

See more:

VB

ASP.NET

Hi.
I have a situation. An employee takes advance from his gpf account. when he takes advance installment amount is decided along with No Of Installments. now the problem that i am facing is Employee has taken advance for 4 consecutive years. There is a field in which i have to add installment amount for every month and show it in a report. For example

Year  Advance    NoOfInstallment Installment   StartMonth
2000  34000       34              1000           June
2001
2002  31000       32              969            July
2003  25000       30              833.33         October
2004  20000       20              1000           april

now year 2000 has 34 installments starting from june so installments will end on december 2002. Similarly 2002 has installments and so on

the problem that i am facing is there is a monthlyInstallment Field for each year
Now monthly installment for 2000 from june will be 1000. Also monthly Installment for year 2002 upto june will be 1000 but from july it will be 1000 + 969 = 1969 till the end of this year when installment for 2000 stops then installments will be 969 till oct 2003 after which it will be 969 +833.33. in year 2004 from april it will be 969+833.33+1000 until installment for year 2002 are over
and so on
I have taken variables to count total no of installment and noOfInstallmentPaid
problem is that when entering oct 2003 NOofinstallment gets changed to 30 from 32 where as it should remain 32 and 30 should be saved in some other variable.But i can't keep on adding variable i need some solution which will not need to add variable everytime there are two or more than two Installments in a year..

please tell me how to do this. I have spent whole morning over this but unable to find a solution. :'(