• Where to find Journal Entry Balances

    Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…
  • After upgrade from 2021 to 2023 I got Error HRESULT E_FAIL has been returned from a call to a COM component.

    After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen. What would be the reason of this and solution ?
  • The underlying connection was closed: A connection that was expected to be kept alive was closed by the server

    We are using API while pushing data from a 3rd party software to Sage 300. Entry per batch consist of maximum of 3000 per entry but not all batches has this qty. Before all posting went well until this month we notice that some entries are not being…
  • Sage 300 API Question [On Premise]

    Hello, We are using Sage 300 (version 2020) on premise with a perpetual concurrent user license using the desktop screens exclusively. We have a 3rd party CRM solution that we would like to integrate with Sage. I am by no means familiar with SAGE development…
  • Calling .net API FilterFetch on Customer View gives Attempted to read or write protected memory error

    FilterFetch on a client machine is throwing the following error on customers. Works on my local machine Unhandled Exception: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory…
  • Integrate Sage 300 (non-cloud) with a PHP website

    Hello, We have a Sage 300 On Premise (non-cloud) version. We are looking to integrate it with our e-commerce website (PHP). We want to do two-way integration. 1) : From Sage 300 to website Customer invoice, order history, tracking information from…
  • Issue sending AP/AR Adjustments using SAGE300WebAPI calls ARReceiptAndAdjustmentBatches/APPaymentAndAdjustmentBatches

    I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
  • Sage 300 integration with a custom ERP

    We are looking for someone to connect our Web API with Sage 300. These are the functionalities we need -Push Invoice -Verify if customer exists -If customer doesn't exist, create new customer in Sage We are currently building the Web API, therefor it…
  • Sage 300 Web API 2019

    Currently Running Sage 300 Web API v1.0 | 6.4.0.20 I'm currently working on a integration project where I will be will utilizing the Sage 300 Web API. This integration will be focusing on Order Entry where we can insert a new order (POST) and eventually…
  • Sage 300 2016 API

    Hi All I didn't work with Sage products yet one of our clients want to make automatically integration between our PHP web system with Sage 300 2016 version they are doing integration manually, they are inserting data twice i'm searching for…
  • Programming Sage 300

    I need to start programming in sage 300. Typically programs that import etc. What software do I need and where can I get a good tutorial on this? I have no starting point.
  • Online Portal and/or Ecommerce Integration with Sage 300

    Hi, Does anyone have any recommendations for Online Portal and/or Ecommerce Integration with Sage 300? Requirements: 1. It must integrate with Sage 300. 2. Integrate with Ariba and Ariett 3. Be able to take Credit Card Payments 4. Be able…
  • SAGE 300 61A SDK HRESULT E_FAIL Error

    Hi Guys, I have an issue when attempting to retrieve or insert data into SAGE databases using the SDK 61A. I am able to establish connection with the SAGE database and open the Views. However, I am getting a HRESULT E_FAIL error when I try to retrieve…