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…

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…

Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…

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…

After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen. What would be the reason of this and solution ?

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…

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…

I'm trying to insert an order using the API - and I'm getting back an error that just says 6666 How can I find what this means, and in general, is there a way to get the COM exceptions and error codes? I know how to get session.Errors, but that is empty…

I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…

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…

Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…