Browse By Tags

What would the sql statement be to add 3 business days to the Sales Order Delivery Date? There is probably a shorter version but I got this to work. CASE WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=1 then DATEADD(day,3,SO_SalesOrderHeader…

I have used the @Date@ variable in the file name when generating the output file. It is not working any longer. I've recently updated to Office 2019 and thought that it may be the issue. Has anyone experienced the same?

Hi All, I recently upgrade Sage 300 to Version 2018. However, the Business which works before the upgrade is now a giving this error. Any ideas on how to resolve. Let me know.

Hi There, Client is recieving an error when running sage intelligence reporting, an unexpected error occured, the pastel auto connection system failed to create a link to your data, the error returned was: An erro occured in the pervasive.SQL layer the…

Good day One of my clients have an issue when they load into their company profile and head over to intelligence reporting that it gives them a no reports and when you try to launch a report it gives a unknown error. What could be the cause if this…

I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…

I need BI Tools menu in Excel to export reports. It keeps disappearing from the tabs at the top. If it goes away, I have to reboot my whole computer to get it going again. Any help would be much appreciated. There are no warnings or dialogs that pop up…

We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…

Get better visibility into your business! As a small business owner, getting a handle on your business’ financials doesn’t mean you have to be an accountant. But you do need to know what the numbers mean and where they come from. We want to show you…

Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…

I have a customer that updates up to 2500 invoices in a day. I have created a report that pulls all the necessary header and line detail information to produce several pivot reports. Is there a way to now use this report (so it does not have to be…

I have a client experiencing some errors I have never seen... They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like... Here is…

I'm working with the Intelligence add-in in Sage 100 2015. Excel 2013. Working from one computer designing the financial template. However, when I switch over to the computer that will be the final user and run the template, I get some weird effects…

HI There, When I was at Sage Summit I was told that I could find a list of Table Connectors on Sage City, does anyone know where to find this report? I'm trying to find what connectors match up so that I can run an A/P report with some general ledger…

Users of the Report Viewer are not seeing the new report repository that was changed in Report Manager. SI full bundle with Sage 100c Advance v 2016. tia

Sage Intelligence is a Microsoft® Excel® based reporting tool that connects to your Sage 50 company data and pulls it into a familiar Excel format that is easy to understand and manipulate, putting you in control of the design of your reports. Intelligence…

Get an out of memory error running a Sage Intelligence report off AR History detail created in the Connector. This would generate a Pivot Table. I have it filtered to limit to a date range, for example one month. While the detail would be 251,000 rows…

Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…

I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?

I am having an issue with Report Designer where I have set up a Revised Budget under Budget set 2 but the revised budget is not being pulled into the Designer report. I can see the revised budget in the Budget Maintenance screen. I have reviewed the…

Hello. I am writing a BS report based on prior one column(current BS) template. I add 3 columns to insert last year balance, Variance and % of Variance. after i am done, i audit the template by using PR View. Audit did not inform any error, However the…

Download the Sage 300 ERP 2014 Intelligence Reporting Kick off document. http://www.alchemex.org/FTPBICommunity/Kick_off_with_Sage_300_ERP_Intelligence_Reporting.pdf