Sage 100

 View Only
Expand all | Collapse all

Blank Bank Code in BR

  • 1.  Blank Bank Code in BR

    Posted 10-12-2022 13:34
    We had our third client call today, with Bank Codes being Blank in BR after running a Posi Pay Report.  The solution is obviously to re-enter the Bank Code in and type in the name of the Bank again, but we're wondering what could be happening to cause the problem.  All 3 clients have had no recent Sage updates since earlier this year, and they've been running the report just fine, and the Bank Code has stayed put prior to this.  Each of them have indeed have Windows updates on their computers and servers - not sure how Windows could affect only one file but that seems the only culprit.  Anyone else experiencing the Blank Bank Codes?

    ------------------------------
    Sue Bennett
    Jack of All Trades, Master of 1
    Bennett/Porter & Associates, Inc.
    ------------------------------


  • 2.  RE: Blank Bank Code in BR

    Posted 10-12-2022 14:28
    We've seen blank rows in GL_Bank for years, but have never been able to figure out how they are created.  Checking for a blank row is even included in our steps for rebuild sort files, because the blank row causes real damage to the data with that utility.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 3.  RE: Blank Bank Code in BR

    Posted 10-14-2022 14:29
    I had a call today from a client with the same question.  just in case anyone is counting that makes 4

    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 4.  RE: Blank Bank Code in BR

    Posted 10-14-2022 15:16
    I think it's related to the missing/partially **** out Bank Account number, IMHO

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 5.  RE: Blank Bank Code in BR

    Posted 10-26-2022 14:46

    We upgraded a client to version 2022.2 about two or three weeks ago thinking that was going to resolve this issue – they emailed me today saying that it disappeared again.{sigh}



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 6.  RE: Blank Bank Code in BR

    Posted 10-26-2022 15:24
    @David Overholt - (montone) 'It's never going to work..."​

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 7.  RE: Blank Bank Code in BR

    Posted 11-01-2022 15:10
    I have opened a new case with Sage support. at first they tried to blame it on a network issue (what??).  i pushed back that it has been happening with more than one client of mine and that I've see postings on Sage City and 90 Minds so that didn't really seem likely. he asked me to install the fix that was put out for 2022.0 and of course that would not install on 2022.2 (but I did try on my local just to verify). 

     He is checking with applications team to see if it is a known issue still in version 2022.2. I told him that I had to keep this active until it is fixed since my client unhappy that it costs them time and effort to double check something that should not be disappearing.

    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 8.  RE: Blank Bank Code in BR

    Posted 11-01-2022 22:05
    Good luck on holding their feet to the fire @David Overholt


    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 9.  RE: Blank Bank Code in BR

    Posted 11-02-2022 11:44
    I also have a similar problem: the Bank Account number gets cleared (not masked but cleared) in Bank Account Maintenance.  I have applied the Sage hot fix but the problem still exists.  This client is on 2021.

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------



  • 10.  RE: Blank Bank Code in BR

    Posted 11-27-2023 15:41

    Me too.  Keep me posted if anyone finds a fix.



    ------------------------------
    Jon Parkinson
    Timac Business Systems
    ------------------------------



  • 11.  RE: Blank Bank Code in BR

    Posted 04-27-2024 13:18

    It's alive!!!!!!

    Bank account maintenance Account number field is suddenly blank.  It took several rejected positive pay submissions before the client reached out.  Rekeyed bank account number and resolved positive pay file issue.  Now for the root cause.  Client running 2023.2 SQL with DSD enhancements.  Worked without issue for the past two months.  Then out of the blue - Wham.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 12.  RE: Blank Bank Code in BR

    Posted 04-27-2024 14:04

    I have a client who recently upgraded from 2020 to 2023.2.  She is now experiencing the blank account issue.  She uses Positive Pay.  I have another open case with Sage (8010015279) that Ronnie Aspe and Kent Mackall are involved in.  Kent is going to create a version of the Positive Pay program that keeps a log of any postings to the Bank Code file, but we've done this before on a prior version and got nowhere.

    I also have another client on 2021 who just recently started having it happen and they do NOT use Positive Pay, but the BR clerk noticed it happened after updating the Bank Reconciliation Report (purge) at period end.

    And I have a third client on 2023.1 who just recently started having it happen and they also use Positive Pay.

    We kept thinking it had something to do with Positive Pay, but now I'm thinking it's just that the clients who use Positive Pay NOTICE it because it screws up their file.

    This seems to go in spurts.  I have X number of clients who have the issue, then all of a sudden I get several more added to the list.  Very perplexing and irritating.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 13.  RE: Blank Bank Code in BR

    Posted 04-27-2024 14:20

    Any chance the issue is related to role permissions?  Curious if the user has GL security event - Allow Viewing, Printing, and Editing of Highly Sensitive Personally Identifiable Information.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 14.  RE: Blank Bank Code in BR

    Posted 04-27-2024 14:21

    Nope, it's not that.  And it's not ALL the time, either.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 15.  RE: Blank Bank Code in BR

    Posted 04-27-2024 15:01

    I wonder if it's another user causing it to disappear with another process, and just being noticed by the positive pay user 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 16.  RE: Blank Bank Code in BR

    Posted 04-27-2024 18:00

    Maybe we should create a SAW alert to monitor!!!!



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 17.  RE: Blank Bank Code in BR

    Posted 04-28-2024 20:16

    Did anyone else have a situation where the bank account table had a blank record?



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 18.  RE: Blank Bank Code in BR

    Posted 04-29-2024 07:57

    I see that occasionally and it does not seem to have any correlation to this other issue.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 19.  RE: Blank Bank Code in BR

    Posted 04-28-2024 20:23

    Bank Account Number and the Bank Code Description are missing

    Adding this link as cross-reference to a similar report ( if not a report about this issue ). Sage claims it's fixed  in the KB but it doesn't seem like the reports here are supporting that.

    Fixed in 7.10.4, 7.20.1 and 7.3(2024) when released.
     
    Temporary solution is to reenter the bank account number and bank code description in bank code maintenance.
     
    Note: user must have permissions to view, edit, or print Highly Sensitive Personally Identifiable Information (PII). see Related resources



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 20.  RE: Blank Bank Code in BR

    Posted 04-28-2024 22:04

    So is the problem that the user needs bank account permissions and PII, and somewhere in the permissions check it can blank out the fields?



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------



  • 21.  RE: Blank Bank Code in BR

    Posted 04-29-2024 07:56

    @Phil McIntosh - we'd love to know... The irritating part is that it is not consistent, i.e. doesn't happen EVERY period end or EVERY Positive Pay or EVERY whatever it is.  Or maybe it IS consistent, but the trigger is that you're standing on your head barking like a dog while right clicking the up arrow and people don't do that every month.  :-)



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 22.  RE: Blank Bank Code in BR

    Posted 04-29-2024 10:57

    This isn't fixed in 2023 PU 2 which is what my client is running.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 23.  RE: Blank Bank Code in BR

    Posted 11-05-2025 14:40

    Didn't Sage say at MOTM 2025 that they finally figured this out & they will be releasing a fix? I have this memory of a grand applause moment... but I can't find it fixed in any PU or hotfix. Was a fix ever published? Did I imagine this all?



    ------------------------------
    Dana Young
    Lehman Wesley
    Lansing, MI
    ------------------------------



  • 24.  RE: Blank Bank Code in BR

    Posted 11-05-2025 14:43

    v2024 PU 2



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 25.  RE: Blank Bank Code in BR

    Posted 11-05-2025 14:54

    Thank you! @Jeff Schwenk

    It would be so silly for Sage to actually update the KB article that the fix was published in particular product updates. :)



    ------------------------------
    Dana Young
    Lehman Wesley
    Lansing, MI
    ------------------------------



  • 26.  RE: Blank Bank Code in BR

    Posted 11-05-2025 14:58

    @Dana Young - They don't want to commit to something like that! Put it in writing? No way!



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    559-448-0900
    559-577-4142
    http://www.asifocus.com
    ------------------------------



  • 27.  RE: Blank Bank Code in BR

    Posted 11-05-2025 15:39

    What I find crazy is that it seems many of these bugs are solved by now hidden fixes that you have to encounter on your own then call Sage and get a disclaimer/waiver (not sure why the VAR has to sign these but that's a different issue ).

    Then when you are staging an upgrade like Sage 100 2025 you can grab PU1 but I'm always left with this uneasy feeling that I'm probably missing a patch or two.

    There's now no way to find these one-off patches since unless they are big enough to embarrass Sage it doesn't seem like the patches are publicly available.

    Which makes no sense to me as part of getting a client system all staged for an upgrade.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Connecticut
    ------------------------------



  • 28.  RE: Blank Bank Code in BR

    Posted 11-05-2025 16:15

    Testing hotfixes for general release have real costs (for Sage, and all developers with enhancements affected by the fix). 

    I don't like it, but I do understand why issues not getting lots of complaints will be put on the list for general PU QA testing.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 29.  RE: Blank Bank Code in BR

    Posted 11-05-2025 17:01

    But what about the "costs" to the end user and reseller by NOT communicating via the KB that the problems has been resolved with this PU or hotfix that you have to jump through Sage legal hoops to get.  At LEAST communicate this end user can make an informed decision on how to proceed.  And so the reseller can do productive things instead of searching for an elusive KB fix or asking on the 90M forum or on the Sage Community.

    Communication is a LOT less expensive than burying your head in the sand!



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 30.  RE: Blank Bank Code in BR

    Posted 11-05-2025 17:18

    You're preaching to the choir on that one Jeff.  I want hotfixes readily available for known issues.  I understand their behaviour, but I don't agree with it.

    I asked at MOTM in 2020 for Sage to have an RSS feed for new / updated KB articles, to give us an easy way to know what new issues are being reported... which of course went nowhere.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------