Hi friends,
I need ur help. I have 10 yrs employees data. I have upload only basic salary through bdc in database table.
For example:
(yr/month) (12% Basic Salary)
Apr 2007 1500 -
>Uploaded data
may 2007 2200------>Uploaded data
june 2007 2356------>uploaded data
"
"
jan 2008 3120------>uploaded field by bdc in every month
feb 2008 7894------->uploaded field by bdc in every month
Every month i'll upload basic salary and every yr data will change but data will store in same table, for that i made primary key year.I m showing it in smartforms.
When 2008 financial yr started year will be change, it would be
Apr 2008 5442------>Uploaded data
may2008 2352------->Uploaded data
"
"
mar 2009 5555------>Uploaded data
My requirement is only current yr data will be extact from database table not previous yr data.
Plz help me.
Regards,
Swapnika