Browse By Tags

Hi all, I know this is a very specific question but I am using Sage 300 Intelligence and I have consolidated 3 entities into one report (all 3 listed under Database Consolidation List). Within this report I have built financial statements for all 3…

Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?

We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…

I have a client using Sage 100 in a cloud platform (SWK). When I login under the client's name into SAGE (but my name on the network), I can see a report in Report Viewer. When the client logs in under their name in the network and into Sage, they do…

We have a client that has several hundred companies in Sage 100. They have a report template that they would like to run individually on each of these companies. The customer owns the Connector module. Using the standard Autoconnect connection in…

As per my understanding Sage 300 budget linked to Account code (on GL). How can I handle objective based budget? Objectives are like optional fields: Eg: Acccount 1010 : Allowances Objective 1: budget $100k Objective 2: budget $200k

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…

I need to run Project detail reports that include the additional information fields (date and description - not the 5 additional fields located in the ledger) available in the purchase ledger - is this possible? If not, how would I run a project detail…

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.

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…

I have several custom reports created that pull in employee SSN. After installing 2020, the values returned for employee SSN are scrambled. I am assuming this data is now encrypted... but not sure. Tech support is no help. None of the agents even have…

Hello, Is it possible for Sage 50CA IR to integrate some of the Sage 50 US IR into the Canadian system. Should be an easy process. Can we put this on a wish list for the next update? We have done some research, and Sage 50 US Intelligence Reporting…

Bonjour, Nous avons installé Intelligence Report, mais je ne vois pas à quel endroit y accéder. Merci de votre aide !

Hi All, Our company has Sage 100 2015 and we are just now starting to use Sage Intelligence. I am pretty used to report writers so learning to write reports in SI is fairly easy. However, my difficulties have to do with the set up of Power BI…

Hello, I have created a custom report to show aged vendor payables by project. Everything is working well, except that it is pulling all of the vendor invoices, not just the unpaid ones. I am not completely familiar with the database table and field…

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

I have successfully added the territory field to my sales report is Sage Intelligence, but I cannot get the field to total correctly. If I put the field before the customer number it total, but only for each customer. If I place the field to the left…

Does any know if we can link (or reference) GL accounts from one worksheet to another in SMI report? The purpose is to is to simplify update of accounts Say sheet1 we have a good report. In sheet2 column A, we want to link to accounts in sheet1. If…