x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 239 subscribers
  • Views 2274 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
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
Melissa F

Need MN SWH Tax Formula to not round but calculate to the cents

SUGGESTED
Posted By

We have started using a third party(paychex to print our paycheck) their system does not round the MN SWH taxes BUT timberline does, it's formula "PR MNSWH_CR" rounds up to the nearest dollar. MN allows an employee to pay to the penny or to round. I want it to not round by to pay to the cent. Does anyone that uses Sage CRE and does work in MN have a different formula in their system that they can share with me?

Thank you kindly

  • 0

    We aren't in Minnesota but inside the PRMNSWH_CR formula, there is a rounding function.  If you were to copy the formula and change it so that the zero after the comma becomes a two, the formula will not round to dollars but will round to two decimal places (cents).  You would have to replace the formula inside your Tax Rate table for MNSWH with the new formula you made.  Then anytime you have to download taxes, you may want to check to be sure the formula name you made still appears in the Tax Rate table.

  • 0 in reply to Rhonda V
    SUGGESTED

    Thanks for your post !

    After looking at the MNSWH tax tables, the State of Minnesota specify that the amounts are rounded to the nearest dollar. We would not recommend making any changes and recommend that you should probably talk to the vendor you are using to address that on their end.

    You may edit the formula to your discretion however Customer Support does not recommend doing so.

    Thanks!

  • 0 in reply to Rhonda V

    Thank you very much, I did what you said and I tested in on a check and it did work, I appreciate the advice.

*Community Hub is the new name for Sage City