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. :'(