Sage 300 Newsletter – September 2016
Keeping You Up-To-Date With Information About Sage 300
An Introduction to Sage 300 .NET API
This article is a brief technical introduction to Sage 300 .NET API. It describes a bit on “how” things are built.
.NET API has been part of Sage 300 since version 5.1A. This API provides full capability to integrate .NET projects with Sage 300.
As a master developer, Net at Work has access to the and utilized the Sage 300 .NET API, The Sage 300 .NET API is not shared with the Sage 300 COM objects or ActiveX screen objects. This is completely different from developing applications using VB6 programming approach. When development projects required COM objects or ActiveX screen objects, the COMP API is used instead. .NET API does not provide the capability to interact with COM objects or ActiveX screen, since they are VB6 technologies. .NET API has full access to COM API via .NET’s COM interop capability.
Below is a quick demo on adding Sage 300 .NET API to a .NET Windows project and using it to access Sage 300 session. In this example, Visual Studio 2015 is used with Sage 300 version 2016.
First step in using the .Net API is to create Windows project in VS2015 called “Sage300DotNetAPI”, then add 2 references to the project “ACCPAC.Advantage.dll” and “ACCPAC.Advantage.Types.dll”, which are the two common references to use.
In the Windows project, I have 1 Windows form and 1 button. The button does 2 tasks: 1) Log on to a Sage 300 session, then get and display a list of Sage 300 companies; 2) log on to 1 Sage 300 specific company, SAMI63A, then and get a list of the active applications of the company.
This short articles shows only a very simple example of Sage 300 .NET API and reveals a bit technical knowledge that we use in our development projects.
Sage keeps up with the current technologies by evolving with .NET technology, which is being used in basically all small to mid-sized companies. This allows Sage 300 to better integrate with existing and current technologies and systems. Sage 300 .NET API is a critical system object we use in our architecture and development work.
When we define a solution for custom applications and integration applications for Sage 300, we normally work with our customers to define the best integration points and business rules to encapsulate. As far as the technical work, we always use the current technologies as our principles, to provide system longevity and growth for our customers and ourselves.
Please contact our Sage 300 team for your inquiry and needs for custom development projects for your Sage 300.