• Duplicate account numbers in consolidated report (Accounts S500 1-0)

    Changed a report to pick up 3 of our companies (A,P and C) (Created consolidated connector then exported and imported the report using the consolidated connection) The accounts union report (Accounts S500) is one of the many that are included in it…
  • Is there a Sage Intelligence report that would generate or could to be used to generate an A/R Trial Balance.

    The A/R trial balance within SAGE 500 is not flexible enough to easily sort the returned data by invoice number. We are hoping SI could provide greater flexibility.
  • Suppressing Zero Rows

    We had the same issue with suppressing zero rows once the report is run out and wanted to share our solution. Background: The ZeroFill function is used to suppress rows which have zero value in a particular column in the Excel Workbook. If a parameter…
  • Income Statement - Current Quarter

    What is the best way to create an Income Statement that contains 2 columns, the first column is "Current Quarter" and the second column is YTD column? I am trying to figure out the best formula for the current quarter. Is there a way to input a range…
  • Sage Intelligence Row definition

    We are trying to use SI as a replacement for FRx. It does not appear to have the concept of Trees or Rows. Anyone had this issue and if so how did you get around it?