The integration between Sage 300 and Sage CRM creates a link that enables Sage CRM and Sage 300 to share information as it is entered into either program.
After integration, front-office personnel can create customer quotes and orders in Sage CRM and then promote those quotes and orders to Sage 300. As quotes and orders are processed, both systems are updated, preventing redundant data entry and enabling front-office…
The Sage 300 Web SDK (SDK) is a collection of wizards, utilities, samples and documentation for developing Web Screens for the Sage 300 Application.
This week we released the Sage 300 2020 Web SDK to coincide with the release of the Sage 300 2020 Application.
The SDK is available at https://github.com/SageNADev/Sage300-SDK.
As described in a previous blog and in the README…
Sage 300 supports English, French, Spanish, Traditional Chinese, and Simplified Chinese languages.
Customers, using non-English languages in the Web Screens, may encounter pain points in the following areas:
Some developers may already know how to debug into your C/C++ Accpac Business View while debugging/running your module’s Sage 300 Web Screen. But, for those who do not, this little tip is very handy.
This tip allows you to debug into your Accpac Business View (where you have the source) and from your module’s Sage 300 Web Screen.
You have your solution loaded in the Visual…
Some developers may already know how to create a class from JSON metadata. But, for those who do not, this little tip is very handy.
I’ll use the Sage 300 Web API and create classes based upon the ARCustomers endpoint. Of course, this also possible with any JSON metadata, but since this is a Sage 300 blog, using Sage 300 metadata feels right.
I give credit for this tip to Vega and I’m simply providing…
The Sage 300 Web SDK (SDK) is a collection of wizards, utilities, samples and documentation for developing Web Screens for the Sage 300 Application.
This week we released the Sage 300 2019 Web SDK to coincide with the release of the Sage 300 2019 Application.
The SDK is available at https://github.com/SageNADev/Sage300-SDK.
As described in a previous blog and in the README file…
The Sage 300 SDK, not Web SDK, requires Visual Basic 6.0 SP6 to be installed on the computer. But, what happens when that computer has Windows Server 2012/2016 and there are compatibility issues when attempting to install Visual Basic 6.0?
This article will show how to get Visual Basic 6.0 successfully installed.
While this solution might not work for all, it has worked for Sage 300 developers.
…
So, you are developing Web Screens for Sage 300 and you want to be able to check a field value or some field values that are returned from the super view. In the Sage 300 Desktop, which is based upon the Visual Basic 6.0 development environment, this is simple and straight-forward.
But, how is this done in the Web Screens where the process is handled by a Worker Role?
This article will explain how this is…
When developing Web Screens for Sage 300, a developer typically compiles and runs in Debug mode within the Visual Studio IDE.
Changing to Release mode and compiling the solution performs an additional step which is to deploy or copy the required assemblies and files to the developer’s local Sage 300 installation. This is beneficial for the developer to see the screens running via the Sage 300 homepage.…
The Sage 300 Web SDK (SDK) is a collection of wizards, utilities, samples and documentation for developing Web Screens for the Sage 300 Application.
This week we released the Sage 300 2018.2 Web SDK to coincide with the release of the Sage 300 2018.2 Application.
The SDK is available at https://github.com/SageNADev/Sage300-SDK.
As described in a previous blog and in the README…
The Sage 300 Web SDK (SDK) is a collection of wizards, utilities, samples and documentation for developing Web Screens for the Sage 300 Application.
This week we released the Sage 300 2018.1 Web SDK to coincide with the release of the Sage 300 2018.1 Application.
The SDK is available at https://github.com/SageNADev/Sage300-SDK.
As described in a previous blog and in the README…
As you are probably aware, Sage 300 views can be compiled with a C++ compiler. You have probably noticed the:
#if defined(__cplusplus)
namespace A4WAPI {
#endif
wrappers in the program files and
#ifdef __cplusplus
extern "C" {
#endif
in the header files, but if you are like me, have never had a need to compile a view with C++, so never thought much about it. I’m certainly not recommending that you do compile…
The Sage 300 web screens are comprised of 113+ Visual Studio projects. This represents a large and complex code base. Simply opening a project and viewing the components and references to understand the relationships and dependencies can be a daunting task.
The relationships and dependencies between not only projects but also classes and methods are sometimes best understood when presented visually.
Microsoft…
Printing reports in the VB UI is pretty straight forward and fairly well documented. You specify the report name in the RptName() function. Example: RptName = "XXREPT01"
Then, create a section in the report descriptor file (the xxrpt.ini file) with the same name. The report descriptor file defines things like the parameters for the report. You have probably noticed that if you don’t have a section in the xxrpt…
The Sage 300 Web Screens use Resource Files (Resx files) to localize strings, text, captions, messages, etc. that are presented in the screens. Behind the scene, these Resx files are supported by Microsoft’s Resource Manager class and framework.
So, what happens if a Resx file for a language is not provided or blank values exist in a Resx file?
Before we begin, let’s identify the…
JavaScript Bundling is a technique that can be used to improve request load times. The Sage 300 Web Screens use this technique to bundle the required JavaScript files on a per screen basis.
There is a known issue that bundle names with a dot will generate a 404 error condition in certain situations. While the Sage 300 bundle names do not have a dot in the bundle name, it was recently discovered…
Microsoft’s DateTime Structure is an object that represents an instant in time, typically expressed as a date and time of day.
In Sage 300’s Web Screens, we use this object for dates and times in our C-Sharp code. However, we do not use its numerous properties and methods directly. Instead, we have encapsulated this functionality in our DateUtil class.
Let’s me explain why we came to the decision…
The Sage 300 Web SDK (SDK) is a collection of wizards, utilities, samples and documentation for developing Web Screens for the Sage 300 Application.
This article is about the first partner contribution to the SDK!
As I mention in the README document for the SDK in GitHub:
All tools can only be so much to everyone in order to consider everyone’s based needs while providing functionality…
The Sage 300 Web SDK (SDK) is a collection of wizards, utilities, samples and documentation for developing Web Screens for the Sage 300 Application.
This week we released the Sage 300 2017.1 Web SDK to coincide with the release of the Sage 300 2017.1 Application.
The SDK is available at https://github.com/SageNADev/Sage300-SDK.
This SDK has been previously made available via Sage’s DPP…
In my previous article, I shared my thoughts on open sourcing the Sage 300 Web SDK (SDK) and how, in my opinion, this will benefit the Sage 300 Ecosystem.
In this article, I am introducing the SDK as Open Source Software (OSS) and will explain the changes to the original vision since the idea of open source was first presented along with the policies and procedures for the repository.
In this article, I want to share my thoughts on open sourcing the Web SDK for Sage 300 and how, in my opinion, this will benefit the Sage 300 Ecosystem.
Let's start by first defining what Open Source Software (OSS) is:
Open-source software (OSS) is computer software with its source code made available with a license in which the copyright holder provides the rights to study, change…
The following question was recently asked:
I am a developer working in my Sage assigned module and I need to invoke a finder from one of the standard Sage modules (i.e. AR, AP, GL, etc.). How do I do this?
This article will illustrate the steps required to invoke a finder from a module other than what is currently being developed.
To illustrate the steps involved in adding a finder from another module…
Stephen Smith
As most, if not all, are aware, Stephen Smith, Sage 300 Enterprise Architect, retired at the end of February, 2016.
I want to acknowledge Stephen’s leadership, mentoring, friendship, his knowledge of the Sage 300 product, technologies and the accounting industry. These qualities and attributes will be missed by all at Sage. Stephen was at Sage (and Computer Associates) for over 22 years and has certainly…
The Sage Connect 2016 conference has just wrapped up in Sydney, Australia. I was very happy to be able to head over there and give a one-day training class on our new Web UIs SDK, and then give a few sessions in the main conferences. This year the conference combined all the Sage Australia/New Zealand/Pacific Islands products into one show. So there were customers and partners from Sage HandiSoft, Sage M…
Hand in hand with true HTML/JavaScript/CSS Web UI’s you also want to access the same logic from other general programs using RESTful Web Services. This gives a general API to access the application which doesn’t require any Sage 300 components be installed on the client computer and doesn’t require the calling application be on the same computer or even at the same location.
…
