• Pass through variable "Last full month"

    What is the sql statement needed to get the last full month for a pass-through variable. Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month. As always thanks in advance for your assistance…
  • Sage Intelligence duplicating data single table

    On Sage 100 Advanced 2021 sp5. I created a container with only the AR_InvoiceHistoryHeader file. added 4 fields. set the filters to a single date and only Source Journal "SO" the invoices are all duplicated. I tried the same thing on a different…
  • 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?
  • Sage Intelligence Reporting Webcasts

    Hello to our Sage 100 U.S. members! :) We understand the impact the Coronavirus (COVID-19) is having and how it has and still is affecting your business. We want you to know: we're here to help and as the new year approaches, we would like to take the…
  • Sage 100 2019 Sage Intelligence Bank Account Number

    Wrote a Positive Pay report using the Intelligence a couple of years ago for a client. The report contains the Bank Account Number from the GL_Bank file. They just upgraded to Sage 100 2019 ran the report and the Bank Account Number is blank. Searched…
  • 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…
  • 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…
  • Error? Excel cannot open the file "xx" because the file format or file extension is not valid

    I need help with this error message. This particular file worked fine on Friday. Now, on Monday, it won't open. My other files seem to work just fine. I get this error: Excel cannot open the file "file name" because the file format or file extension…
  • sage time format / Crystal Report

    Hello, i am trying to create a report, and want to supply the TimeUpdated String(8) field from the IM_PriceCode table. can i create a formula field to convert that Field to a 12 hour time field? if so.. how? Thanks for reading. Peter
  • Sage Intelligence Data Limit Reached in Excel

    I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…
  • YTD only data for Income Statement and balance Sheet - tree with 60+ companies

    I have a customer that we are converting from MAS90 ver 4.3 Frx to Sage 100 ver 2017 SI. Their old Frx reports ran in a matter of minutes. The SI reports for P&L with 64 companies in the tree take only 9 min on my stand alone system with their data…
  • Sage 100 Intelligence Reporting Webcasts (August & September)

    Sage 100 Intelligence Reporting gives you more time to analyze reports so you can make smart business decisions that will give your company a competitive edge. Get the most out of Intelligence Reporting by signing up for these free webcasts in August…
  • Error 462 while attempting to run Sage Intelligence Reports (in Sage 100c 2016)

    I have a client experiencing some errors I have never seen... They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like... Here is…
  • 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…
  • I cannot print invoices in a range, it only print the first invoice.

    I cannot print invoices in a range, it only print the first invoice.
  • Error Printing range of Invoices (Data is not selected for report printing)

    I do not want to use the option "Print the option already printed" I know for sure that there should be a way to print in range without selecting that option. Thank you for your help.