• Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    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…
  • Obtaining a list of payment allocations by payment number using API

    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…
  • Obtaining invoices PDFs using the API

    Hi Team, Could you advise how to obtain the invoice PDF via API?
  • Obtaining a list of customers using the 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…
  • New to Sage. How to import files from OneDrive

    We are running Sage 300 2020. Our finance team has been working with Excel files on a network share and then importing to Sage 300 GL transactions. We are in the process of decommissioning an old file server and moving their files to SharePoint Document…
  • The underlying connection was closed: A connection that was expected to be kept alive was closed by the server

    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…
  • Sage 300 Integration

    Hi Everyone, I am working on one sage integration with python web application and I want to send data from python application and create customer in sage. I am using desktop version of sage. My question here is if the API https://cdn.na.sage.com/docs…
  • Sage 300 API Question [On Premise]

    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…
  • Calling .net API FilterFetch on Customer View gives Attempted to read or write protected memory error

    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…
  • The program UP0023 has been deleted or damaged .net API Order Insert

    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…
  • Does ACCPAC.Advantage depend on Windows.Forms?

    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?
  • Where can I find documentation about Sage 300 cloud RESTful API?

    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…
  • UK VAT reporting for Europe

    Client in Canada has an entity that resides in the UK. They received a letter saying that they are 'required' to use MTD (Making Tax Digital) software to file their VAT returns. It seems that Sage 300 Cloud is not on their supported software list. Has…
  • Sage 300 Web API case insensitive search

    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…
  • Trying to set up the Sage HRMS/300 Link to run on a schedule automatically

    I'm trying to run the HRMS and Sage Link Automatically by setting it up in the Schedule Profile Configuration and Schedule User Login Configuration under Sage Payroll Link- Sage HRMS Setup. I'm following the steps provided to me in the user guide (attached…
  • Sage300 vs SageX3 implementation

    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…
  • Sage 300 Web API Order Entry Error

    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…
  • Unable to post an OEOrder, get vague error back

    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…
  • API endpoints

    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?
  • Acdev POS

    FormerMember
    FormerMember
    I am having Sage 500 ERP and ACDEV POS integrated with this and working fine. Now I have newer version Sage 300, 2016. Now how can integrate my ACDEV POS with Sage 300
  • Does anyone has idea about Sage 300 APIs?

    One of our client want to have WMS with our Sage 300 ERP. and the WMS provider requires APIs for integration between Sage 300 and WMS. Any idea?
  • Integration with Salesforce

    Does anyone have any experience or insight on integrating our on-premise Sage 300 ERP with Salesforce? I found a pricey app from Commercient, and a consulting company also suggested using DBAmp. Any thoughts on these options? Any other suggestions on…
  • SData

    I need some advice with a lead. It is unusual because they are primarily interested in developing an interface to Sage 300 from their custom in house software, which is developed in a LINUX environment using PHP and PYTHON programming. Specifically they…