Sage 300

Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…

Hi Team, Could you advise on this question. To receive payment or credit memo allocations, Sage 300 API suggests using this API method ARReceiptAndAdjustmentBatches. I tried to use the API method to obtain a list of allocations by payment number. Example…

Hi Team, Could you advise how to obtain the invoice PDF via API?

Hi Team, Could you advise how to obtain a list of Customers via API? Now I use the GET request https://{{HOST}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers('customer_name') But if I should receive a few customers, I should a single request for each Customer…

Hi All, In my current project I'm writing a code to create a payment batch in Sage300 via REST API. In order to do that I'm doing a GET to a random payment and then clearing the fields to add the new data. Is there a way to get a template of the payload…

We are using API while pushing data from a 3rd party software to Sage 300. Entry per batch consist of maximum of 3000 per entry but not all batches has this qty. Before all posting went well until this month we notice that some entries are not being…

Hello, We are using Sage 300 (version 2020) on premise with a perpetual concurrent user license using the desktop screens exclusively. We have a 3rd party CRM solution that we would like to integrate with Sage. I am by no means familiar with SAGE development…

I was having a discussion in another post but it was getting too long and I figured this might be a good post for others to find. Trying to grab a lot of data from Sage, and I was pointed to CSO120. It's been great so far, but I've run into a couple snags…

I'm calling the browse method and trying to find an order by number. This code takes around 4-5 minutes. Are these method really that slow? var view = OpenView("OE0520"); view.Browse("ORDNUMBER = 5555555555", true);

FilterFetch on a client machine is throwing the following error on customers. Works on my local machine Unhandled Exception: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory…

var view = OpenView("OE0520"); view.Cancel(); view.Init(); view.Fields.FieldByName("ORDNUMBER").SetValue(order.OrderNumber, false); view.Fields.FieldByName("CUSTOMER").SetValue(order.CustomerID, true); This code is returning the error, "The…

Trying to use the .NET ACCPAC.Advantage library in a console app and it's saying I need a ref to windows.forms DLL? Is this normal? Do I really need win forms?

Hi all, I would like to know if it is possible to filter by CustomerNumber in Invoice Model using $Filter I try to do as below but I am getting " The child type 'Invoice.CustomerNumber' in a cast was not an entity type. Casts can only be performed…

Could someone please post a sample C# code for iterating the detail records ("OE0500") for a specific order? Stephen Smith has instructions to "Set detail key into the detail view." - but not sure how to interpret this. After composing my views, I…

Hi everyone, I am at the moment investigating the availability of cloud APIs for Sage300, and could find some documentation of an available web API, but which is not listed here https://developer.sage.com/ , and now wondering why? Is there an available…

Below URL is my Request URL to fetch Active GL Details "localhost/.../GLAccounts? %24filter=Status%20eq%20'Inactive'&%24select=UnformattedAccount%2CStatus " Am getting following Error "erro r": { "co de" : "InvalidParameter s", "mess age ": {…

Hello, We have a Sage 300 On Premise (non-cloud) version. We are looking to integrate it with our e-commerce website (PHP). We want to do two-way integration. 1) : From Sage 300 to website Customer invoice, order history, tracking information from…

Am using the Sage300 Web API for the first time. We can create invoices via AR/ARInvoiceBatches, but they end up with a BatchStatus of "Open" and cannot be posted by the /AR/ARPostInvoices('$process') service. It seems the /AR/ARPostInvoices('$process…

Hi all, I'm getting this error after I tried to Post Order Entry via sage 300 web api swagger in json format. the error message is : { "erro r": { "co de" : "InternalServerErro r", "mess age": { " lan g": "en -US", " val ue": "Internal Server E rror…

Hi there, I am just new to Sage 300 and planning to use it in our next project. IF there is a WordPress website which exports it's data in JSON format, is there a provision available in Sage 300 to import that data?

We are looking for someone to connect our Web API with Sage 300. These are the functionalities we need -Push Invoice -Verify if customer exists -If customer doesn't exist, create new customer in Sage We are currently building the Web API, therefor it…

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…

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…

Hi, I am trying to fetch product prices and product inventory, but couldn't find any which does the job. So, can you suggest me the suitable endpoints to fetch Item price and Item inventory?