• Type mismatch when using zeroingll in Sage Intelligence

    Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?
  • Sage Intelligence missing report on Viewer

    I have a client using Sage 100 in a cloud platform (SWK). When I login under the client's name into SAGE (but my name on the network), I can see a report in Report Viewer. When the client logs in under their name in the network and into Sage, they do…
  • Create company parameter for Intelligence report template used across multiple databases

    We have a client that has several hundred companies in Sage 100. They have a report template that they would like to run individually on each of these companies. The customer owns the Connector module. Using the standard Autoconnect connection in…
  • Sage Intelligence Connector - Adding a duplicate or alias table

    Sage 2019 I created a Data Container. I added a table and would like to add an alias of the same table with a left join. When I attempt to add the table, a message informs me the table has already been added. In Crystal or Access, I am allowed…
  • Power BI and Sage Intelligence and looking to hire an expert

    Hi All, Our company has Sage 100 2015 and we are just now starting to use Sage Intelligence. I am pretty used to report writers so learning to write reports in SI is fairly easy. However, my difficulties have to do with the set up of Power BI…
  • Sage Intelligence Link Formula between Excel worksheets

    Does any know if we can link (or reference) GL accounts from one worksheet to another in SMI report? The purpose is to is to simplify update of accounts Say sheet1 we have a good report. In sheet2 column A, we want to link to accounts in sheet1. If…