• SQL Mirroring

    FormerMember
    FormerMember
    With the NEWS that DSD is retiring their SQL Mirroring solution as of the end of the year, I wanted to mention that I wrote a SQL mirroring solution for Sage 100 using the open source and free Postgres SQL 64 bit server. If you're looking for a DSD replacement…
  • Accessing Sage 100c from Java code

    Is it possible to access Sage 100c data from a Java program? Is there a JDBC driver available to connect and get data from Sage 100c?
  • Inventory Management w/ eBusiness Web Services

    I am currently attempting to sync product information from MSCRM online to Sage100 on prem... Is there anyway to manage the Inventory Items through the eBusiness Web Services? I am able to retrieve customers, sales orders, etc. but do not see any options…
  • How to delete a Sales Order's Shipping entry using SData?

    I want to delete a Sales Order's Shipping entry programmatically using SData API. I tried to execute DELETE request to SO_InvoiceHeaderSPECIAL resource, but unfortunately I only got this response: <sdata:diagnosis> <sdata:severity>error</sdata:severity…
  • Difference between nWrite and Write

    I feel like I've seen this in another forum post somewhere. Could someone point me in the direction of the answer? What's the difference between using the COM ProvideX object that requires nWrite and nSetValue versus the Sage VB script interface where…
  • Retrieve Inventory Item

    Which business object I need to use to get Inventory Item from Sage Erp 100 using c#?