by Sheila Zhang
I recently reviewed SQL character functions in SQL 2012. One thing I learned is that these functions also work in SQL 2008.
Commonly, I need to combine several string type fields into one in your select statement. So, I may write something like this:
“SELECT empid, country, region, city, country + COALESCE( N',' + region, N'') + N',' + city AS location FROM HR.Employees&...

by Kristi Feng
A while ago, a client asked if Sage CRM had a way to default the Company Interactive Dashboard based on Company Type.
There is an asp page that displays the interactive dashboards. It is located under #CRM Installed Path#\#CRM Instance Name#\WWWRoot\InteractiveDashboard\InteractiveDashboard.asp.
It will pass QueryString to the SDataWebservice and if the QueryString contains the lpLa...

by Jacky Xu
In a previous blog post, I talked about how to get the environment set up to create mobile apps with PhoneGap and jQuery. Once you have the environment set up, it’s time to get started:
1. Create new project like below.
 
Select Android Application Project and click next.
 ...

by Hrayr Galoyan
The optional fields configuration for GL Journal Entry in Sage 300 ERP can be a little confusing. Say you wanted to capture a field called SERIALNO on the detail level of Journal Entry. You would first create the field in the Common Services, and then add it to the Transaction Details as shown in the figure below.
 ...

by Emma Tsai
Recently, one of our Sage business partners asked me to do a customization project for Sage CRM 7.1. Their client wanted a way to copy an entire response for a quote and allow users to enter a new Quote Number to create a new quote.
We worked with the partner to get the requirements and created a simple program that would enable this to happen with a few keystrokes. With this customi...

by Derek Du
Among several web service test tools I use, including WCFStorm, VS WCF Test Client, and other proprietary test tools, soapUI is my favorite. In a recent project, with the help of soapUI, I was able to add custom fields into an HTTP header, compose the authentication header field, and POST JSON data to a REST web service. Here’s a quick guide on how to add REST web services to soa...

by Joe Zhou
There are so many ways to import data into Intacct. The most straightforward method is to prepare a CSV file that conforms to the format requirements of the object, manipulate the data in Excel, and use the Intacct import function to load the data. In this article, I will share with you a different approach that doesn’t require Excel and Intacct’s export and import buttons....

by Brian Terrell
Recently, a Sage business partner emailed me with these exact questions: “How do the integration capabilities of Intacct measure up compared to Sage 300 ERP? How is Intacct for screen customization?”. Many of our Sage business partner clients have also decided to sell and support Intacct Cloud Financials, and they naturally wonder to what extent their clients will be a...

by Sheila Zhang

If you need to monitor a system that has performance problems, start using Extended Events. It is a very lightweight performance monitoring system.

SQL Trace is an internal method for capturing events. You can set it up either manually or through SQL Server Profiler. Currently, it is supported by SQL 2012 and next version. After the next version, it might be discontinued.

SQL Se...

by Kristi Feng
Recently a new user to Sage CRM asked How to hide columns from the CommunicationToDoList. She tried with "Hidden = true;" in the Create Script, but it has no effect.
It was not specified in the "Developer's Guide," but in the "System Administrator Guide" it stated that we can do "Visible = false;" to hide the column in list control.
For example, we can put the following in the Creat...