Browse By Tags

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…

Hi, We've tested to call xxxxxx/.../APInvoiceBatches by sending 19K entries and the API is not returning any value (no response). Is there any limitation on the entry creation?

Hello, I need to do a customer search using the Sage 300 Web API, but it needs to be case insensitive as some customer names are proper and some are in all caps. According to the OData documentation I should be able to use the tolower function, but…

I am trying to create a receipt and associate it to a Purchase Order using the web api. In the payload of the Receipt I have added the Purchase Order Number and it's sequence key. So in the receipt lines. On the sage side I see the receipt being created…

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…

Hi, I am having problems loading currency rates through the webapi. I am using v2019.1 on premises to load currency rates into company EURPAY. The following code using PHP and cURL is as follows: endpoint: "">localhost/.../CSCurrencyRates"; …

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…

Hello, I have been working with the Sage staff and currently still do not have a resolution to this issue. Effectively I am making a request through the API to enter an order for a purchased item from the website. Initially I was getting errors I…

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…

Currently Running Sage 300 Web API v1.0 | 6.4.0.20 I'm currently working on a integration project where I will be will utilizing the Sage 300 Web API. This integration will be focusing on Order Entry where we can insert a new order (POST) and eventually…