Sage 100

 View Only
Expand all | Collapse all

Payroll - iSolved rejecting file invalid account number

  • 1.  Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 17:17
    Hi there! I have a client using iSolved just for direct deposit services. Today they are trying to synchronize their direct deposit file and it keeps failing. All isolved will tell us is "Element company dd account number has invalid value". This was totally true the first time we tried to sync the file. The PII had kicked in (even though we had full rights) and changed the account number to ***XXX. So we corrected that and the file still failed. Sage told me to reverse and reissue the payroll which I did. And we are still getting the same error. The client is in a panic because the deadline has now passed and people do not need to have a late payroll right now! Has anyone see this error before?

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------


  • 2.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 19:52
    I wish I could help!  iSolved is used by one of my customers for TimeForce, and their support line was pretty responsive.  I saw that the iSolved Salt Lake City support office is still open I'd escalate it - it would be terrible if employees had a delayed check, especially right now!
    Support Hours
    Phone: (800) 733-8839
    M-F 6 a.m. to 6 p.m. MDT
    Sat-Sun closed

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 3.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 19:57
    Kate - 

    If you have time, could you please connect your case on this to case 8008005306?  I'm now on my third customer who has had the account number wiped out of the Bank Code file - two have payroll, one does not.  Seems to be related to the Bank Rec Register update/purge.  Sage has not been able to replicate, and it seems to be getting worse...


    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 4.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 20:00
    @Beth Bowers I certainly will! In your experience, if you just put the bank account number back in Bank Code Maintenance is it okay? Or are you having to do anything more invasive? ​

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------



  • 5.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 20:09
    That's all we've had to do, BUT it has happened repeatedly for my first client who reported it, so you have to keep an eye on it.  We THINK it is during Bank Rec Register/Purge (my second client confirmed she had run it since her last payroll).  Sage has a mod to that program that writes the value of the Bank Account to a log file at various times during the processing and I've installed it in one place, but they had already finished all of their Feb Bank Rec by the time we got it, so we haven't helped Sage at all yet.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 6.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 20:10
    One more note, @Kate Krueger - sometimes the account gets wiped out, and sometimes it gets replaced with ***XXXX.  If you look in the file, it actually has the *** in there, not just masked for display.​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 7.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 20:12
    This morning it was masked even though all users have all rights. We changed it to the actual account number. Because Bank Account No is now an encrypted value we can't see it in DFDM (grrr) but I created a Crystal with GL_Bankpii.work and it is showing the full account number. But the ***XXX is definitely what started all this. What makes it just worse is that these are healthcare workers that are going to be paid late!

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------



  • 8.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 21:06
    I had a user call yesterday with a rejected positive pay file.  I discovered asterisks in the account number in bank code maintenance.  I changed it back to the actual account number.  I wonder if there is a proxy update that fixed this.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 9.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 03-27-2020 21:17
    In a last-ditch effort I logged in MAS90 mode and the file processed. I reported that to Sage and they have zero idea why that would have worked. Unfortunately past the deadline to process for the correct pay date.

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------



  • 10.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-01-2020 16:51
    Edited by Jeff Schwenk 04-01-2020 19:41
      |   view attached
    Customer called regarding their rejected positive pay upload.  I will open a case with Sage and reference Beth's open ticket,.

    Case #8008123824 - According to Jeri in support, Beth's case (8008005306) has been closed out as she is working directly with engineering with it.  It took some cajoling to get her to reference my case to it.

    Beth, has it been fixed yet????

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 11.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-01-2020 17:00
    Thanks, @Jeff Schwenk - that's the 5th client confirmed so far.​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 12.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 08:46
    What version(s) of Sage is this happening to? It appears like it’s global - not only isolved ?

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 13.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 08:54
    For my case, it is v2019 ADV PU 2

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 14.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 09:13
    This issue is that the bank account in Bank Code Maintenance is being replaced with actual *, like it would appear if it were hidden, or completely spaced out.  I believe all of them are on 2019, various service updates, some Adv, some Std.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 15.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 09:18
    Isn't this related to the security setting for 'allow viewing, printing, editing of highly sensitive personally identifiable information'?

    ------------------------------
    Dawn Kulbacki
    Capitol Computer Systems, Inc.
    ------------------------------



  • 16.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 09:19
    No.  People with full rights are also seeing it - and note that sometimes the field is completely BLANKED OUT.  Empty.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 17.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 09:22
    I have also seen users with full admin rights create the file and the bank account number in bank code maintenance is asterisks except the last two characters.  v2019 standard.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 18.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 09:27
    Sage has a modified version of the Bank Recon Register update program that is writing the value of the bank account field to a log file in an effort to track down where this is happening.  All of my clients had recently done a bank rec update/purge, so we are assuming that is where it is happening.  It would be helpful for anyone else that has clients reporting this to see if they can also tie it to Bank Rec purging.  I'm sure you could also get the modified program from Sage (version 2019 only) if it's happening often enough to be useful.  Mitch Jagosz has been my contact.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 19.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 09:34
    Does this appear out of the blue or after applying a product update?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 20.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 09:41
    Out of the blue.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 21.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-02-2020 14:07
    It was 2019 PU2 PR 2.2 for my client as well. I don't believe they had done a bank rec between the payrolls that worked and the last one that was rejected. They did apply a payroll update though.

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------



  • 22.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-20-2020 16:51
    One of my customers on 2019 Std w/PR 2.20.1 has had this happen randomly and many times; the bank account number field either get asterisks in the first 8 or so places in the field or it gets blanked out completely.

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90Minds Board Member at Large
    ------------------------------



  • 23.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-21-2020 10:25
    An update here - The client had the issue recur with their next payroll even though we checked the bank code before entering the payroll. She entered the payroll and then the bank account was ***XXX. The only things that happened during that 6 hour window was a Build Search Index, Payroll checked for an update (none found) and an sync error happened from HRMS. Sage delivered a patch earlier this week and we are hopeful for the payroll this Thursday. Thank God that running the synchronization in MAS 90 mode has worked these last two payrolls because otherwise we would have been smashing things.

    ------------------------------
    Kate Krueger
    Business Applications Manager
    Eide Bailly, Inc.
    Denver CO
    970-692-5113
    ------------------------------



  • 24.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-21-2020 10:27
    Thanks for the update @Kate Krueger!  Please let us know how the patch works.​​

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 25.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-23-2020 19:17
      |   view attached

                    I'm following up on the issue regarding bank account numbers changing. I know your name was included as one of the partners needing the fix but I want to make sure you are aware of the fix (including it in this attachment) and if you have been sent the fix (more than one person sent out fixes but I didn't see one sent to you)…how did it work out for your customers?

     

    Installation instructions (version 2019)

    "Rename the existing BR_ReconciliationRegister_upd.pvc in the ..BR folder then drop this file in place."

     



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Attachment(s)



  • 26.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-23-2020 19:57
    Thank you, @Jeff Schwenk!​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90Minds Treasurer
    ------------------------------



  • 27.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 08:36
    Thanks @Jeff Schwenk  Is there a KB article for this.  I want to verify what versions this program can  be copied to.


    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 28.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 10:00
      |   view attached
    Could be this one.   Interesting note that it will be fixed in v2020 with PU1..... released in September.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Attachment(s)



  • 29.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 10:07
    I wonder if it is OK to copy the bank rec program to a 2020 release.  I wouldn't do it without written confirmation from Sage.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 30.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 10:18
    @Doug Higgs - I asked about the v2020 fix in my reply back to Brian Reddeman.  No response yet,​​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 31.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 11:51
    @Doug Higgs - From Brian Reddeman -  Yes but we didn't patch 2020, it will be in the next PU but if you need it I will ask

     



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 32.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 11:58
    Hell no, we'd rather have clients having major heart attacks when their DD files get rejected.  It's fun!

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 33.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 12:07
    Seriously?  Of course we need it.  Pro tip: Put it on the partner portal so we can all download it.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 34.  RE: Payroll - iSolved rejecting file invalid account number

    Posted 04-24-2020 12:15
    @Doug Higgs @Beth Bowers  You guys make me laugh. Thank you! ​​

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90Minds Treasurer
    ------------------------------