What are some reasons a Sage 300 macro would suddenly quit working in Windows 10? We have five Windows 10 clients, and the macro has quit working on four of the five clients. Sage 300 itself still works fine. We don't know when it broke given, we only…
Getting this error when trying to export our vendors object to Excel 2007: Description: Provider cannot be found. It may not be properly installed. I have Access Runtime 2019 (x86) installed along with Office 2019 (x86). Access Runtime provides Access…
Hi all,
My client have Microsoft Account for their emails and Calendar. But do not have Microsoft Exchange.
can the calendar synchronization works without Microsoft Exchange?
1) Can the sync work with standard IMAP/SMTP servers?
2) Can the sync…
I've just upgraded Sage 50 to the 2023 version. Now when I try to Export to Excel, I get the message "An unexpected error occurred while copying your report to Microsoft Excel". I have previously used this feature daily. I have restarted my computer several…
Attempting to pull data into Excel from a UDT.
Raw data will pull, but,
when I try to edit Query, receive "Expression.Error: The key didn't match any rows in the table." in Power Query.
See screen shot :
Any Thoughts?
I have used "syzcon" running…
On a 2021.0 and 2021.2 system, exporting to Excel from a list box results in the cell formatting applied being off by one column whereas on a 2020.1 system, the cells have the correct formatting applied. On the 2021 systems, this was observed when exporting…
I'm running Sage 100 Premium 2020 version 6.2, and have Sage 100 Premium Intelligence 2015 installed. Our IT department installed office 365 yesterday, and now I'm getting an error message in excel about the BI extension. No values in cells in my intelligence…
ODBC Driver error in Power Query "Unexpected error: Attempted to read or write protected memory..."
We are using the Sage 50 v25 32b ODBC driver. The underlying query is "select * from ACCOUNT_STATUS" or specifically when querying date time (tz sensitive…
Can some one please help me where can i get excel add-in for MacBook. If the answer is CSV , than let me elaborate there are few additionally added field those data are not getting captured properly in CSV Format. DO we have any work around for this or…
Hello Teams,
We are creating an Interface to Sage X3 PU11 and would like to know if Sage or any other provider has created a common DLL library for the C# programming language. Will be used to call SOAP or REST in Sage X3.
Thank you,
Dennis
I try to connect MS Excel to Sage file via ODBC. I got following message:
Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)"
I am using Windows 10 64-bit. MS…
We tested this feature a couple of weeks ago (financial reports) and it worked fine, we could run all financial reports. Now, after we went live, it stops working with the "Error in running connectcomaddin" in macro.
I got it to work 2 days ago and…
Hi everybody,
I am wondering if there is anybody out there that is using Sage X3 in conjunction with Microsoft Dynamics GP (exporting data on a regular basis from X3 to GP)?
Thanks,
Dominik
We are running an old version of MAS200, version 4.40. I had to upgrade my laptop due to it's untimely death. I am currently on Windows 10, Office 2019 (32-bit). For some reason, the Export to Excel button that was available on my old laptop is "grayed…
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…
Hi,
Normally I'm able to configure the Sage X3 Outlook without any problems, but in one specific client I'm getting an error while testing the connection.
After I insert all the configuration, I'm getting the error "Connection forcibly closed by…
These Microsoft® Excel® tips and tricks are the best of the best. They’re the top performing tips of 2017, and have raked up the highest number of views. In fact, with a combined viewership of over 220 000, these tips deserve their own television channel…
A good Business Intelligence solution will give your company a competitive advantage, and there are many compelling reasons why all business owners should make it a priority to invest in one. Here are the top three:
Reason 1: Automate reporting processes…
Microsoft Excel is the universal language of business and accountants, and most decision makers in small to mid-sized businesses use the king of spreadsheets in some way for reporting. In fact, research analyst Gartner has conceded that “Excel is still…
Running Sage 2017 SP1, with Excel Container
I have created an excel link for a large report that I'm going to pull several small reports from for distribution.
This runs perfectly if the linked excel report is open but not if it's closed.
I will…
Hi,
MS released an update this past weekend and it seems to have affected connections to excel. I was wondering if anybody else has experienced this. Before the MS updates our macros were programmed to connect to Excel with Microsoft.ACE.OLEDB.12.0…
Hey,
I am hoping you guys are able to give me some information. I have a new client that would like to use a remote server for their Sage Accounting to allow Multiple Users access to the same Sage Database at the same time. I was thinking for scalability…
I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax:
Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True)
But I do not know how to capture the data you are going to select in a DataTable. I´m Working…
I've got this question posted on a Microsoft forum, but so far I am not having any luck with getting a clear response.
With the impending Windows 10 upgrade that Microsoft is strongly "encouraging," I have been trying to find out if Windows 10 will…
Hi,
I would like to get all entered invoice into sage 50 accounting.
Filter: All / Date range
Does anyone have any Idea how to do this?. I'm using Microsoft .Net Framework.
Thanks
Sandeep
