• AR_InvoiceHeaderHistory Time Stamp

    What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?
  • 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…