cjmcfg
Aug 6th, 2007, 08:53 AM
I will try and explain this to the best of my ability but it is confusing so ask questions if you don't understand...
My company designed a program to use for our payroll...Our payroll system is like this: Everyone is paid on commission. Commission is paid only on the 25th of each month. They are also paid on the 10th which is called a Draw. What happens is on the 10th 'Employee A' gets a $750 Draw (the Draws are variable for each person) then on the 25th they have $3,000 of commission (variable on performance). They have to payback the $750 draw to the company (it's kind of like a stipend). Now the tricky part is that is someone's Commission dollars cannot pay back the entire $750 and have $750 Remaining for the pay period on the 25th they get another draw to get them to 750 and i need to keep a running total of the amount of outstanding draws (amt owed to the company), see the next two scenarios:
Scenario 1:
1/10/2007 : $750 Draw
1/25/2007 : $0 Commission
1/25/2007 : $750 Draw (Total Draw Outstanding $1,500)
2/10/2007 : $2,250 ($750 Draw +$1,500 from before)
2/25/2007 : $2,000 Commission
2/25/2007 : $750 Draw
3/10/2007 : $1,000 ($750 Draw + 250 from before)
3/25/2007 : $10,000 Commission
3/25/2007 : $0 Draw (Balance reduced to 0)
4/10/2007 : $750 Draw (cycle continues like that)
and/or
Scenario 2:
1/10/2007 : $750 Draw
1/25/2007 : $900 Commission
1/25/2007 : $150 Draw (Total Draw Outstanding $150)
Everything listed above is on one line (Record set) in crystal I need the Outstanding amount to return to the Next line below (the next record). I need this total to run forever and terminate and rest for each person. The field for the Second Draw is not available for summarization in crystal.
I don't know how to do this. If you can help it will be greatly appreciated. I am using Crystal XI.
Thanks,
Chris
My company designed a program to use for our payroll...Our payroll system is like this: Everyone is paid on commission. Commission is paid only on the 25th of each month. They are also paid on the 10th which is called a Draw. What happens is on the 10th 'Employee A' gets a $750 Draw (the Draws are variable for each person) then on the 25th they have $3,000 of commission (variable on performance). They have to payback the $750 draw to the company (it's kind of like a stipend). Now the tricky part is that is someone's Commission dollars cannot pay back the entire $750 and have $750 Remaining for the pay period on the 25th they get another draw to get them to 750 and i need to keep a running total of the amount of outstanding draws (amt owed to the company), see the next two scenarios:
Scenario 1:
1/10/2007 : $750 Draw
1/25/2007 : $0 Commission
1/25/2007 : $750 Draw (Total Draw Outstanding $1,500)
2/10/2007 : $2,250 ($750 Draw +$1,500 from before)
2/25/2007 : $2,000 Commission
2/25/2007 : $750 Draw
3/10/2007 : $1,000 ($750 Draw + 250 from before)
3/25/2007 : $10,000 Commission
3/25/2007 : $0 Draw (Balance reduced to 0)
4/10/2007 : $750 Draw (cycle continues like that)
and/or
Scenario 2:
1/10/2007 : $750 Draw
1/25/2007 : $900 Commission
1/25/2007 : $150 Draw (Total Draw Outstanding $150)
Everything listed above is on one line (Record set) in crystal I need the Outstanding amount to return to the Next line below (the next record). I need this total to run forever and terminate and rest for each person. The field for the Second Draw is not available for summarization in crystal.
I don't know how to do this. If you can help it will be greatly appreciated. I am using Crystal XI.
Thanks,
Chris