Our client give Medical or LTC or Travel allowance to employees. In finance we have created employee as a vendor also. So when we give advance to them transaction is posted in employee vendor account with respective special GL indicator. When the recovery is made from their salary (on monthly basis) entire deduction is posted in employee vendor account. Does anyone have an idea how to break the recovered amount and assign the same as per the advance given?
For example: We have given Medical advance of 5,000 to employee XX01. This was posted in employee vendor account with Special GL indicator M. Same needs to be recovered from salary in 5 equal installments (1,000 per month). Employee XX01 has also taken Travel advance of 10,000 that was posted in employee vendor account with Special GL indicator T. Again same needs to be recovered in 5 equal installments (2,000 per month). When the recovery is made from Salary consolidated amount 3,000 (1,000 + 2,000) would get posted in employee vendor account. Now the issue is how do I assign 1,000 against Medical advance & 2,000 against Travel advance?
I can pass a JV to break the recovery of 3,000 to 1,000 & 2,000 but my original advance given and transaction of 1,000 & 2,000 would stand separately in the employee vendor account and these transactions would also not be linked to each other.
Is there a better way to do this?