by Brian Terrell

CodePartners attended Intacct Advantage 2013 last week in Las Vegas, and we returned excited by the opportunities Intacct affords both customers and channel partners. More than 1,000 customers and partners attended the five-day event in which Intacct delivered 60 breakout sessions addressing key technology and business topics. As a sponsor, CodePartners exhibited in the Advantag...

by Sheila Zhang
Using Microsoft’s SQL Server 2012 makes querying with XML a lot easier.  Microsoft’s SQL Server allows you to create XML with a SQL query or shred XML into a data table format.  I have shared with you below examples of achieving this query process faster.

When you use the "FOR XML" clause in the "SELECT- T_SQL" statement, you convert a query record set to XML...

by Jacky Xu
A client asked us to help him export specific information to a CSV file, and potentially change the file’s column order. In previous projects, I used the entity class to store the data and then export the information to a CSV file. However, to change the file’s column order, I made several changes to the export function so it works how the client wants and created a new pro...

by Hrayr Galoyan
“What on earth is Coupa?" I asked myself this when I heard about Coupa for a recent project. I quickly learned Coupa is a procurement system designed for businesses to simplify purchasing and ensure the users’ interaction is easy and enjoyable, as if you are shopping on Amazon.com. Technology supposedly makes our lives easier and more enjoyable. However,...

by Emma Tsai 
Recently, I received a request from one of our business partners whose client required a special tax calculation rule for their order entry system in Sage 300 ERP. To meet the client’s specific business needs, I modified the standard Sage 300 ERP OE screen. Now, it calculates each detailed line's tax, based on the quantity multiplied by the tax percentage setup within the ...

by Joe Zhou
I recently worked on a custom project using Intacct Platform Services. One of the custom objects I created is a look-up table with a many-to-many relationship with AR Invoice and Customer standard objects. When this object is in the View mode, it must show the associated customer’s name. Thus, I defined a related field to accomplish that. The only problem with a related field is ...

by Kristi Feng
Sage 300 ERP provides a budget maintenance screen to allow users to enter up to five budget sets each year. This is great at this time of the year, when everyone is in the middle of budget planning, and you need to know what will and won’t work.
 ...

by Brian Terrell 
Often, I spend time with prospects or customers who intend to engage a software developer to automate a business process. No one considers this technology purchase trivial.  Buyers get nervous because they hear real horror stories from their peers, or the media, about the unending and ever more expensive projects. I agree that software development is risky, bu...

by Sheila Zhang
I query databases almost every day. The database I work with most often is the SQL server. Microsoft recommends, as a best practice, writing standard queries. While I agree that writing standards makes code more portable, due to the ease of beginning work with new platforms, I also want to share some examples below in the Microsoft training kit that allow you to dec...

by Derek Du
I wrote a blog post on How to Delete a Team Project from Team Foundation Service Collection back in June.  Since then, the TFS team added a feature on deleting a TFS project via an user interface.  It is great seeing the improvements to the technology we use that Team Foundation Service is making.
Since this update is not obvious to the everyday user, I listed the steps below...