BIG problem that i dont know how to fix

[cjmcfg]

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

[mabbas110]

I dont know that either i have correctly understood ur problem or not but still i will ans u what i have understand.

First of all make a formula field , and in that u check that if its commision then amount*1 and if its drawn then amount*-1.

so u will get plus value commision and minus value for draw , u dont need to show this formula to report , just keep it hidden , now add a running total field and sum this formula field there.

diplay it where needed , i think u can get the required solution.

[mabbas110]

Please rate it if it had helped you out.