calculating total with in the filters.

sseshu
sseshu Member Posts: 2
edited 2008-07-02 in NAV/Navision Classic Client
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

Comments

  • Sandeep_Prajapati
    Sandeep_Prajapati Member Posts: 151
    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
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV

Categories