• Cannot update existing AR Item using SAGE 300 .NET libraries

    I'm a developer working on application that requires syncing a database of my own with a number of tables in the SAGE 300 databases. I was previously using the SAGE COM APIs to do this syncing, but my application is written in C#, so I'm in the process…
  • Sage 300 SDK field values not setting ONHOLD and PRIPERCENT

    Setup: C# Framework: .NET Framework 4.8 SDK: ACCPAC.Advantage Code Context: OpenView just initializes a session to the DB, there would be no issues behind this - it works just fine with everything. Important: No errors appear what so ever…
  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    Good day, I am trying to export data from my local sql DB in sage. I am new to sage integration, so i have narrow knowledge on this subject matter. When i inserting InsertInvoiceDetailSoftCols() i get an exception "Error HRESULT E_FAIL has been…
  • PORCP1headerFields.FieldByName("RCPHSEQ").SetValue("0", false) || Returns "Object reference not set to an instance of an object"

    Good day, Please assist, I have C# code to export data from my local DB to Sage. When inserting invoice headers I get "Object reference not set to an instance of an object" I am fairly new to project and Never worked on sage before. I have a very…
  • Sage300 Integration with C#. Error Occurred While Opening ODBC Connection on Sage 300 Application using C#.

    ERROR [08001] [Simba][SimbaEngine ODBC Driver][DRM File Library]Invalid account name.ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version…