• 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…
  • Error adding an item to a sales order

    I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get: "Order Detail. Attempt to modify a different record than was retrieved." This occurs on the code…
  • Sage 300 Web API 2019

    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…
  • Connectivity problem with Excel

    Hi, MS released an update this past weekend and it seems to have affected connections to excel. I was wondering if anybody else has experienced this. Before the MS updates our macros were programmed to connect to Excel with Microsoft.ACE.OLEDB.12.0…