• Web API Bug in POReceipts with Additional Costs

    While the new ability to add a PO Receipt referencing an existing PO is a long awaited for feature of the Web API, the 2023 release has a bug that makes it impossible for us to use this feature. PO Receipts with additional costs incorrectly assigns…
  • WEB API - ARReceiptAndAdjustmentBatch

    Hi there, I'm tryin to create a receipt for an invoice through this API. Testing in the Swagger interface - ARReceiptAndAdjustmentBatch Entity I'm posting: { "ReceiptsAdjustments": [ { "BatchType": "CA", "CustomerNumber": "1001CRJ22031…
  • how to set and retrieve the bank account of a vendor?

    In sage 300 I can define the bank code: A/P -> A/P vendors --> Processing tab -->Bank Code However I couldn't find a way to set nor retrieve the bank account. Is there a way to do so in the application / via the RESTful API?
  • Sage 300 v2023 external web screen error Undefined after entering login

    After upgrading to Sage 300 from v2022.4 to v2023.1, we get an Undefined error after entering the login screen from external web screen. his issue is only with external access outside the network. Internal web screens are fine. I have reviewed KB 77607…
  • Sage 300 Web API - Sage 300 2020

    Getting below error when calling API for AR module. The 2 config files are enabled ( https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/110205/unable-to-make-a-get-call-using-sage-300-web-api ) and in Sage 300 USER…
  • Unable to post IC Transfers Transit Receipt via webAPi

    Good Day, I'm using sage 300 (2023). I'm trying to use IC Transfers via webAPi I have two operations succeeded 1- Direct Transfer 2 - Transit Transfer Yet when I try " Transit Receipt " i receive the following error "You cannot import transit…
  • How to only allow API Request from SSL certified site?

    Hi all, I am exploring the Sage 300 Web API. I am making a POST request from an e-commerce site, to insert AR invoice batches. I notice that the site with 'Connection not secure' can make a request to Sage 300 API as well. How can we restrict these…
  • Sage 300 Web API - ICDayEndProcessing

    Hi All, I am developing a website that will use Sage 300 Web API to integrate with Sage 300 data. Currently, I would like to run the IC day end processing in my development, but I am confuse on the payload. Does someone have a sample or tutorial…
  • SAGE 300 Web API | EFT Customer

    Hello, I have a customer that has the SAGE 300 Web API setup. One of the requirements from the customer is to get data from a web form and update the AR Customer and also update the EFT Customer. I wanted to do everything via Web API but apparently…
  • Sage 300 Web Api - Ready To Post

    I'm working on the Sage 300 Web API to pass Customer Receipt to Sage 300 version 2021. In the Github documentation, it mentioned that we could set the Batch Status as Ready To Post on the POST request. A separate PATCH request is not required as the…
  • How to filter OptionalFields collection via Sage 300 WebAPI

    Hello, I was trying to perform some oData filter on the ReceiptOptionalField2s collection but the return from Web APi is: statusCode: 400 { "error": { "code": "InvalidParameters", "message": { "lang": "en-US", "value": "The request parameters are…
  • web API

    hello everyone how can I access the functional balance of an account in sage web API
  • Sage webAPI integration

    how can I use the admin account to access sage web API I'm getting this error "value": "Insufficient security rights for user." I'm using the Admin account, I used the uppercase letter
  • Sagekit a Ruby client library for Sage300 API

    Six months ago I have decided to build a Ruby client library to interact with the Sage300 API. I never imagine this gem will reached 5000 downloads. I'm reaching out to finally share this gem with the community. It is released under the MIT license and…
  • Sage 300 Web API Create OE Invoice

    Hello Everyone, We are experimenting with the Web API in Sage and I noticed that for OE Invoices it only allows GET operations. Is there a road map for the development of the Web API from Sage or are there any plans to implement POST operations for…
  • Sage 300 Web API Intermittent POST Success with OE Orders - Avalara?

    We're intermittently getting a crash while sending a POST command through the Web API (Sage 300 2020 PU7) when trying to create new OE Orders. Based on the Event Viewer, our Sage 300 Application Pool crashes and there appears to be a disconnect from…
  • How to give a user security rights to READ from Currency module on SAGE 300 Web API

    Hello, How to give a user security rights to READ from the Currency module on SAGE 300 Web API? Thanks Tiago
  • Error while posting OEOrders

    Hello , OEOrders payload { "CustomerNumber": "A01182", "OrderDescription": "Order Entry", "OrderDate": "2020-01-15", "OrderDetails": [ { "LineType": "Item", "Item": "A1-105/0", "Location": "1", "QuantityOrdered": 8 }, { "LineType": "Miscellaneous…
  • Sage 300 Web API: How to filter item by field in Sage.CA.SBS.ERP.Sage300.AP.WebApi.Models.Invoice?

    Hi All, I want to get only the specific invoice by DocumentNumber in Sage.CA.SBS.ERP.Sage300.AP.WebApi.Models.Invoice, but failed. I try to use the $Filter field => DocumentNumber eq 'IN00000000000000000031' but I just got error
  • Create custom WEB API by using Sage 300 Web SDK

    Hi all, I would like to know if it is possible to create my own WEB API to get/post data with "GET/POST" method. I am trying to do something like this: - create a new table with roto ID using Orchid Extender - create my own API using Sage Web SDK…
  • Sage 300 Web API Bug Report?

    How do we report an issue with the Sage 300 Web API? The POReceipts post will not store the Purchase Order number that is posted on the new Receipt. Yet, the 'PurchaseOrderNumber' is included in the model - but the API doesn't appear to do anything…
  • OE Shipment from Order

    Is there a way to create a Shipment from an existing order using Sage 300 Web API? The API allows us to create both an order, or a shipment using the QuantityShipped field on the OrderDetails object. By using the QuantityShipped value, Sage will create…
  • How to Add a Shipment using the Advantage dll or the Web Api?

    I have been trying to add a shipment to a Sales Order but haven't been able to do so. Did not see any option to such transaction on the Web Api so moved the Advantage dll. Tried to write to the view OE0434 and it does create a shipment, however I…
  • API: OE with Ship all and Post Invoice

    Hi all, I try to add new Order Entry with ship all & auto create invoice using API with the following json {"CustomerNumber":"2347", "OrderDetails":[{"LineNumber":0, "Item":"A11030", "QuantityOrdered":10 , "PriceList":"WHS"}], "ShipmentNumber": "CASH0003…
  • Help - Using the Web API to generate prepaid orders?

    Hello, We have transactions that our customers have paid for using a credit card. We'd like to get those processed transactions brought in to Sage as an order that has a prepayment applied to it, so that the invoice that is automatically generated shows…