Sage 100

 View Only
  • 1.  BIE - Open PO's by detail line V2018

    Posted 05-23-2019 14:14
    Client running v2018 Advanced.  We had to activate ODBC security by role because they hired a person that was knowledgeable with ODBC queries and liked to use them.  Ugh!

    Now the PO Role is functioning except for the BIE Explorer views.  User can access the PO header table but not able to get to the accompanying detail table for the view (below).  View works fine for super users (me).  So the question is where did they hide the check box to expose this table in BIE Explorer?????

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


  • 2.  RE: BIE - Open PO's by detail line V2018

    Posted 05-24-2019 09:39
    Edited by alan niergarth 05-24-2019 09:40
    IN ODBC security role try checking the Common Information box.  Sage KB ID 36322

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------