Sage 100

 View Only
Expand all | Collapse all

v2017 PR - Deductions expensed by home department.

Jeff Schwenk

Jeff Schwenk08-01-2018 15:32

Doug Higgs

Doug Higgs08-16-2018 09:40

Wayne Schulz

Wayne Schulz08-16-2018 10:02

Therese Logeais

Therese Logeais08-16-2018 10:08

Jeff Schwenk

Jeff Schwenk08-16-2018 11:58

Moira Goggin

Moira Goggin08-16-2018 12:50

Moira Goggin

Moira Goggin08-17-2018 10:03

Kelly Sappington

Kelly Sappington10-16-2018 04:54

  • 1.  v2017 PR - Deductions expensed by home department.

    Posted 08-01-2018 14:45
    v2017 PR - Deductions expensed by home department. Does this actually work?? From my observations, Sage has the debits and credits backwards. Specifically, employer matching of 401K deductions. Or is it me? Thoughts? TIA


  • 2.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-01-2018 14:50
    Debit, credit... what difference does a title make.


  • 3.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-01-2018 15:32
    Just another day...


  • 4.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-02-2018 07:12
    Does anyone actually use this ""feature""? It has been around for a long while. I looked at it when I first appeared thinking that my prayers had been answered but it seemed to be a nightmare long forgotten. Now like a bad penny it is back. Client has an employer matching deduction code and about 50 departments. Each month they calculate the employer portion of the 401K plan debiting one account for the expense and one account for the liability. Then each period end, they do a JE reclass crediting the original expense account and allocating to the correct expense account in each department (this was the only method prior to the departmental deduction override feature). Now years later, they want to eliminate this non value added process as their workload is increasing and the Dr's won't hire any accountants. So I tell them about the ability to charge deductions by department and set up a test. See below for setup. The end result is the accrual account (gl credit) is overridden by the department deduction and you now have two expense accounts in play instead of a departmental expense account and the accrual account. To get the results I want, you have to flip the accounts in deduction maintenance AND do a NEGATIVE DEDUCTION in employee maintenance. Wow. Not happening with this client. What am I doing wrong or has this been wrong since the get go and no one is using it for employer matching expenses. It works as desired if you only have one GL account in the deduction maintenance. Think about it, WHO wants 50 different liability accounts for a 401K employer matching deduction?


  • 5.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-02-2018 14:12
    Well, for those closely following this thread, what didn't work prior to v2018, **wasn't** fixed in v2018. I just can't believe anyone is using this feature. So close to something positive yet so far. Speak up if I am using it incorrectly PLEASE!


  • 6.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-02-2018 15:28
    From their PR handbook - and it still may not work: You can enter deduction codes for each department. If a deduction code accrual account is defined for the employee's home department, that accrual account is used during the Daily Transaction Register update process instead of the accrual account defined in Deduction Code Maintenance. If a deduction code accrual account is not defined for the department in Department Maintenance, the accrual account defined in Deduction Code Maintenance is used during the Daily Transaction Register update process.


  • 7.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-02-2018 18:41
    The problem is that for **employer contributions deduction type**, the departmental GL account should override the expense GL account, NOT the accrual liability account. Just plain and simply wrong all of these years. Sent it off to Diane Coffman for review.


  • 8.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-15-2018 14:10
    Feedback from Sage **I certainly see what you are saying. I went back through our historical records in R&D (as best as I could) and consulted some of our longtime Payroll experts and unfortunately it doesn't appear that anyone else has reported this as an issue. At this point, there are only two paths to get this changed. First, call support and attempt to convince them that from an accounting perspective this is incorrect. It's going to be viewed as an enhancement request, most likely, but it gets something in the system. Second, add an entry on the Ideas Site to see if others will back you on this.** This is what happens when Sage does not make it conducive to report problems (and fix them). No one reports them!!!! This issue has been out there since the department deduction override enhancement was made. But I did not report it. Now a client has grown tired of doing the monthly JE reclass. This should have taken care of it. But no...... So please click on the link and vote on it. As they say in Chicago, early and often. And maybe I will even waste a support case on it as well. TIA https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39150


  • 9.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 09:33
    Is this fixed in 2018? If so my sense is that you'll have an uphill battle getting a fix into < 2018 version


  • 10.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 09:40
    Voted 3 times. I am from Chicago. :-)


  • 11.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 09:56
    @WayneSchulz - No, still an issue in v2018, thus I restarted my campaign for truth, justice and the American way. It should be such an easy fix! Just override the other GL field. But since I didn't go the extra mile back in the day to report the issue, it now takes an act of Congress to get any action. So vote for change above. It would be nice if they would at least fix v2017 PR, but I don't think I can hold my breath that long. **MSGA!!!!!**


  • 12.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 10:02
      |   view attached
    Let's get 250 of these for MOTM


  • 13.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 10:08
    Too funny @WayneSchulz and @JeffSchwenk !!


  • 14.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 10:15
    **ONLY** if you vote!!! And **PLEASE** leave a comment when voting explaining how much time your client/company spends each month reclassing the departmental expenses. Put some oomph in it! Send an email to your PR clients asking them to do the same. Together, we will MSGA!!!!! https://www.youtube.com/watch?v=ZwMVMbmQBug Do you hear us Atlanta??


  • 15.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 10:17
    Unfortunately, @ThereseLogeais this is not a laughing matter. We must unite and make our voices heard! https://www.youtube.com/watch?v=47E2tfK5QAg


  • 16.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 11:17
    The only way to make Sage 100 great again is to buy the product from Sage and rename it **MAS 90 Minds ERP**.


  • 17.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 11:58
    Time to start the Go Fund Me page then.


  • 18.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 12:50
    Like that idea @JeffSchwenk


  • 19.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-16-2018 17:19
    BTW, I am up to 12 votes now. Need to keep the momentum going. https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/39150


  • 20.  RE: v2017 PR - Deductions expensed by home department.

    Posted 08-17-2018 10:03
    Up to 14 now, let's keep it going.


  • 21.  RE: v2017 PR - Deductions expensed by home department.

    Posted 10-12-2018 13:47
    Time to bring this one back to the top. Vote count is up to 25. We have over 200 folks in the group. We need more support for Sage to get off their WAD butt and fix this. Please if you haven't voted, I beseech everyone to click on the idea link above and vote! Together, the MINDS can do it! The open case with tech support is 8007113582.


  • 22.  RE: v2017 PR - Deductions expensed by home department.

    Posted 10-16-2018 04:54
    now at 29 votes