Sage 100

 View Only
Expand all | Collapse all

Does anyone have experience getting the ABRA link

  • 1.  Does anyone have experience getting the ABRA link

    Posted 04-03-2015 08:45
    Does anyone have experience getting the ABRA link to work with Sage 100 v2014 and ABRA 9.2? We are getting corruption in the PR3 file. The ABRA side of Sage claims this is a Sage 100 issue, and Sage 100 says it's an ABRA issue. We have followed all of the knowledgebase recommendations to no avail. Please help!


  • 2.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 08:58
    I was looking for something else on the web and just saw this. Is this your issue? There is a Hot Fix. This hot fix is for customers using the Sage 100 ERP link in Sage HRMS 2014 (10.4)or Abra Suite 9.2; even if you do not have one of the described symptoms below you must install this hot fix if you use the Sage 100 ERP link in HRMS 2014 (10.4) or Abra Suite 9.2 integrated with the following Sage 100 ERP versions: 2013 PU 7 and higher 2014 PU 3 and higher 2015 and higher This issue is resolved in HRMS 2015 (10.5). Error 26 PRWMAB 7110, occurs when clicking the Wages tab in Employee Maintenance and ABRA/HRMS data is integrated and transferred to Sage 100 ERP 2014. Error 26 PRWMAD 13020, occurs in Employee Maintenance > Tax Summary and clicking Federal or State button and ABRA/HRMS data is integrated and transferred to Sage 100 ERP 2014. ""Error 26 PRWMAB 1825"" then get ""Error 46 PRWMAB 7110"" when clicking on wages tab in Employee Maintenance Employees erroneously show tip wages in Tax Summary when they don't earn tips.


  • 3.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 09:07
    This is exactly the reason I gave up pushing clients to use the Link back in 2007 or so. Here is the list of issues back then. Can anyone verify if any of them have been resolved. At the time, Abra and Sage were deaf and dumb to the client's dilemma. Since then I only used the link to transfer data from Sage PR for the initial data load of Abra. @ShawnSlavin ???? Abra Issues with MAS PR. 1.The necessity of an additional field in Abra Suite in order for the user to select which state's unemployment tax will be used for the employee, as some employees need a different state's UI tax applied from their primary state. This particular request has previously been documented and is currently under review by the Product Management and Design teams. (4047) The current lack of this functionality can cause problems for customers as if the UI tax applied to the employee is not the primary state then an additional transfer of the employee from Abra to MAS 90 can cause the removal of the previously applied amounts to the UI tax. This issue can be avoided by the placement of a patch file into the Abra System (6335). The patch file does not add a SUI filed into Abra but does stop the removal of any UI that is not a match. 2. Benefits add in Abra will transfer to MAS 90 regardless of the start date for employee benefit. This issue is also documented and under review for possible enhancement(6394), but currently the Link will continue to transfer the benefit to MAS 90 deductions as long as the benefit is applied to the employee's Abra details. (There is no patch file for this issue currently) 3. Accruals do not start automatically in MAS PR Solution from Abra - To get the accruals to start operating when using the MAS 90 Interface, after all mapping has been completed, a maintenance routine must be run in MAS 90. To find this utility, launch MAS 90 and select Modules, Payroll, Setup, Benefit Schedule Maintenance, put in Benefit Code, click Apply button, put in new hire employee number that was just transferred from Abra HR into MAS 90 Payroll. This has been submitted to Engineering. Notification will be included in the Release Bulletin accompanying the version with the change. We apologize for the delay in responding to your issue but it was received after hours and we are closed on the weekends. 4. No mapping cross link for UDF's in both systems. 5. Issues with employees having more than two state tax codes for withholding Abra Limit was two states. 6. Tracking changes to MAS PR change audit log is not updated if change comes through Abra. 7. Terminated employees THIS year in Abra. When she tries to run the link to MAS 90, if she selects terminated employees, ALL terminated employees are sent over (meaning last year employee's that were purged from MAS 90 during the YE closing process). Suggested Solutions A) Regarding the date fields, hold the dates last entered as a default date. That way user could enter the current period (year) and it would serve as a reminder. B) If you click on the include terminated employee field, FORCE the user to enter a date range. C) If you click on the include terminated employee field, open a warning box advising user to enter a date range. in either 2 or 3, user could not go forward without entering a date range. D) For terminations, only allow the changes made in the same year as the MAS 90 Payroll Setup ""Current Processing Year"" field are transferred. See the box below.


  • 4.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 09:13
    @JeffSchwenk - this looks way too much like the CRM integration wish list...too bad the products aren't all from the same publisher


  • 5.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 09:43
    My HRMS team leader is on vacation today. I will follow up on Monday. She is the only one of our team who has worked with the Sage 100 to Abra integration tool.


  • 6.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 09:50
    I had a really bad experience with HRMS 2012 to 4.50. The link messed with employee deductions and direct deposit information. And I had the same problem with the different divisions of Sage pointing fingers at each other. My customer quit using the link because of the problems. @Diana, was the Hot Fix for Abra or Sage 100?


  • 7.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 09:55
    It was listed on the Sage 100 website. Defect ID 103638 ABRA Defect #16490 There is a Sage and an ABRA Hotfix


  • 8.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 09:59
    Sigh, not much has changed then. Instead of learning some lessons with integration issues, they just threw another product at the wall and twinkled their nose and wished the integration to work because they are both named ""Sage"". Talk about being thrown under the bus TWICE! I hate being thrown under the bus!!!!!


  • 9.  RE: Does anyone have experience getting the ABRA link

    Posted 04-03-2015 11:05
    Thanks for everyone's input. Still working on this problem. I have the ""Hot Fix"" mentioned by Diana and have run through the steps multiple times without success. Part of it is confusing to me. Part of it is: --- Browse and open the ..\MAS90\MAS_xxx\PRxxx\PR3xx.soa file (xxx=company code) Locate the applicable record that has a shortened key in field 1 and click Edit Enter the following: Field=1 Starting Position=1 Length=99 Click Ok If you get the prompt, Expand field Langth? click Yes Note: Steps 4-7 will need to be done for each record that has a shorthened key in field 1 --- My client has over 800 employees, so there are over 1600 records in PR3xxx. I have looked at every single one of them, and none have a ""shortened key"". @Shawn - I would love to talk to your HRMS team leader next week!


  • 10.  RE: Does anyone have experience getting the ABRA link

    Posted 04-06-2015 15:51
    Status?


  • 11.  RE: Does anyone have experience getting the ABRA link

    Posted 04-06-2015 16:30
    @Jane - From my client last Friday: Hi Jon, the Sage support team for Sage 100 called me today and worked on our transfer problem with the PR3 file and they could not get the program to work either. They tried installing the 2015 tax tables. She ended up taking a copy of our file and she is going to see if it does the same thing on her system. She will let me know on Monday what she figures out. It's Monday. Not solved yet.


  • 12.  RE: Does anyone have experience getting the ABRA link

    Posted 04-07-2015 08:47
    Here is the latest from Sage. (FYI - I am not the ABRA person): I believe the error you are receiving when running the Employee Totals Verification report is caused by a bad installation of Abra Suite 9.2. The version of Abra Suite should be 9.2040 as well as the Abra Sage 100 ERP Link version. When I was dialed into your machine the other day I noticed your Abra Suite version was 9.2057 and Sage 100 ERP link was 9.0709 (which is the link version that came with Abra Suite 9.1 version). Contact me for further details. I will post the final solution when it is fixed.