Sage 100

Hi there! I hope you're all doing well. I'm attempting to modify the SQL query of an ODBC Import Job, but it crashes when I press the Test button. I'd like to know if there's a resource where I can find the exact syntax of SQL required for VI Jobs…

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…

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?

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…