Sage 100

 View Only

  • 1.  Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-04-2019 14:58
    Just a heads up to anyone upgrading to 2019 with Scanco Multi-Bin. Scanco changed the MB file names to have their own developer code of 140. ACSG was 404. So any MB file that used to be 404 is now 140. For example IM_404ItemLocation.M4T is now IM_140ItemLocation.M4T. Obviously this breaks all Crystal Reports and Excel Queries. Unfortunately MASCRCW does not convert it either.
    And now to my question for all the Excel Gurus out there. I can deal with the Crystal Reports changes, but my customer is upgrading from 2015 to 2019 and has many Excel Queries pointing to these files. Anyone know of a tool or an easy way to change the query definitions in multiple Excel files?  TIA

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------


  • 2.  RE: Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-04-2019 23:25
    AH, so that is why the v2019 version took so long to release....  Kinda sucks.

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



  • 3.  RE: Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-05-2019 00:26
    You'll need to loop through workbooks and for each workbook, loop through its Connections, for each connection, check the CommandText property for the 404 string and replace it with 140.
    You can either accomplish this using Excel and use its VBA or a VBScript file that can be executed on a workstation with excel installed.
    If you have access to all the workbooks in their environment through network shares, it will probably be easier to have the customer supply you with a workbook with a column that contains the full UNC path to each workbook that they need updated. Then you can have VBA code loop through the range and open each workbook to check its connections.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 4.  RE: Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-05-2019 00:36
    Something like this should work for the looping through the connections in the active workbook. This is only checking the connection if it uses the ODBCConnection object, if you are using OLE or something else, you will likely need another block of code.
        Dim Connection As WorkbookConnection
    
    For Each Connection In ActiveWorkbook.Connections
        If Not (Connection.ODBCConnection Is Nothing) Then
            Connection.ODBCConnection.CommandText = Replace(Connection.ODBCConnection.CommandText, "404_", "140_")
            Connection.Refresh
        End If
    Next


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 5.  RE: Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-05-2019 07:16
    @Kenny Daniel, did you find out by accident,  ​or was this documented in their Install Guide?

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 6.  RE: Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-05-2019 08:44
    @David Speck II Thank you so much for the code. It's a bit (actually, a lot) over my pay grade but I'll give it to their IT and see if they can deal with it.

    ​@Madeline Stefanou​ I found out by accident. I spoke to Scanco once I found out and they said they will document it going forward. I started noticing it when MASCRCW was failing on so many report conversions.

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------

    Original Message


  • 7.  RE: Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-05-2019 09:53
    You can add to the MASCRCW.ini file to translate your fields or files that have changed.Look through it and you will see how it is organized
    There is a section like this
    [Tables]
    AP8_ManualCheckG/LDist=AP8_ManualCheckGLDist 

    This covers for different versions by listing each time the table changes so later down in the Tables section you will see this

    AP8_ManualCheckGLDist=AP_ManualCheckInvDetail

    Then you will see the section for the actual table for the fields in the table

    [AP_ManualCheckInvDetail]
    G/LAcctNumber=GLAcctNumber

    You should be able to do the same thing for their fields. Keep a copy of the original just in case something gets messed up when you change it. This will not fix the Excel Queries.

    ------------------------------
    Todd Martin - President
    MBA Business Software (https://www.mbabsi.com)
    ------------------------------



  • 8.  RE: Scanco Multi Bin - Crystal Reports and Excel Queries

    Posted 11-06-2019 08:51
    @Madeline Stefanou - Below is text from step 9 / 10 of the install PDF sent to my client multi-bin for v2019 PU2.  A bit understated I think

    Version 2019 includes a complete restructuring of Scanco Multi-Bin background file structure.  Please take special care to review custom Crystal Reports, imports, and integrations that may be affected. We highly recommend a test phase, especially for highly customized users, to avoid
    conflicts ​

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

    Original Message


Related Content