Browse By Tags

  • 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…
  • How to expose additional data through Web API?

    Hi all, I am developing an integration with Sage 300 and am fetching data through the Web API. The problem is I need to access Item stock counts for different Locations, and as far as I can tell this information is not returned anywhere via the Web…
  • 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
  • Sage 300 web screen "An unexpected error has occurred. Please try again or contact your administrator for assistance." When opening any Purchase Orders Screen

    Problem: Error when opening PO screens Web screen Cause: Inadequate User Rights Resolution: In the Administrative services-Security Groups ensure that the Sage 300 Web API is selected and that these rights are allocated to the USERID for the…
  • 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
  • Sage X3 Sales Order Web Api

    Hi My development team have recommended that I get them to write a new APi for when I would like to Modify existing sales orders rather than use the existing sales orders. I am clearly not technical, but can someone tell me can you read, write …
  • 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 An unexpected error has occurred. Please try again or contact your administrator for assistance when opening certain functions of Sage 300 web screens

    Problem: Users may have the error when trying to access certain functions within web screens or on certain modules. An unexpected error has occurred. Please try again or contact your administrator for assistance. Cause: Inadequate user right on…
  • 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…