Sage 100

 View Only
Back to discussions
Expand all | Collapse all

GL Exchange not seeing mapped drives after upgrade

  • 1.  GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:10
    Sage 100 standard, just upgraded from 2018 to 2021.2, and now GL Exchange cannot see the mapped drive where the files to be imported are stored.  Saved jobs give  "Source file cannot be opened" error, and if you try to create a new one the T: drive does not show up.  Users can get to the T drive and the files in it from Windows Explorer and open the file in Excel just fine.  Comparative screenshot attached.
    Anyone else seen this?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 2.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:14
    Trying running Sage as an admin and see if that works. 

    Tara Morgan Schinkel, CPA

    Sage 100 Consultant

    Act! and Sage CRM Consultant

    Phone: 410-309-9550 x1104

    www.stewarttechnologies.com









  • 3.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:18
    @Tara Schinkel - Great idea but unfortunately not the solution.​

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 4.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:40
    Is the Sage client running locally?  If it's running from a different location (through a Citrix published app, for example) then the drive mappings that Sage 100 Standard "sees" would be relative to the Citrix box, not the user's local workstation.  Also, does a UNC path work?

    ------------------------------
    Jim Petrie
    Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 5.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:46
    It is in a hosted VM environment - each workstation is a separate VM, and workstation setup was installed on each of them.  It was working correctly in 2018, but the mapped drive doesn't show up in 2021.2.  When I log in with my admin credentials and set up the drive mapping for my account, it does show up, but not for any of the users, even when launching Sage 100 via Run As Administrator in the shortcut.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 6.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:50
    For Advanced / Premium, we believe it runs from the perspective of the server (so UNC is required... no mapped drives), but that shouldn't apply to Standard.  Odd.

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

    Original Message


  • 7.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:53
    There was a documented/known issue of something similar with this when saving PDF files from within Sage 100 when previewing/printing reports. The fix involved a registry hack to resolve it. I'm stuck in meetings right now so I can't go looking for it but I'm sharing with you guys in case someone has time to go digging for it. The exact issue was running Sage as admin, previewing a report and then trying to export, all the mapped drives are gone. This could be a similar situation. Doesn't matter version of Sage - we've seen this on Standard and Advanced. 

    Tara Morgan Schinkel, CPA

    Sage 100 Consultant

    Act! and Sage CRM Consultant

    Phone: 410-309-9550 x1104

    www.stewarttechnologies.com







    Original Message


  • 8.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 15:23
    @Tara Schinkel - Is this the KB article?  https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=64940&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=3748&cmd=displayKC&dialogID=232644&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true​

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 9.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 16:06
    I actually haven't seen this one before. The one I used was a reporting issue with saving PDF files and it was a registry hack related to it. However, does this article work for you?

    Tara Morgan Schinkel, CPA

    Sage 100 Consultant

    Act! and Sage CRM Consultant

    Phone: 410-309-9550 x1104

    www.stewarttechnologies.com







    Original Message


  • 10.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 11:18
    New role permission that is not checked in 2021.2?

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

    Original Message


  • 11.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 10:18
    We know there is a path character limit.  Make sure you aren't running into that.

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



  • 12.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 11:15
    Since this is standard, can I assume there is no "service" account running which would also  need permissions to the folders?

    ------------------------------
    Gary Feldman
    Cloud Evangelist
    I-Business Network, LLC
    Marietta GA
    6786270646 x224
    http://www.summithosting.com
    ------------------------------



  • 13.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-27-2021 22:53
    I am not a GL Exchange aficionado, so I may be way off base.  But this sounds like a similar issue I've experienced with positive pay imports.  If I select the path field and change to the correct path (from default), then go to the file field and find the import file, Sage returns an error as well.  I finally stumbled on leaving the path field untouched, selecting the file name field, navigate to the path/file field and everything was fine in Denmark.  Worth a long shot.

    ------------------------------
    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


  • 14.  RE: GL Exchange not seeing mapped drives after upgrade

    Posted 10-29-2021 10:16
    So, it is the same issue with Exporting Reports when opening Sage 100 via Run As Administrator.  You can move this out of Urgent.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


Related Content