Sage 100

 View Only

  • 1.  Excel (64bit) query of BIE view not working on new workstation

    Posted 11-14-2019 14:15
    We have a user with a new workstation and their existing spreadsheet won't pull in the BIE view data (vItemWarehouse).  I'm trying on my new Win10 workstation and am having the same problem... the column list won't populate.

    Any ideas? 
    User is 2016 Standard (non-C, so classic is only desktop option) and I'm using 2019 Standard.  Explore works within Sage 100 and for other users (so it isn't the EV file).  Sage KB articles don't help (registry key deletion, switching to Standard and back to Classic...).


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


  • 2.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-14-2019 18:06
      |   view attached
    There is an Excel compatibility patch I've installed with Excel 64 bit.  See attached.

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

    Attachment(s)

    zip
    Excel2016CompatibilityPack.zip   2.07 MB 1 version


  • 3.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-14-2019 18:39
    Thanks for the tip Moira... that seems to be in reference to a Sage Intelligence issue. 

    Installed (as well as Microsoft Updates to Office), and the problem persists.

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

    Original Message


  • 4.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-15-2019 03:15
    Edited by Alnoor Cassim 11-15-2019 03:16
    Kevin - I don't know if this helps but all the "v" tables are not BIE views. Rather they are base BIR (Business Insights Reporter) views (ProvideX views) that appear in the dictionary for non-Premium installs.

    With Excel looks like you are using MS Query Wizard so maybe you can't see column list and data that way but I can when I choose Data tab, Get Data, From Other Sources, From ODBC, choose SOTAMAS90 then Navigator appears. I see regular list of tables and these views starting with "v" and since I've used BIR before to create reports, also see those starting with "view:"  It also returns the data in the view. I'm running Office 365 / Excel 2016 with latest updates running against v2017 Adv.

    To see the columns ahead of time you can:

    1. File > Run > SYZCON type VU and Enter. Don't modify anything, choose the Warehouse Information group then ItemWarehouse then dbl-click for fields
    2. Use Crystal Reports.
    3. Go thru the BIR wizard (under Business Insights \ Business Insights Reporter) using that same view until you get to the Select Fields screen.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------

    Original Message


  • 5.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-15-2019 15:47
    Thanks Alnoor, I can query using ODBC with a 32-bit tool.

    From within 64 bit Excel using your method, it still gives an error.

    John @ Sage seems to think these views are 32-bit only.  :-(

    ​

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

    Original Message


  • 6.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-15-2019 17:08
    My Excel is 32-bit. I think you're right on.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------

    Original Message


  • 7.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-19-2019 13:27
    FYI, Sage confirmed it is a 64-bit issue, and may release a fix in early 2020.
    (See John's reply).

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

    Original Message


  • 8.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-15-2019 08:26
    The below information may serve as a workaround:

    As a temporary workaround rename ..\MAS90\Home\xmllite.dll to \MAS90\Home\xmllite.old
    *Caveat* If the customer has development partner modifications that include the interpreter utilizing XML functionality renaming the file above will cause an error in the development partner functionality."

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 9.  RE: Excel (64bit) query of BIE view not working on new workstation

    Posted 11-15-2019 15:56
    Thanks Doug, but no effect.

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

    Original Message


Related Content