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…
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…
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…
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?
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…
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…
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…
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 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…
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…
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…
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
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…
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…
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…
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…
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
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 …
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…
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…