• Getting started with SData (posting/creating customers)

    So I've got SData installed and working. I can ping AR_Customer to get a list of customers. However, attempting to post to this endpoint with the following body fails: Of note, I've slimmed down the payload to only what is known to be the simplest required…
  • sData Create Sales Order Payload Sales Order Lines with W/T and Job OPS

    Hi Everyone, We are working on an ecomerce intergration using Sdata. A plain order works with the lines, qty and price coming over. We are stuck when we try to sent a SO that has Parent Items that need work tickets created and assigning the child…
  • Best option for extracting data out of Sage 100 into Third-Party software

    We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
  • Strange behavior with Shipping Rate Maintenance with Sage 100 2018 Premium and SData/Web Services

    Hello! We just upgraded from Sage 100 2014 Advanced to Sage 100 2018 Premium. Our website for years used e-Business web services / SData integration. All worked fine. And after upgrade all is good, except this small issue - custom rules with shipping…
  • Is SData a technology we can expect to be improved and developed in Sage 100 Standard?

    We've built a connector between WooCommerce and Sage 100 Standard using SData and have found that SData has some quirks that have proven to be a real pain to work around. It's also not very well documented (at least the version of SData used in Sage 100…
  • How to delete a Sales Order Invoice using SData in Sage 100?

    I have a need to delete a Sales Order Invoice using SData and I can't seem to figure it out. When I run an HTTPS DELETE request to https://<sdata-connector-server>/sdata/masapp/mascontract/<company-name>/SO_InvoiceHeaderSPECIAL('0026094') I get the following…
  • Does the SData Native Adapter that comes with the Sage 100 2018 installer add additional functionality over the Sage 100 2017 version of the adapter?

    We are currently using the SData Native Adapter with Sage 100 2017 to connect our store application with Sage. I'm trying to decide if it would behoove us to upgrade to Sage 100 2018 and the associated SData adapter. I'm wondering if the new adapter gives…
  • Sage 100 2014 SData GET returning lots of unwanted HTML in addition to the desired XML

    How do I get the SData GET to return only the XML with the requested data items? It is currently returning a ton of unwanted HTML that is a waste to transmit on every GET. I have tried different Content-Type options, but nothing I tried has worked: …
  • 'PVX data deserialization failed' during data transfer through SDATA after upgrade

    Upgraded from v2014 to v2016. When trying to transfer data from third party (Service Pro) to Sage 100 through SDATA, client is receive the following error: { "d": null, "Message": "PVX data deserialization failed.", "Errors": { "Validation": [], …
  • Recommended SData Implementation

    The only useful documentation/tutorials I can find for SData is a really old youtube series on SData Consumers and the SData 2.0 github page. Which is the recommended implementation for using SData? If you could provide an example of the second option…
  • SData Provider Adapter Usage

    I'm trying to test out my connection to the SData portion of my installation of Sage 100 ERP. When I test it using the C# Client helper way of adding an SData Reference in my VS project using a url to the schema file (ex: http://[server name]/sdata/MasApp…
  • Website integration

    We have a customer currently in v4.3 (waiting for SWK POS) ready to move to v4.5 within the next 4 weeks. They are building a complete website with ecommerce using Magento (?). What integration tool would be best to use to integrate (read/write) data…
  • SData Error when using PUT on SO_InvoiceHeader

    I'm implementing an update operation for our integration and when I attempt a PUT operation I get the following error: This entry already exists in batch SERVO. Here's the raw request: PUT ~/sdata/masapp/mascontract/abc/SO_InvoiceHeader('0100117…
  • SDATA Error Message When POSTing/Creating AR_Customer

    When attempting to use SDATA to POST an AR_Customer, I'm receiving an error: <sdata:diagnosis> <sdata:severity>error</sdata:severity> <sdata:sdataCode>ApplicationDiagnosis</sdata:sdataCode> <sdata:applicationCode xsi:nil="true" /> <sdata:message>Exception…
  • Looking for WMS to integrate with Sage 100

    Hello, We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…
  • JobOps with Sage 100 ERP using barcoding with JOScan

    Community, We are a mid-west manufacturing company and are looking to implement the JobOps product with barcoding using JOScan. We are hoping to find another company presently using JobOps with Sage 100 ERP that might be willing to share their experience…
  • PO Receipts are not created properly in Sage100 using SData

    I'm trying to create receipts in Sage 100 using the SData interface. The XML that is sent to the server is presented below. It should create one receipt with one receipt line. Request to the server is executed successfully, however created receipt is…
  • SData Install & Training

    Has anyone here successfully installed SData and created an application that uses SData to write information into Sage 100 2013 (version 5.0) files? I could not find any SData training on Sage University and I have found very few examples on the internet…