x Want to participate? Join the group to interact

  • Payroll Formulas on Pre Tax Deduction

    I have been working on some garnishment formulas and have ran into a problem. We have an employee that has court ordered child support and court ordered health insurance. These combined can not be more than 50%of the employees Disposable income. BUT the…

  • PR formula to lookup employee rate

    We are trying to create a formula that will provide the hourly rate for an employee that can then be used in fringe calculation formulas. I can use a basic LOOKUP if there are only 2 Pay IDs. We have 4 different Pay IDs under two Pay Groups that we need…

  • State Withholding

    What have other companies done to setup reciprocal state withholding? This becomes an issue only when the primary state withholding is higher than the withholding in the state for the construction project. Connecticut is our primary (HQ) state. …

  • Trying to setup an Accrual formula that "resets" on the anniversary of an employees hire date

    I am trying to create a formula that will "reset" the number of hours an employee has accrued on the anniversary of their hire date. For example, if I have 56 hours of sick & my hire date is 9/5/2016, I want it to "reset" to 40 on 9/5/2017. If I only…

  • Is it possible to alter labor hours using a calculation without changing the takeoff unit to hours in Estimating Extended?

    I want to add a calculation in my assembly that will change the labor hours behind the scenes. My takeoff unit is EA and I don't want to change that. For example: If I have a qty of 10, I want my labor hours to be unaffected. If I have a qty of…

  • How do I make a new payroll formula based on a percentage of gross pay?

    I need to first compare 15% of Gross Pay to a flat amount of $114.75. If 15% of Gross Pay is greater than $114.75, then use $114.75. If 15% of Gross Pay is less than or equal to $114.75, then use 15% of Gross Pay. Here is the formula I have so far that…

  • Vacation Pays

    We have a union that wants us to pay their members two different vacation pay rates depending on what the employee is doing. Is this possible in the payroll system or would we have to do it manually? Thanks!

  • RE: Going from Sage 100 ERP to Sage 100 CRE

    Hi... in CRE open 5-3-1 payroll calculations, click the picklist arrow or (F5) to select the payroll calculation and update the Default Rate, Max for each

  • 401K formulas/setup when plan allows different withhold amount on Bonuses?

    does anyone have 401k formulas setup to incorporate different amounts withheld on Bonuses. Our plan allows participates to withhold a different amount on Bonuses both 401k and Roth. We have formulas setup to calculate 401K and Roth and to compare to one…

  • SAGE 100 - Payroll EFT report different than Payroll report?

    This is our first payroll processed with Sage 100 (we were with Sage 50 before). The whole process is fine, the payroll report is fine. When we print the EFT report, the amounts are different for 2 employees (10% of the amount that should be paid) and…

  • Correction to accrued vacation hours

    Please advise how to correct an error in the total vacation hours accrued.

  • FUTA Credit Reduction calculation for payroll

    How would I set up a new payroll calculation for the FUTA Credit Reduction. In California, we have to pay an additional .012 to FUTA for the credit reduction. Is it possible to create a new calculation, so the value lands in the "FUTA" column of the…

  • Negative In & Out Year-end Adjustments Messing Up Workman's Comp Basis

    At the end of each year we usually end up with some vehicle in and out adjustments that are negative for the purposes of taxable wages. This year it appears these negative in and out adjustments are affecting the calculation of workman's compensation…

*Community Hub is the new name for Sage City