Browse By Tags

  • Creating a Parameter and Filter to Only return last 5 years out of 20 years of data in the report - This is a Consolidation Financial Report and has a Standard Report named Fiscal Year

    I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…
  • Sage 50 printer

    I installed sage 50 2022 on Mac using parallels, it crashes so often but the real issue i have is i can't send invoices using email or I can't print any report via PDF printer. Anyone have any luck inn installing correct .net Famework?
  • Custom Report removed in Report Manager still showing up as optional Report Setting

    I've been tweaking our AR Aged Invoice Report in Crystal Reports and have ended up with a few versions that I now need to delete. They are showing up as options in the Report Setting List. I've deleted them in the Reports Manager, but that had no affect…
  • Parameter in Report Manager Duplicating some data

    Good Day, I have created a new report in Sage Intelligence. Client is Running Sage 300 2018. I am trying to exclude data before a certain date but the date only gets set on the run of report. I have tried to add in a filter and a parameter…
  • What connectors (Data Tables) are used in Report Manager?

    How do I tell what connector (data tables) are used on a given report?
  • Adding parameters to auto distributed reports

    i have a report that is emailed regularly via windows task manager. I need to add a parameter to the report to pull in just the prior period data on one of the tables. my question is can the report run automatically given parameters require user interaction…
  • 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
  • Aggregate Data in Report Manager

    I have a report connected to the IM_ItemWarehouse table and need report manager to aggregate warehouse values. I have filtered down to two warehouses but I need to report items of these two warehouses in aggregate. Its creates duplicate rows in my pivot…
  • PO No. & Unit Price not a field for intelligence reporting, can I add this field somehow?

    FormerMember
    FormerMember
    I've been using the Purchase Analysis intelligence report, however I want to add the "Purchase Order No." (not JobID) in the report. Sage has to be storing it somewhere, because we fill it out on every PO we input, same with "Unit Price". It is not…
  • "Sage 300 erp intelligence reporting cannot create report. Microsoft Excel is not currently installed. Install MS Excel."

    hello, i have just installed Sage 300 ERP on a Windows 10 machine with Office 2019. When i run Report Manager i get the following error: "Sage 300 erp intelligence reporting cannot create report. Microsoft Excel is not currently installed. Install…
  • Unable to auto send XLS output using Report Manager and Gmail G-suite mail client

    Unable to auto send XLS or XLSX output using Report Manager and Gmail G-suite mail client. I AM able to successfully schedule and send PDF reports. XLS and XLSX reports are generated and placed into output directory but no evidence of email having been…
  • Sage100 - Copy Custom AP Check Form to all company codes.

    I was trying to use Report Manager to copy the form from the company code that I created it in to all companies. It shows in the Report Manager and after I create the form code in the other company it is using the standard form. I have 250 companies that…
  • Sage Intelligence Reporting: Financial Periods/Date

    Hi all, Good day. My company's financial calendar starts from 1 Jul and end on 30 Jun. We have set his up in the FISCAL CALENDAR under COMMON SERVICES. We are creating a report that would use GL data, as well as Sales History from OE. At the…