Sage 50 US

On of my IT clients has moved their active accounting to a different provider, as the result of a consolidation. They want to know if they have to keep upgrading, and paying the annual fees, in order to use their current version (Sage50 2019) for historical…

We have a person that just started learning Sage 50 US Intelligence Reporting recently. We purchased the connector a month ago but have not installed it because we aren't on the newest software version. We got the email notice that it is being retired…

Excel is giving the error "An unexpected error occurred: External component has thrown an exception" when opening a Sage 50 US Sage Intelligence Financial Designer report. What is causing this and how to fix it?

Hi, Can anyone help to identify where the quotes and orders data is via the odbc please. thanks

Is there are report in Sage 50 intelligence reporting that I can modify. I need to create a report Sales by State. I need for taxes.

I need to add Quantity and Item ID columns to the monthly quote report. How do I do that?

Does a profit and loss report exist in Sage 50? Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage? I would like the report to include income, cost…

Hi there. I have a report which runs well. I can run it from within Report Manager, and I can extract the scheduler command to a batch file and run it. However, when I run it through the task scheduler it does not run. The error in the "BICoreUnattended…

What table can I find information on which period are closed or open?

Hello, I am having trouble with a running a few reports in the Report Manager that I have created data containers for in the Connector Tool. I keep getting a missing resource error like this one: https://imgur.com/a/PlNPghp This occurs right at…

How can I create comparative reports (i.e. Q1 2020 sales against Q1 2019, etc..)?

Is there any report I can run against Item ID that would give me the qty of item sold, along with an invoice number for the transaction? I'm looking for a report similar to the C ost of Goods Sold Journal. We used this report previously but since the…

I updated Sage 50 in June 2020 but the Intelligence Report require a code to activate. Can someone provide that please. Thank you.

Does anyone know how (or if it's possible) to generate a Customer Event Log report. I would like to generate this report on a weekly basis.

Hi: I am new to Intelligence Reporting. I am trying to run any report (like the Dashboard Analysis) on my Peachtree company. It is at the Executing phase. The process window shows one row. The "proc handle" field on that row keeps changing. The "exit…

Deleted old license and added new license for my new laptop. Reports stopped working. The process slows down at "Naming Ranges" for about a minute and then produces reports with error messages: "#VALUE!" and "Report designer license required." I've been…

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.

Does anyone know if a basic Intelligence Reporting WIP report (like the canned system Work in Process report) exists and if it does how do I get a copy?

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…

Looking for some additional Sage 50 US Intelligence Reports? You can find them on the Sage Intelligence Community, and they are Free! [:D] http://www.sageintelligencecommunity.com/page/free-report-templates-sage-50-u-s-edition-intelligence-reportin…

I created a Sage 50 Intelligence report and need to create a SUM expression that uses the GROUP BY or PARTITION to be able to create a SUM based on the data in another column. I also want the sum to be included on every row of the data. Does anyone have…

I created 2 pass through variables to accept date parameters in a SQL connector. I set the date variable types as DBDate. I receive an error message that the automated data type is not recognized by Visual Basic. I also tried setting it as variable type…

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…

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…

Hello, I am trying my hand at the SQL Query Container type in the Connector Module. I repeatedly get the error "The specified display field(s) [Jrnlhdr.TransactionDate, Jrnlhdr.JournalEx] do not exist in the data container." when I try running a…