• User unable to promote company to Sage 300 Customer/Vendor

    Hi all, I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet. My user setting: …
  • Error while installing Workstation Setup

    Hi all, My customer is having error while installing the Workstation setup on Sage 300. Checking the log file, a lot of things cannot be found. how do I fix this? The following properties have been set: Property: [AdminUser] = true {boolean…
  • Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…
  • Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…
  • 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…
  • 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 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
  • Is it possible to Restrict certain Customers created within Sage 300 with specific group code from getting inserted or synced to CRM?

    Hello, Is there any method/setting, that can ‘Restrict’ certain Customers (with specific Group code) that are created within Sage 300 from getting into CRM as company record? I know that if we tick the suspend A/R integration to CRM checkbox from…
  • 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…
  • Unable to do multi select in all list box after installing sage 300 2019 CRM Integration Setup

    Dear All, I am unable to do multi select option in all the list box fields in sage crm, this is happened only after installting the sage 300 2019 integration setup. Sage CRM ver 2018 R3. Please refer to the bleow url which is from sage CRM Community…
  • 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…
  • Unable to post an OEOrder, get vague error back

    Hello, I have been working with the Sage staff and currently still do not have a resolution to this issue. Effectively I am making a request through the API to enter an order for a purchased item from the website. Initially I was getting errors I…
  • 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…