Resource of Field names for tax formulas available?

[vader716]

I am trying to write a formula for a union due that is based on 5% of regular (non overtime hours) gross pay. I am having trouble because none of the documentation shows you the syntax for field name usuage in a tax formula (ie hourly pay rate for pay type 1 in the employee table). Is anyone aware of a resource availble to assist in the creation of these formulas?

Thanks

Jim C

[bluegal]

As I replied to a similar post, I set up a payroll tax called DUES2 for the Tax ID; Union Dues 02 for the Tax Name; Local; All statuses.
A=-(Reg_1*EMP_SPECIAL1_NUMBER)*5%;
ANSWER=A

(You would have to modify the Reg_1 to whatever your have named your field for regular pay.)

Enter each employee's hourly pay rate in maintain employees EMP_SPECIAL1_NUMBER.

In the default information set up the general ledger account number for Union Dues Withheld.

[vader716]

If I may further explain the problem and maybe you can help. The company pays two differant regular hourly rates depending on the job (regpay1 and regpay 2).

I have used Special #1 for the second union due which was based on .305 cents per hour and that one is working fine.

If I had 3 special fields I think I could possibly implement your formula.

If you have any other Ideas I would gladly like to hear them because I'm stumped. An example of this problem is

John was paid $10.00/hr for 30 hours worked and $15.00/hr for 10 hours. Therefore he needs to pay 5% of $450.00. This is further complicated by the exlusion of any overtime pay (but heck I'll deal with that if I get past this).

Any ideas would be greatly appreciated. Thanks

Jim