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.
Hello Team, We use the following endpoint to receive Customers from Sage 300: http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers But, if the Customer is deleted in Sage 300, this endpoint doesn't return Customers. How we can receive deleted…
In Sage 300 the Customer has three balances:
But via API Sage 300 returns only the Outstanding A/R Balance. How to receive A/R Pending Balance and Total Outstanding Balance via API?
Hi we are having an issue with our Sage CRM and promoting to Sage 300.
We haven't used this function before resulting in a lot of duplicate customers being in CRM. This is because we have them entered as prospects and then we sent them up as actual…
Hello Team, I try to push a payment with the 'Receipt' status. But I receive an error message: "value": "The request parameters are invalid. Fail to save value to (Applied Receipts/Adjustments) for fields (Customer Number, Document Number, Payment Number…
Hello Team, I found that I can add contacts only at the Customer level in Sage 300. But I cannot find how to add contacts at the Invoice level. Could you clarify, is it possible or not?
Hello Team, To receive the currency rate I use the following endpoint -> CSCurrencyRates The response has the following structure:
{
"ToCurrency" : "CAD" ,
"RateType" : "AV" ,
"FromCurrency" : "AUD" ,
"RateDate" : "2020-01-02T00:00:00Z" ,…
Hello Team, Does Sage 300 allow receiving Customer and Invoice notes via API? If yes, could you provide the endpoint on how to receive notes? Thank you!
Hello Team, In Sage 300 the Customer has a few balances As I understand, the main Customer Balance is the Total Outstanding Balance . Is it correct? Or we should use as the main Customer Balance this field -> Outstanding A/R Balance ?
Team, Is it possible via API to receive Invoices and Customers statuses? If yes, could you provide the name of the endpoint? Where on UI in Sage 300 I will be able to find the list of Invoices and Customers statuses?
Hello Team, I have some questions about how to integrate currencies from Sage 300. We use the following endpoint: http://{Base_URL}/Sage300WebApi/v1.0/-/SAMLTD/CS/CSCurrencyRates
1. API returns the RateTypes. How they influence of the choice which record…
Hello Team,
I want to apply a payment to the Invoice. To do it I use the following endpoint: POST ARPostReceiptsAndAdjustments Example of the request:
{
"BatchRecordType" : "CA" ,
"BatchNumber" : 77 ,
"BatchDate" : "2021-06-27" ,
"Description…
Hello Team, According to the Sage 300 specification, we can use the following filter 'allpages' For example: http://{ip adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$inlinecount=allpages But, we cannot receive the number of customers in the response…
Hello Team, Does Invoice have the Invoice close date? If yes, what is the name of this field on UI? And what is the name of this field in the response for method ARInvoiceBatches?
Hello Team, When I try to call ARCustomers via API using a filter that designated in the Sage 300 specification, I received an error. Example of the request: http://{IP Adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$filter=DateLastMaintained le datetime…
Hi Experts ,
I'm currently working on a integration project where I will be use the Sage 300 Web API. This integration will be focusing on Order Entry / Invoice Entry where we can insert a new order (POST) and eventually we will need to be able to…
Not a normal question for the forum but still related to CRM.
Client is not using SageCrm anymore due to several reasons. We have set the integration to "Suspend all Integration" with CRM in the Sage CRM setup. Now we are having an issue using the Customer…
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…
Hi, I am trying to build a solution that should integrate with Sage 300 cloud to sync customers, projects, work orders, etc...
I have looked around but could not find any documentation about Sage 300 cloud API. Could you please point me to Sage 300…
Hi All,
I would like to know if is there any ISV that provide features to set bundled sales. For example buy 12 get 1 free. I have check Standard Sage 300 IC, it does not support this.
Or is there workaround to achieve this?
Thank you.
Is there any way to post a Sales Order shipment via the Web api in order for it to create an Invoice?
I have Sales Orders created on Sage, and I want to create a shipment related to that Sales Order and have Sage create an Invoice associated to that…
We are getting the following error when trying to post an order to sage 300. "a problem occurred and the order could not be posted." The error occurs when trying to add a line to an order. The order actually posts correctly and shows if you refresh the…
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?