• 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 Alerts & Workflow v10 w/providex

    Has anyone used Sage Alerts & Workflow v10 w/Sage 100 providex yet? When I try to add a calculated column, the top where it says calculations to perform is blank and I can't choose a calculation. If try to do it manually whatever calculation I receive…
  • Sage + Excel?

    We're using the SODAMAS90 4.0 ODBC driver from sage. Our excel is part of office 365, so it is the latest version. We were able at one point in time (a few weeks ago) to run queries in excel via Data > Get Data > From Other Sources > From Microsoft Query…
  • SOTAMAS 90 & Power Pivot Error

    Probably a long shot here but whilst trying to import Sage data tables into the Power Pivot table wizard i get the following error: 'Object reference not set to an instance of an object' Any thoughts?
  • ODBC Connection for Power BI

    I have a client that wants to create a dashboard using Power BI, but not with Sage Intelligence. Has anyone created an ODBC connection for use with Power BI? If so, can you outline what you did? Thanks,
  • ODBC driver is whacked

    Have a client whose ODBC is suddenly not working. You can create a company-specific connection and it works fine, but if you try to use SOTAMAS90 or create a new one with no company stored, it will not prompt for the company (grayed out, can't drop down…
  • Sage ODBC Query w/ Inner Join

    I am attempting to run the following query in an ODBC to Sage. I am getting the following error: Unexpected Inner token: INNER Here is the query: SELECT AR_InvoiceHistoryHeader.InvoiceNo, AR_InvoiceHistoryHeader.InvoiceDate, AR_InvoiceHistoryHeader…