Browse By Tags

  • nSetKeyValue returns 100006 and Triggers VBA Error 438 but sLastErrorMsg is Empty

    I'm using the identical code to nSetValue R/W fields that has worked for years, but I am finding that it fails for some tables even though they show a R/W Business Object. I am modifying a non-key field in GL_DetailPosting, but I cannot get past the nSetKeyValue…

  • 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

  • C# BOI example of creating an AR_Invoice with lines/details

    Is there anyone that can help with providing an example of creating an AR Invoice with lines/details in C# using either BOI or the nuget package www.nuget.org/.../

  • Sage100.ObjectManagement Interfaces .net Error when creating line entry

       
               var sessionLogon = new SessionLogon
                {
                    CompanyCode = companyCode,
                    UserLogon = new NetworkCredential { UserName = userName, Password = password },
                    ModuleCode = ModuleNames.AccountsReceivable…

  • Export data excel Addin

    Hello,

    Data is not being loaded when excel download from landing page:

    This screen appears and nothing happens:

    Is there any parameterization that needs to be done? Or an Addin Hotfix?

  • Posting an invoice, line items getting added.

    Our software imports invoices into Sage 50 Canadian edition via the SDK. For a couple customers, it seems line items are getting added in that we are not creating when the invoice is posted. 

    After trolling through the database it seems like these line…

  • 32-bit vs 64-bit for emailing invoices from Sage

    I have installed Sage 50 and Microsoft onto a new computer and I cannot email invoices from Sage using Microsoft Outlook as my default email.  Microsoft was installed as 64-bit.  Should it have been installed as 32-bit in order to email invoices from Sage…

  • Windows 11 not compatible

    I understand Sage 100 Contractor is not compatible with Windows 11.  This may be silly question, but if we are using a VPN to connect to our server to log into Sage from our desktop, as long as the server is not upgraded to Windows 11, does it make a difference…

  • 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 source…

  • Multiple Office Installs - Export to Excel Option Available but Excel Does Not Launch

    I have a client running Sage 500 2019..   Excel 2010 was originally installed on the server.   Export to Excel worked.    However, someone tried installing Excel from Office 365.   They didn't have the correct licensing for Office.    Office 365 was uninstalled…

  • How can I get the sales filtered by KEY?

    I am using the SDK, but I can't find how to filter by KEY use ID and/or KEY and it tells me that it is not possible

    Dim m_salesList = oCompanyContext.Factories.SalesInvoiceFactory.List()

    oFilterFact = FilterExpression.Equal(FilterExpression.Property…

  • Attempting to pull data into Excel from a UDT. Receive "Expression.Error: The key didn't match any rows in the table." in Power Query.

    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…

  • Script for "Daily Sales Reports/update" using BOI

    Hi

    I am looking for a script to update "Daily Sales Report/Updates"  in sales order (sage100 v2021). 

    Could anyone suggest me what script i can use in BOI suing c# or VB?

  • .NET 5, 6 Support

    Hello.  Do we know when it might be possible to interface a .NET 5+ project with Sage 50?  Any idea of ETA or direction would be greatly appreciated.

    It looks like .NET Framework 4.8 was release just over 3 years ago (April 2019).

    If you're reading this and…

  • Microsoft Surface Barcode Scanning

    Has anyone used a Microsoft Surface to scan barcodes within Sage 100?  All I am trying to do is have the cursor in the "order number" field in SO entry and be able to use the surface to scan a barcode on the actual SO paper to avoid having the user type…

  • Looking for a Microsoft Power App expert

    Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…

  • X3 Windows authentication in ASP.net app

    Hi, 

    I'm building a small web app (asp.net mvc) and trying to implement a SSO connection.

    So far, I'm able to connect and run my subprograms by going through a web form where the user has to enter its credentials. (I used this code to perform this…

  • Upgrading Sage 200 - Windows 2008

    We have recently been contacted by our Sage Support, telling us our Sage 200 system needs upgrading.

    We are currently running on Windows 2008, and the support have told us Windows have announced they are turning off the server(?) that our Sage connects…

  • Windows 11 compatible

    Does anyone know if Sage is working on compatibility with Windows 11?  New computers have Windows 11 as their default which is making things difficult.

  • Error: 'Unable to send all emails...Unable to connect to the remote server' when emailing documents

    When emailing a document, you may see the following message:

    'Unable to send all emails
    Error with the address <email address> : Unable to connect to the remote server'.

    This can be due to a recent change by Microsoft to one of their smtp…

  • Error: 'Unable to send all emails...Unable to connect to the remote server' when emailing documents

    When emailing a document, you may see the following message:

    'Unable to send all emails
    Error with the address <email address> : Unable to connect to the remote server'.

    This can be due to a recent change by Microsoft to one of their smtp…

  • Sage 100 2021: Exporting List Boxes To Excel Results In Wrong Cell Formatting Applied

    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…

  • 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…

  • Sage 50 users ask “Should I take the Windows 11 upgrade?”

    As the request to upgrade to Windows 11 keeps appearing on our Microsoft Windows updates list, it concerns me that many people not thinking about the impact to Sage 50 will click the button and take the update. 

    We are following this subject very carefully…

  • Windows 11

    Is Windows 11 fully compatible with Sage 50 - Canadian Edition?

    Will Edge work as a replacemwnt for Internet Explorer?

    Dave