• 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…
  • 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…
  • 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…
  • 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…
  • Sage 300 Web API case insensitive search

    Hello, I need to do a customer search using the Sage 300 Web API, but it needs to be case insensitive as some customer names are proper and some are in all caps. According to the OData documentation I should be able to use the tolower function, but…
  • How to associate a Receipt to a PO using the sage web api?

    I am trying to create a receipt and associate it to a Purchase Order using the web api. In the payload of the Receipt I have added the Purchase Order Number and it's sequence key. So in the receipt lines. On the sage side I see the receipt being created…
  • Web API - Can I retreive AR Transaction reversals?

    Using only the Sage 300 APIs which API call can I use to retrieve 'reversed' transactions? (Bank Reversals) In Sage I can see the reversals with a transaction type of 'Returned' on the AR Customer Inquery page but when I try retrieving the transactions…