Trying to create a new A/R Customer via the Sage 300 Web API. I'm getting a Status Code 409 "Conflict" with a message of "Check code not defined in bank initialization file."
What property on ARCustomer object do I need to set? There's no CheckCode…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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." } } …
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…