by Joe Zhou

Here are four interesting articles I read in the past week.
1.       Check out the how-to guide on landing pages from TNW
2.        Outsourcing is no longer a dirty word. 
3.       10 Writing Tips for Great Social Media Posts
4.       Web Essentials 2013 v...

by Brian Terrell

Recently, I spoke with a leading Intacct business partner about the opportunities and challenges of tailoring Intacct to the exact needs of the customer. The world loves to call this customization, but I have never liked that word. I feel it implies that the product misses a feature or is otherwise incomplete. I prefer to call these types of development efforts “automation...

by Derek Du

UI design is part of my daily work and I use Axure to build mock-up screens all the time. Recently, I updated the tool to its latest 7.0 version and noticed that some of the new features it offers are quite useful. What I found to be the most useful are the ability to pull or push adjacent widgets when a widget is hidden or shown, and the ability to break away the first sta...

by Joe Zhou

In Intacct the underlining object for both Purchase Requisition and Purchase Order are the same. When a Purchase Requisition is being converted to a Purchase Order, a new PODOCUMENT record is duplicated and a few fields are updated as a result of the conversion. In the conversion process, sometimes you want to know which Purchase Requisition the Purchase Order is converted from. Luck...

by Emma Tsai

Here are some of my favorite articles on website development:
Big Data for Small Business - Why It Matters!

Check out for some tips on tapping into big data.
 
Business Intelligence Won't Help Your Business, unless. . .

"To make real, measurable progress, we must embrace the data-driven business model."
 
The Beauty of Software Testing
I hope you find them helpful and ...

by Jacky Xu

Sometimes we have project where we need to connect to an sftp server, download and upload a file. But, Microsoft .net library does not have an easy solution for it. WinSCP provides a .net library to operate the sftp site easily.

1.       You should download the library from WinSCP website and install it.

2.       Add it...

by Brian  Terrell

Often, I tell Intacct and Sage business partners that the value proposition delivered by BTerrell's CodePartners Division includes two key points:

• to help convert opportunities into client relationships, or 
• strengthen current client relationships 

Today, I'd like to recount some conversations I had over the last three weeks that serve as an excellent...

by Emma Tsai
In my last blog, I talked about how to use PIVOT operator to group and aggregate data in SQL database. Today, I am going to share how to Un-pivot data.
The starting point is some pivoted data. I used a sample table called Sales.FreightTotals as an example. The sample data shows as below:
...