calculating total with in the filters.

sseshu

hai
i am new to navision
we are developing a simple pay role to our client.
they are posting salaries on 26 or 27 based on ending of that month
i have to calculate the total leaves (employee)of that month up to 26 or 27 based on their salary date.

i am using a processing report to caluculate salary with salary month starting date and ending date
now i want to write a code in that report to caluculate the leaves of perticuler employee with in the date filter above mentioned and inser it in to the employee pay roll table.
any suggessions are apriciated

Sandeep_Prajapati

It just depends on how you have architected your master and the detail tables for the payroll functionality

leave can be calculated as :
1) holidays (from calender table) +
2) Leave taken (daily attendence) + ........etc

    for  employee
    Repeat
         loop through [Calender ],
         loop through [daily attendance],
         .........
         loop through .....etc
   until employee.next = 0

I hope it helps :-k