• 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 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • Installing / Setting Up SAGE 300 Web API

    I am new in SAGE 300. My client just upgraded to SAGE 300 2019 version. I want to deploy Web API so I can link it to our E-Procurement system that is PHP based. In summary, the E-Procurement creates Purchase Orders and captures supplier invoices. I want…
  • Sage 300 web api not uploading data

    FormerMember
    FormerMember
    I can do GET operations, but attempts to do POST appear to have the data ( curl -d element) stripped or munged by the time they get to the Sage engine. If I do ARInvoiceBatches, for instance, it will create an empty Batch with no batch data and no attached…
  • Sage 300: How to Create a Class in Visual Studio from JSON

    Introduction Some developers may already know how to create a class from JSON metadata. But, for those who do not, this little tip is very handy. I’ll use the Sage 300 Web API and create classes based upon the ARCustomers endpoint. Of course, this…
  • Error when trying to post a multiple PO Receipt using sage web API

    Hello Guys, I'm having an issue when trying to post a multiple Purchase Orders receipt, the error I'm getting is: { "error": { "code": "RecordDuplicate", "message": { "lang": "en-US", "value": "This is not a multiple purchase order receipt." } } …
  • Unable to make a GET call using Sage 300 Web API

    Recently I've installed the Sage 300 Web Screens in order to try the Sage 300 Web API, the wed interface (Web Screens) is working fine, I'm able to enter orders, look up for customers, items etc. But, when I try to make a call using the Swagger UI, the…