• 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…
  • Exporting payment via REST API

    Hi All, In my current project I'm writing a code to create a payment batch in Sage300 via REST API. In order to do that I'm doing a GET to a random payment and then clearing the fields to add the new data. Is there a way to get a template of the payload…
  • 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…
  • 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…