Sage 100

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…

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,

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…

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…

Is it possible with 2014 and 64 bit ODBC to connect to Sage 100 tables for Excel Power Pivot? Everything I try I get tables not accessible. I know this has been an issue on older releases but I was hoping with new releases it would work. If it is…