how to deduct the retention amount from arrear payment

Hi,

We have retention policy , and pay at the time year completion , now policy change and it is converted from yearly to monthly and this with effect from April-15. 

if calculate the pay system will generate the Arrear payment of the employee from the month of April  onward but i already paid the retention amount for month for two month April and May which i need to deduct the same otherwise this will double amount  .

Can any body help me define in the Sql query.

Regards,

mis

August 27th, 2015 2:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics