We have Sage 300 2020 On Premise (Not cloud), can we use this SDK https://github.com/SageNADev/Sage300-SDK for development?
Thanks!
We have Sage 300 2020 On Premise (Not cloud), can we use this SDK https://github.com/SageNADev/Sage300-SDK for development?
Thanks!
Thank you Jay Converse Acumen. But I read somewhere we have to purchase a separate SDK for the desktop version of Sage 300. So based on what you said, that's not needed.
You do not need to purchase or use other SDK to do any development. Sage is a COMAPI-enabled app, which means you can call the Sage 300 library from any Dotnet language.
No, that SDK on GitHub is for Web development only. For desktop development, you need to purchase the desktop SDK. Or as Jay said, don't use an SDK - just use the API which is free for anyone to use. It really depends on what sort of development you want to do.
Dingosoft, thank you for your reply.
We want to be able to integrate the following data flow between Sage and a website.
1) save into Sage the orders received through the website
2) retrieve inventory, customer information from Sage and display it on website.
For such purposes, do we need to use SDK or not?
Thank you!
Writing orders from a db to Order Entry can absolutely be accomplished using the API (no SDK required).
When extracting data for use on your website, you can also use the API, but you may achieve better results reading directly from the database.
To start the process, I'd suggest recording a macro while entering an order. This will provide a basic framework you should be able to build on. If you run into specific challenges, there is a wealth of knowledge within the VBA forum for the searching and / or asking.
Thank you all so much for the response! We are fairly new to developing with Sage. For what we are going to do (read order, inventory and product information from Sage, and write to Sage with order data received through website), what are the potential pitfalls or areas we should pay attention to? Thank you so much!
Hi Julie, not exactly sure if your end-goal is to acquire this skill set and develop 'in-house' or if you are open to acquire this functionality via a commercial product. If the latter, we can demo this functionality via the SDK, .NET API and SQL, triggered ad-hoc by the user, polled, or as a service using our Nexus and EnableTRANS Automation Framework. Let me know if that is helpful. Cheers, Derek
Thank you Shane!
Is what you said about Sage 300 also applicable to Sage 100?
Thank you!
D Kellock, we would like to develop it "in-house". We are open to hire outside consultant to lead the project. But we like to our own in-house developer to do the ground work. Thank you!
Where can we find the COMAPI definitions?
Hello, to extract data from Sage300, what API we should call?
You don't need an API to do exports, just use SQL queries. Or select File/Export from a UI.
Have you looked at Realisable IMan? It's designed for exactly what you appear to be trying to do. The major, major benefit is that you don't have to learn the API. It does it for you.
I always look at Realisable IMan first for this type of project, then move on to API if it's not suitable. 9 times out of 10 Realisable IMan does the job.
for retrieving orders information, what tables we should look at? The tables name don't make sense at all.. any hint? Thanks Jay!
thank you, will check out
You want to search in the KB for the object models. That will give you better descriptions of the tables and fields in Sage.
Jay, those links don't work at all.. can you provide another link?
That link is good, I've used it for years, so I don't know what your issue is. Just google "sage application object module".
When I tried to download the attachments, for example "Sage 300 2019 AOM.zip", nothing happened.
Yeah, it's broken. Only Sage can fix it.
Hi julieseller,
We are also integrating with Sage 300 and we are looking for the right API to do the job we need. Were you successful in finding overviews of the current APIs? I would love to hear what you discovered.
Look at Realisable IMan. Why go through the API learning pain?
*Community Hub is the new name for Sage City