x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Answers 2 answers
  • Subscribers 242 subscribers
  • Views 1529 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Michael Mason

Not Calculating Fringes Correctly

SOLVED
Posted By

We are running Sage 18.4.1.  We just went live a couple weeks ago and noticed something was off with our fringe calculations.  In the Union set up the pays and fringes are set to total hours as the calc method.  The fringes should be only calculated based on the regular and overtime wages for the Union or prevailing wage hours worked.  Other things like drive pay should not apply when calculating the fringes.

Looking at the other calc methods available I don't see one that fits our needs.  I can set it to formula but I am not sure how to make that work.  If I had a formula that calculated the fringes only when the Pay ID is either "11" or "22" I think we would be in good shape.

Thanks in advance for your help.

Parents
  • 0
    SUGGESTED

    Is your drive pay a hourly pay or a mileage reimbursement?  If you are paying a union member by the hour I believe you have to pay union fringes even if they are driving. If it is a flat fee or mileage reimbursement I would make sure the Pay ID for those are set up as "other pay" and not "regular pay" or "overtime pay".

    You can also look at the formula that is set up for "Total Hours" under Payroll-Tools-Formula it should tell you what Pay ID it is calculating.

    Hope this helps.

  • 0 in reply to Jaffa Accounting

    Hi and thank you for the response.  The Total Hours calculation will not work for us unfortunately.  This union has an hourly rate for driving a company vehicle from the yard to the job site of $20.00 per hour and it specifically states the drive time is not subject to Fringes.  I don't see any calc method on the fringe set up for that.  I am not familiar with creating formulas for something like this but it would look something like this:

    If PayID is 11 or 22 then hours * fringe Rate

    Thanks,

  • 0 in reply to Michael Mason
    SUGGESTED

    Hi Michael,

    If the Drive Time pay is set up with a Pay Type of "Regular" then it will be included in all calculations that are based on any normal regular pay, and your fringes would require a formula. If is is set up with a pay type of "Other" then the Totals Hours calculation method would exclude it.

    Your example formula is pretty close:

    IF(Pay ID [PR Time] = "11" OR Pay ID [PR Time] = "22", Units [PR Time] *<rate>)

    See article 21786 How do I create a formula in Sage 300 CRE? for more info on creating formulas.

Reply Children
No Data

*Community Hub is the new name for Sage City