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:
...

by Jacky Xu
Here are the most useful articles I read this week:

Use the methods to let you build condition easily
 
Have a good weeke...

by Derek Du

After my last blog post about using Cert-based Message security for WCF web service, we started to look into using Windows Authentication for a different system that also sits behind a load balancer/SSL handler. Windows Authentication provides a much easier integration option – the client side can simply provide a domain user account to be authenticated, whereas in Cert-ba...

by Brian Terrell

At CodePartners, we work with the best Intacct and Sage Business Partners in the channel. Not every firm employs development resources, so CodePartners stands ready to make those capabilities available to everyone. By working with us, business partners enjoy the ability to provide additional services "to deliver the last mile" of technology to their prospects, or they benefit by...

by Joe Zhou
Here are my favorite articles (and videos) I found this week:

1.       3 minute tech video series
a.       How to sign up for Windows Azure http://t.co/fvN0q7U7qQ
b.      How to create a Linux VM in Microsoft Azure http://t.co/Z1peh956Cj
c.       How to Create ASP.NET&...

by Hrayr Galoyan

Intacct check alignment seems scary, particularly if you are printing on blank stock. MICR line alignment is the most critical part, and different banks have different requirements. Fortunately, it is not as difficult as it seems. Intacct provides excellent guidelines on the process but here is a “Quick Start” manual.

Step 1

Configure the checking or saving accou...

by Kristi Feng

Last week a coworker asked me, “Do you know which object stored the amount paid detail for AP bills in Intacct?”


I thought it was in AP Payment and AP Payment Detail, but payment and payment detail do not have references to AP Bill. Then, I looked in Objects in Platform Services trying to see ...

by Emma Tsai

Here are some of my favorite articles:
10 User Interface Design Fundamentals

 

3 Security Mistakes You Shouldn't Let Your Small Business Make

Data breach is a nightmare for every business owner. Avoiding some basic mistakes that companies of any size can make will help minimize the risk.

How to become a Data Scientist...

Did you know there are four different types of ...