Payroll Report Customization doesn't work

We have modified our Payroll "Deduction by Credit Account" report to show a "Basis" in order to calculate 401k match.  There are two problems with this:

#1 - The basis must look at the first processing of a check and not the final check. (example I entered a check with a gross of 15,000 and not $1.500.  I reprocessed this before printing the check but the report still sees $15,000 as the basis)

#2- If there is no basis (ie, the deduction is a flat amount) then that employee's deduction does not show up on this report at all.

I am not good at writing formulas but can usually figure out Report Designer. 

ANY help is appreciated!!!

Parents Reply
  • 0 in reply to LAPayroll

    By creating a FRINGE ID for the 401k match, you can set up that fringe ID on each employees record [PR > Setup > Employees, then click the FRINGE button] and then through the use of Calc Methods, the "Amount" field and custom formulas, each employee's match could easily be calculated automatically and will be accrued on the employee record in the MTD, QTD and YTD fields.

Children
No Data