Click here to Skip to main content
13,045,540 members (72,063 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Dear Sir,

I made an application on named payroll for my own company, were
i create Advance form for employees who want to take advance.....below is the despcription :-

1. Emp No........
2. Emp Name .......
3. Advance Date/Month .........
4. Deduction from Month .........
5. Installment Amount ..........

I want to issue advance to employee and this advance will be deducted from his salary by the MONTH he want to refund his advance for example :-

If the employee X has taken advance in the month of January 2012 and he wants to return his advance in installments by the month of MARCH (NOT FROM THE MONTH OF JANUARY OR FEBRUARY) 2012. What I wanted to do that when the salary of the Mr. X is being generated for the month of MARCH 2012 the software should start deducting installment amount from his salary from the month of MARCH 2012 till his advance becomes 0.

Please help me on the above problem, i need codes to implement on my application.
I am waiting for positive reply.

Posted 11-Jan-13 21:48pm
Updated 14-Jan-13 1:13am
OriginalGriff 12-Jan-13 3:53am
What have you tried?
Where are you stuck?
onurag19 12-Jan-13 4:33am
you will have to make the logic for this or please show what have you tried so that i can help
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

In the database, Add one extra column which signals if any advance is due to be paid or not.

At the time of issuing the payment, UPDATE SIGNAL - 1.

Each time when you prepare salary report, Check whether SIGNAL=1, If yes then fetch the remaining salary and show.
hspl 15-Jan-13 6:10am
Dear Sir,

I could not understand the said solution2.Can you please provide me sample application if possible......

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 14 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100