• Duplicate Item Numbers

    Hello, I was wondering if anyone else ran across this issue and if so, how it was resolved. We have identical item numbers that appear when we search for an item in item inquiry and item maintenance. Selecting one of the item numbers results in…
  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…
  • Sage 100c 2016 Unified Login SQL Linked Server Issue

    We have a client that is having a very strange issue with ODBC drivers when we try to setup a linked server in SQL. No matter what we try we get an error that seems to suggest that the login is failing but ONLY when we try to access it from SQL. Using…
  • Providex ODBC Invalid Date - Corrupt Date?

    Have an issue with what I believe is a corrupted date value. It resides in purchase order detail required date and PO header PO date. Running the open order report on "required expire date" for date greater than 12/30 will result in "Vendor Code 9"…
  • MAS 90 Data Access Problems with ODBC

    MAS 90 version = 4.30.0.23 ProvideX driver version = 4.21.1000 I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned. 1) MAS 90 has been set up with a role that gives me read access to all…