Browse By Tags

  • Access Sage CRM relationship data via Rest API (sdata)

    Is there a way to acces and update Sage CRM relationship data? We use the Rest API interface (sdata in version 2022 R2) to access company and person data. In the user interface we use relationships to do company-company relationships. In the Sage CRM…
  • 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…
  • Address Validation with Avalara

    Hello, We have encountered an issue when validating addresses where the FOB and ship method are automatically changed after validation is complete. Is there a way to prevent the FOB & Ship Method from being restored to default? Thank you for your…
  • Has anyone used an external requisition software?

    Has anyone used a software package that integrated with Sage 500 ERP for creating Requisitions outside of Sage and then generating Purchase Orders in Sage? What software did you use? How did that process go? Any recommendations or precautions?
  • 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…
  • Sage500 API Documentation

    I am new to Sage and we are looking for Sage500 API documentation because we need to pull data from Sage into a different receivables application. I have been looking around on the website and cannot find anything and I have made 10 calls to 10 different…
  • 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…
  • Is there a tool that will allow Sage 500 to retrieve a file from FTP for automated processing?

    Trying to integrate Sage 500 A/P with a third party application that drips a batch file into FTP. Sage 500 processing is already automated to process the batch, but it needs something to allow it to automatically retrieve the file from the FTP server…
  • how to download sdk

    i am trying to integrate sage 500 with my application , but i am unable to find from where i can download sage 500 sdk ....can any one help me out ? thank you
  • SData

    With X3, my understanding is that there are a number of different web servce integration capabilities. We experimented briefly with SOAP, but my impression is that it is quite slow, and it appears that SData is the future of X3, as indicated in several…
  • Programming Sage 300

    I need to start programming in sage 300. Typically programs that import etc. What software do I need and where can I get a good tutorial on this? I have no starting point.
  • Online Portal and/or Ecommerce Integration with Sage 300

    Hi, Does anyone have any recommendations for Online Portal and/or Ecommerce Integration with Sage 300? Requirements: 1. It must integrate with Sage 300. 2. Integrate with Ariba and Ariett 3. Be able to take Credit Card Payments 4. Be able…
  • Creating customer through API aka stored procedures

    I have been trying to create a customer in Sage 500 by means of sage provided stored procedures. To start with, I have my own stored procedure which creates a record in staging table, ie. stgCustomer. Thereafter, I invoke a stored procedure(api by Sage…
  • 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…
  • Importing customer payment for existing invoice

    We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details and offer customer payment through other means. Now I need to bring the payment information…
  • Are there any stored procedure to create/update customer and customer contact?

    I recently started working with sage 500 api which is really a set of stored procedures. At this stage, I want to create/update a customer as well as the corresponding contact. Does anyone have any idea of what stored procedures to use for this purpose…
  • 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…