Browse By Tags

Hi, I have Sage 50 US Quantum 2020 edition. How can I make a copy of a standard Intelligence Reporting, Jobs Profitability Report, into the Report Manager so I can modify it. I need to modify it a little and regularly email to someone in the company…

Hello to our Sage 50 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…

ERROR MESSAGE: Wrote a report for a client who was on Sage 50 US v 2020. They have now upgraded to v 2021 and also purchased a new server. The client asked us to make updates to the report which we did. During delivery, selected "create a new container…

Is there a way to link the year in the parameters sheet to the year selected when the report is initially generated? Thanks.

I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.

Is the customer contact stored in the sales order? You have to choose a contact in order to select a shipping address, but I don't see a way to get to the contact name in a report.

We sell a lot of products that have a lot of common assemblies so to capture WIP we have all our products made up of multiple levels deep assemblies. Now we have been inundated with orders and I was hoping for a easy way to show if we had enough raw materials…

I am consolidating 3 companies company 1 current year is 2019 company 2 current year is 2019 company 3 current year is 2020 (does have different fiscal year end - am not consolidating on a single worksheet) When I run the statements i only see…

On several of our Report Designer reports we are now getting #VALUE! or Object reference not set to an instance of an object errors when just the other day they were fine. I believe it is an Excel issue this time since I ran and saved the same reports…

My client runs Sage 300 Advanced version 2018. They are on ALF Model. The ALF Licenses came together with Connector 6.4A and Designer 6.4A activations and I have already activated them. For the client to start using the module what do I need to procure…

Hi guys Does any one has a Manufacturing report in Sage 200 Evolution which summerizes the consumption of raw materials used product used in producing a finished good For Example A company produces 1000 pcs of Tomatoe Pastes in different batches…

When running the sales master report (Even on the latest version after contacting support) 1. If I issue and invoice a client, I can see the sales figure correctly as well as the quantity. But when I invoice first or vice versa, when I run the intelligence…

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…

Hi all Lets start with. I do not know much of Sage but a client of mine is using Pastel Evo All was working fine until about a week ago when BIC stopped working. Trying to find a problem we found this log Add-in Manager Initialised 2019/11/13…

I'd like to create a customer list that shows the names of files that have been attached to each customer. But I can't figure out how to join the customer table and attachment table. I created a simple report listing all fields and records in the attachment…

ProductsSage 50US V2020 Description Performance issues when running customized reports on Sage 50US V2020 Cause Customized reports may experience performance degradation as a result of the latest update to the Sage 50US V2020 database driver. Resolution…

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…

New to Sage Intelligence? Or want to take your reporting to the next level? We have the right Sage Intelligence Reporting course for you. Sage Intelligence: Beginner Sage Intelligence: Intermediate Sage Intelligence…

Sage Business Intelligence in Sage 300 on one workstation does not show any info on the report when run. It goes thru the normal process of gathering the data and building the spreadsheet but doesn't show any data, Just #VALUES. If the client opens…

I'm getting an error when trying to do a drill down: "The drill-down report Report Designer Add-In-GL Transactions 1-0 required to perform the drill-down doesn't exist" I'm using Sage 50 US 2019. We called sage and after speaking with several…

I want to limit the output to only one specific currency type.

Whenever I try to open the Intelligence Reporting on Sage50, I get an error that says: "To use Sage 50 Intelligence Reporting, you must have Microsoft Excel 2003 or higher installed on your computer." I definitely have Excel way beyond 2003 (and…

Hello, I recently upgraded the Intelligence Reporting software on one of our network client machines from version 2.0 to 2.2. I was told by Sage support that I would be able to upgrade by clicking the prompt to install the latest version when trying to…