• Integration of Office 365 workflow to AP and AR for approvals

    Hello, I have a request from a client asking whether its is possible to Integrate Office 365 workflow to Sage 300 AP and AR for approvals and also attaching manual documents. Any help please
  • Reasons a macro would suddenly quit working on some Windows 10 devices and not others.

    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…
  • KB5033910 Cumulative Update for .NET Framework 4.8 for Windows 10, version 1607 and Windows Server 2016

    Had a client install this update on a Terminal Server running 2016 and it killed Financial Reporter. Excel crashes every time you try and run FR. Office repair didn't work. Seems the only thing working is to uninstall the windows update, but the client…
  • Provider cannot be found. It may not be properly installed

    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…
  • New to Sage. How to import files from OneDrive

    We are running Sage 300 2020. Our finance team has been working with Excel files on a network share and then importing to Sage 300 GL transactions. We are in the process of decommissioning an old file server and moving their files to SharePoint Document…
  • Office Repair due to email integration repeatedly breaking

    We are having to do a Microsoft Office repair 2-3 times a month for our Sage 300 clients that use Outlook email integration (not SMTP) to send invoices. The problem appears to happen after automatic Office updates according to our IT department. Clients…
  • Sage 300 Office 365 Support

    Hi everyone, Does Sage 300 latest version - 2022 . supports Office 365? Does FR already works with 365 64 bits? Any comments working Sage 300 with Office 365? What version of 365 it is compatible? Thank you
  • Sage 300 Premium (Version 2022) Software Integration Documentation

    This is my first time working with Sage software. I have a Python web application running on the same Microsoft Server as Sage 300 Premium (Version 2022). When a payment is completed through the web application I need to associate the payment, payment…
  • Sage 300 2022 G/L Statement Designer using 64-bit Excel Add-in 'FR View' does not open

    Upgraded to Sage 300 v2022 and having problems with the G/L Statement Designer with 64-bit Excel. Workstations with 32-bit Excel 2016 work fine (after running Sage 300 in administrator mode), but others that have 64-bit Excel 2019 do not. All are running…
  • WARNING on 64-bit Excel with version 2022

    We recently upgraded a client using AP and GL only to version 2022. Everything was fine. Then they added a new Windows 10 workstation with 64-bit Excel. (All previously existing workstations are running 32-bit Office.) They ran an FR Balance Sheet on…
  • The program UP0023 has been deleted or damaged .net API Order Insert

    var view = OpenView("OE0520"); view.Cancel(); view.Init(); view.Fields.FieldByName("ORDNUMBER").SetValue(order.OrderNumber, false); view.Fields.FieldByName("CUSTOMER").SetValue(order.CustomerID, true); This code is returning the error, "The…
  • How to figure out errors ViewExceptions .NET API

    I'm trying to insert an order using the API - and I'm getting back an error that just says 6666 How can I find what this means, and in general, is there a way to get the COM exceptions and error codes? I know how to get session.Errors, but that is empty…
  • Sage .NET API Errors

    In the Session.Init method, I'm getting an error that just shows 1.4197.5 I have no idea what this means and don't see documentation anywhere that explains it. Can anyone help on what this means?
  • Does ACCPAC.Advantage depend on Windows.Forms?

    Trying to use the .NET ACCPAC.Advantage library in a console app and it's saying I need a ref to windows.forms DLL? Is this normal? Do I really need win forms?
  • SAGE 300 PROJECTS AND JOB COSTING INTERGRATION WITH MICROSOFT PROJECTS

    Where can I find a document or a user guide on how to integrate Sage 300 2020 PJC and Microsoft Projects 2016. Please advice
  • Sage 300 2021 Default Install

    Is there any documentation that shows what software gets installed when you install Sage 300 2021 from scratch? For example, if I took a clean Windows 10 client machine without any third-party software installed (just the OS), and immediately installed…
  • 'Access Database Engine' no longer needed? ACE now directly available via Office 365 and Office 2016/2019 (Click-to-run versions?

    AccPac/Sage300 have long been able to import/export using Office file formats. However, despite Office being installed on the same computer as Sage300, Sage300 (nor any other apps) could take advantage of the Access Database Engine (ACE) to support those…
  • Office 64-bit Integration & Support?

    What's the latest word on Sage 300 and Office integration? Today we are running Sage 300 2018 and we are currently limited to Office 2019 32-bit. We are upgrading to Sage 300 2021 this spring but it doesn't appear that Sage 300 2021 supports 64-bit Office…
  • How does Sage Intelligence decide which Excel to use?

    Hi everyone, I have two Excel versions installed on my computer (Excel 2010 and Excel 365) because I need both for work. When I only had Excel 2010, SI works fine. And then I had Excel 365 installed, SI switched to using Excel 365. This morning, SI…
  • VBA emails and Outlook 365

    Is it possible to use Outlook 365 in a VBA macro to send emails? Does anybody have any sample code? Thank you.
  • FR stops working: error in running connectcomaddin in macro, Sage 300 2020 pU2, Office 2016

    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…
  • Sage 300 - add 64-bit office compatibility

    Please add compatibility for office 64-bit. Please and Thank you!
  • Sage 300 & the Microsoft Office Access database engine

    I recently was given the responsibility of supporting the Finance department desktops and Sage 300 ERP server. All Finance desktops have "Microsoft Office Access database engine 2007" installed on them, but i have no idea why it is there or what processes…
  • Windows Server 2019 automatically close connection for HTTPS after 30 days?

    We built a custom app to access Sage service. We installed a SSL certificate so that our external app can access Sage securely. We encountered some weird issues relating to HTTPS / SSL certificate. 1) First we installed a self-signed SSL certificate…
  • Sage ERP Accpac 6.0A

    It there a problem or a compatibility issue to use Microsoft O365 Exchange Online with Sage ERP Accpac 6.0A ?