• ODBC Driver for Excel returning NULL values for alphanumeric item codes

    why is the container importing my excel file with blank (NULL) values for items with alpha numeric labels? additionally the columns have switched order? Excel Output Connector Module Sample Run Original Excel FIle Import
  • Power BI, Sage 100, Tools needed?

    Our company uses Sage 100c 2015. Our goal is to access Invoice History and the Item tables from Sage via ODBC to Power BI. We want this to be a real time connection. We are multi-company (4). We would have people access via Terminal Server. It's my…
  • Join Sally as she helps you forge ahead, making use of the Sage Intelligence Connector module

    Sage Intelligence gives you a lot of value out-the-box, through the ready-to-use reports provided in the Report Manager and the free reports that you can access via the Report Utility. If these aren’t exactly what you’re looking for then you also have…
  • report from excel container, only runs if workbook open

    Running Sage 2017 SP1, with Excel Container I have created an excel link for a large report that I'm going to pull several small reports from for distribution. This runs perfectly if the linked excel report is open but not if it's closed. I will…
  • Use a calculated report as base for multiple reports with additional filters

    I have a customer that updates up to 2500 invoices in a day. I have created a report that pulls all the necessary header and line detail information to produce several pivot reports. Is there a way to now use this report (so it does not have to be…
  • Still looking for an FRx replacement? Register for session BUS-563 at Sage Summit

    FRx reports can be efficiently converted to Sage 100 ERP Intelligence Reporting using the powerful functionality of the Sage Intelligence Report Designer. Sage Intelligence Product Specialist, Sandra Smith, will show you how to simply export existing…
  • How to create Consolidate Financial Statement using the Designer (Add-in Plugin) and Connector module

    Hi, I am using the Sage Intelligence Addin plugin and it works great! When I try to grab additional companies codes in Sage 100, it will not allow me to pick them. Could someone please help? I want to create a financial statement with 2 companies…