Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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
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 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…
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…
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…
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…
Hi all,
I try to add new Order Entry with ship all & auto create invoice using API with the following json
{"CustomerNumber":"2347", "OrderDetails":[{"LineNumber":0, "Item":"A11030", "QuantityOrdered":10 , "PriceList":"WHS"}], "ShipmentNumber": "CASH0003…
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…