Browse By Tags

  • Integration between Sage 50 Canadian Edition and Wix

    I am setting up my website with Wix and am wanting to integrate my Sage 50 to it, for speed and efficiency. Is this available? (I know it is for Quickbooks, but I am happy with Sage and do not want to jump ship) If not, is it in the pipeline? James…
  • Can CRM synchronize Calendar without Microsoft Exchange?

    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…
  • 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…
  • 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…
  • 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…
  • Is Sage Intelligence 2015 and Microsoft 365 compatible?

    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…
  • 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
  • ODBC Error using MS Power Query (Office 365)

    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…
  • What users rights are required to modify a Sage integration with Access?

    Does Sage 300 have an active integration with Microsoft Access, or is it a manual process? Which users rights are necessary to modify the integration, and change what is sent from Sage 300 to MS Access?
  • Microsoft 365 verse Autoentry

    I am trying to decide whether to sign up for the AutoEntry application or Microsoft 365. What is the best system for remote entry for receipts etc.
  • So where do we download the Sage 50 CA SDK now?

    So now that Sage has overhauled their website, I can no longer find a way to download the SDK. I used to be able to find it on the public facing site, but now they've made sure to make no mention of it. All the old links suggesting how to download the…
  • Sage X3 PU11 - SOAP Call in C# Language - Is there a common library DLL which we. can attached as a reference.

    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
  • TotalTaxAmount SetTaxAmountByRow not working

    Hi, I am trying to update invoice's total tax using below code TaxSummaryInfo taxSummaryInfo = journal.GetTotalTaxAmountInfo(); if (taxSummaryInfo.GetCount() > 0) { double totalTax = 10; taxSummaryInfo.SetTaxAmountByRow(1, totalTax); taxSummaryInfo…
  • Invalid or missing posting date encountered on Bill of Materials transaction update

    Hi, I've been working on automatic registration of transactions for Bill of materials. but I've been encoutering this issue for a couple of days now. its been throwing me an error that says "Invalid or missing posting date encountered" I opted…
  • Interface with Microsoft Dynamics GP

    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
  • BM Production register Error "The register must be printed prior to posting"

    Hi, I've been wondering if someone else encountered or might have a solution for this. Im getting the error "The register must be printed prior to posting" oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister…
  • BM ProductionRegister - New object error:200

    Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…
  • Woocommerce and SAGE 50 Canadian version 2019.3 integration

    Hello Guys, Anybody know here how to integrate SAGE 50 with WooCommerce Wordpress plugin? Is there any good solution available in the market? We are using SAGE 50 Canadian version 2019.3 Thank you. Rahul
  • SSIS (SQL Server Integration Services) Connector to Sage Business Object Interface (API)

    Does anyone have any suggestions on the best way to use Microsoft SSIS (SQL Server Integration Services) to connect to SAGE 100 Business Objects API? We came across this product, but were curious to know what recommendations the community had. https:…
  • SalesJournal SetShipDate The field you are trying to change or function you are calling is not accessible under current circumstance.

    Hello Friends, I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…
  • There was a problem opening company.: (inner exception: FileNotFound)

    var companyId = GetCompany(); try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId); This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
  • SAGE X3 - Outlook Plugin (Can't connect)

    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…
  • Sage 50 CA Integration using MySQL ODBC issue with Ports

    Hello, We are working to integrate data from Sage 50 CA 2017 (General Ledger transactions mainly) to a Microsoft SQL Server table as a staging place to then bring into another application. We are able to this successfully by creating a MySQL ODBC (5…
  • SDK seeking permissions every time

    Hi, We are trying to build up an application using the Sage SDK to create invoices in the Sage 50. In our testing , we found that the Sage SDK is prompting for the user to give permission every time (even if it is same company file that we gave permissions…
  • Excel crashes printing A/R invoices through VBA - MSVCR120.dll

    I have some macro code that is printing A/R Invoices to PDF files. The code works fine on my laptop, but on the client workstation, it crashes. Event Viewer identifies MSVCR120.DLL as the problem. The OS and Excel versions are identical on the workstation…