Sage 100

 View Only
Back to discussions
Expand all | Collapse all

v2021 - Exporting Bank Account Numbers, PII issues masking the Number

  • 1.  v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-22-2021 14:49
    Client is migrating to v2021.  They have about 10 companies that they need to submit a daily positive pay file.  Back in the day, we wrote an Access db program that captured and consolidated information from all companies and all bank accounts into one bank file.  Has worked well over the years.

    I am running into an issue now in that the PII bank account information is masked when exported.  Not good for positive pay.  Export user has full rights in role maintenance.  We could use the BR positive pay program but client has 10 companies to run the process for.

    Has anyone determined a way to export the complete account number?




    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-22-2021 15:09
    Hi, Jeff. I could be off base here, but have you checked Bank Code Maintenance to make sure that the bank account number field isn't actually masked there?

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



  • 3.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-22-2021 15:21
    The PII worktable is in GL, as is the detail in GL_Bank.  However, I don't think the table will allow the data be exported :(

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

    Original Message


  • 4.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-22-2021 15:43
    Do it as a custom report from within Sage, then export from there (instead of using ODBC).

    We're going to run into the same problem with our Canadian EFT script (that uses ODBC)... and if you really don't care about PII security, you could add UDF's instead to GL_Bank... but you didn't get that idea from me.  ;-)

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

    Original Message


  • 5.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 03:01
    Edited by Dan Burleson 10-23-2021 03:17
    You could capture a preview session of the A/P Bank Code Listing Work table for each company and replace the base file (CI_BankCodeListingWrk)  then link it to GL_Bank. They could change bank accounts so you could have me refresh this automatically if/when they do. At least this way you can point to the Bank Code Listing report as the Sage code that's exposing the sensitive information - not a UDF.

    v2021

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 6.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 10:13
    @Karen O'Lane - Nope you are 100% on base.  Sage does mask the number in maintenance.  I looked in the role maintenance and I could not find ​any role similar to PR setting allowing viewing, printing and editing of PII.  Ugh.

    @Michelle Taylor - I wonder if the listing RPT needs to be modified to include this table.
    ​
    @Kevin Moyes - Interesting thought but I don't think it is workable for this opportunity.  Access DB is menu driven.  Client simply fires it up, data from all companies is pulled into the db via PTQ's, combined with union queries, select queries pull the bank required information which is outputted to a fixed length text file for uploading to bank.  Entire process takes about a minute.  I don't want to add steps to the process.  Client hates change.

    @Dan Burleson - Your solution for PR PII exports was genius.  Will be contacting you.  Hopefully, you can capture lightning in a bottle once again.
    ​​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 7.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 11:43
    @Jeff Schwenk - The Role info for this is under GL security -
    ​

    BUT there is an on-going issue that about 5-6 of my clients now enjoy, in which the actual value is changed in Bank Code Maintenance to include the **** or it completely blanks out the account.  Have been working for a year with Sage on this and just had an upgrade to 2021 start having it happen, so it's still an issue.  Seems to be related to Positive Pay or updating the Bank Recon Report.

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

    Original Message


  • 8.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 13:42
    I have the same issue that @Beth Bowers reported with a customer that does PosPay. They have to keep vigil on bank code mtc because it just randomly changes to be masked. PITA.​

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

    Original Message


  • 9.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 14:46
    Hmmm.  So I drank a shot of courage and changed the bank account number in BR bank maintenance (two accounts) and the numbers appear.  Two steps forward, none back......... yet.

    Regarding the mystery of the "random" masked accounts, I have a theory based on working with the PR PII.  If a user performed maintenance and did NOT have PII view permission, the social number is masked.  So if you extend that logic to positive pay, if the person running the positive program does NOT have PII rights, could the account number become masked?  I believe so.

    Something to ponder...

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 10.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 13:44
    Ugh!!!  Who but Sage thinks to put Bank reconciliation information under the general ledger........  Regrettably, the role was active form me and the bank account field and bank listing is still masked.  And while on the client's system yesterday, field blanked out after I entered the full number over the masked data.  I believe I was in Bank code maintenance.  User had default role rights.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 11.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 14:25

    I also have 2 customers with this same issue happening over and over again. Opened a Case with Sage thinking that if I have 2 customers that this is happening to, they must have a resolution.  They did not seem to have anything other than what is posted online – all of which I have already tested before calling them.

     

    They did find a record in gl_bank table that was blank and we removed that hoping that might be the cause. the next day the client emailed me that it happened again.

     

     

     

     

     

    Don't miss out!

    Our 2021 Sage 100 User Group is coming up.: View the details

    *********************

     

    Thanks

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     




    Original Message


  • 12.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-23-2021 16:45
    Here's the case I opened in Mar, maybe, of 2020 - 8008005306.  Feel free to add on.  They had a fix for me at one time, but it continued to happen (less frequently, but still did).  It's been at least version 2019-2021.

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

    Original Message


  • 13.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 08:54
    I had this same issue with a client.  Checking "Allow Viewing, Printing, and Editing of Highly Sensitive Personally Identifiable Information" in Role Maintenance caused the bank account number to become unmasked in Bank Code Maintenance which then transferred to Positive Pay.

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------



  • 14.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 09:03

    At both of my clients (both are still on version 2020 PU1 or PU2. I've turned on that setting in Role maintenance for every user and it has not helped. One of my clients thinks that it seems to happen after she runs and updates the bank reconciliation register, but we have not yet confirmed that is the issue.

     

     

     

     

    Don't miss out!

    Our 2021 Sage 100 User Group is coming up.: View the details

    *********************

     

    Thanks

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     




    Original Message


  • 15.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 09:38
    Interesting.  I tend not to use/teach/show the reconciliation register.  Old school perhaps...  Maybe they can do transaction JE's, Cash receipts or AP manual checks to rule confirm/rule out that theory.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 16.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 11-11-2021 02:07
    There was a hot fix for 2020 to address this but root cause was running the bank reconciliation register would cause the account to be asterisked out (even with the proper security). I am not sure if that same hot fix is out for 2021/included in product but at least wanted to mention it.

    Sent from my iPhone


    Original Message


  • 17.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 11-11-2021 08:46

    Thanks Tara,

    I did install the hotfix and when I was on the call with Sage they verified that it showed in the installed module listing. I'm glad you brought this back up, it has been few weeks and neither client has reported this happening again. I'm going to email them this morning and see if they have seen this happen again or not.

     

    The last thing I did with both clients is remove a blank/corrupted record from GL_Bank table. When we did that it was a "cross your fingers" and hope sort of thing, but maybe that really was it. Although I'm sure I just jinxed myself.

     

     

     

    Don't miss out!

    Our 2021 Sage 100 User Group is coming up.: View the details

    *********************

     

    Thanks

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     




    Original Message


  • 18.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 09:55
    I have a client on 2019 and after I checked the box to allow, it worked for me and main user.  However, another user tried it (that didn't have permissions) and of course it didn't work, but it also then failed for the main user (that did have permissions).  I found the Bank Account masked in Bank Code Maintenance.  I had them retype it and now it works.
    I'm curious is you have the account showing in Bank Code and a user without permissions tries to create a Pos Pay file (in this case anyway) if somehow the account number 'self masks' and all users are then masked till retyped again.
    Nancy

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


  • 19.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 10:07

    That is basically what we are seeing; once the account gets masked then it is masked for all users until someone goes in and re-types it. but I have enabled that option for all users and it still keeps getting masked out at some point.  The option I'm changing in role maintenance is under the GL>Security Events.  Is there another setting somewhere that I'm not seeing?  

     

     

     

     

    Don't miss out!

    Our 2021 Sage 100 User Group is coming up.: View the details

    *********************

     

    Thanks

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     




    Original Message


  • 20.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 10:45
    @David Overholt no, that is what solved it for me...I don't know what the differences in the two systems are.​

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------

    Original Message


  • 21.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 11:33
    At another client, the account number was masked after a user ran positive pay without the necessary rights to PII.  I had to reset the account in bank account maintenance.  I gave PII access to everyone running positive pay.  This user is on v2020, not sure of the PU.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 22.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-27-2021 11:05
    @Nancy Hanson - OMG, I like that idea.  Passing it along to the Sage folks I've been working with on this issue.​

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

    Original Message


  • 23.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-27-2021 11:59
    Yes, @Nancy Hanson, if a user tries to access (any function that utilizes) the bank account data, ​the record will encrypt and print as encrypted - with asterisks.

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

    Original Message


  • 24.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-25-2021 10:56
    Edited by Wayne Schulz 10-25-2021 11:14
    It sounds like a number of different issues are being discussed here.

    ODBC connection to external source - no can do PII

    ODBC connection to custom report with PII tabs added and placed in Sage custom menu - can do

    Masking of account numbers in the ACH - May be due to lack of rights for role - as noted here and here.

    Masking of account numbers in bank account maintenance. Possibly an issue with lack of rights for a role as noted here. I thought there was a patch for a program issue as well. I seem to recall something with updating the bank reconciliation register causing some masking but I'm not able to locate the patch that I thought Sage issued on this one.



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





  • 25.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 10-29-2021 08:25
    Edited by Jeff Schwenk 11-02-2021 13:41
    @Dan Burleson - delivered a genius script solution for me to try.  Will be testing it next week.  Very similar to his PR PII workaround for non Crystal queries.​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 26.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 11-05-2021 17:20
    I have a second client who I didn't get so lucky with:  just upgraded to v2021.  In Bank Code Maintenance the account number is not encrypted.  In v2018 they had added the GL_Bank Account No. field to the AP_CheckWrk table and to the check form; worked fine.  In v2021 the UDF did not convert (was simply missing); I recreated it; it prints on the check encrypted.  Has anyone here made any progress with their issues?​​

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------

    Original Message


  • 27.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 11-05-2021 18:44
    I have a solution for this. Email me direct if you would like more information or to try it. One issue I've encountered is that some GL_Bank tables have a null record that when read by scripting appears as if the entire table is empty.  The ODBC ignores the null record, but for my solution to work these records must be deleted.

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 28.  RE: v2021 - Exporting Bank Account Numbers, PII issues masking the Number

    Posted 11-05-2021 19:26
    As noted above, Dan's solution is Genius.  Has been working at client for several days for my application's issue.  Dan guarantees satisfaction, period. 

    U di gave a question though.  Why are they printing it on the check if it is not for the MICR line?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content