• AR Aged Invoice Report

    Hello, I'm just trying to set up auto delivery for this report but it looks like it is only available in the stock Crystal Report form. Does anyone know if it's available in Sage Intelligence or if there is a way to convert Crystal Report reports to Sage…
  • convert single company GL reports to consolidated company reports

    Can the reports "GL Transactions incl BegBalances" & "GL Transactions Incl Open Balances" be converted to Consolidation reports? Or, is there a way to set the company code and add the 8 companies as sub-reports?
  • 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
  • Is Excel 2019 Perpetual License Supported with Sage Intelligence (Sage 100 v2020)

    We would like to install Excel 2019 perpetual license so Sage Intelligence can be run, however, the Sage Compatibility Matrix lists Excel 2010, 2013, 2016 or o365 Desktop as compatible with Sage Intelligence for Sage 100 version 2020 (6.2). Excel 2019…
  • After a report opens, it gives a #nameerror for every single formula I've used in the report

    I am able to open reports just fine on my computer. My boss, however, is getting #name errors on all forumulas when he runs the same reports. The 3 add-ins are turned on in his Excel. It worked fine for him yesterday. Any idea what the problem…
  • Is there a way to pull data from a specific source code, like AP or AR?

    We are looking for a way to separate our YE AJE's. It was suggested to us to use a source code named AJ. We'd like to create a set of financials that shows the unadjusted trial balance, then the AJE's, and then the final balances. So, my question is…