By Joe Zhou
On the day after I arrived in Beijing, I noticed an ad in the notification bar on my Nexus 7 telling me where to find the best iPhone deals in Beijing. That made me wonder why all of sudden I was seeing the spam ads. I recalled that I installed Sudoku Master and a word game to kill time at the San Francisco airport while I was waiting for my flight. I uninstalled both because they wer...

By Brian Terrell
Last week, I promised to continue a series on CodePartners' software development methodology. Over the last 12 years or so, we worked hard to help more than 500 companies use software automation to increase their revenues, decrease their costs, or achieve some other measurable business objective. For example, we helped companies automate so that they could expand into a new marke...

by Sheila Zhang
The Sage 300 ERP Avatax module is a very useful application. We have worked on many automation projects with either Avalara API or Avatax user interfaces. One of them was developed for the Project and Job Costing module (PJC).
The client is using the Project and Job Costing module. But the Avatax module doesn’t calculate the sales tax on the A/R invoices created from PJC mo...

By Kristi Feng
When working with Crystal Reports, sometimes it is hard to add all the tables to the main report to achieve the desire result. We can add subreports to help us, but sometimes we just want to add subreports to do calculations only, and it might leave extra blank spaces that are not needed if the subreport is in its own section. By following the three steps below, the extra spaces wil...

By Jacky Xu
Recently, we have a project that needed to print a report through SQL server reporting service. It’s my first time to work on the SQL server reporting service, so I had to spend some time researching this. I think reporting service is a great tool to show reports, and easy to use. Below are some steps to print reports:
1. Create a new Windows Form solution in VS2010.
2.&n...

By Hrayr Galoyan
I like both Sage 300 ERP and Intacct, and will write a series of articles comparing various features of the two systems. Today’s article is about revenue recognition. I have some experience with it in Sage so when I learned that Intacct supports it natively, I couldn’t resist investigating.
Basics of Deferred Revenue
The basic need in any revenue recognition applica...

By Emma Tsai
The National Account Change product we developed for Sage 300 ERP (Accpac) allows users to update the National Accounts for all selected customers in the Sage Accpac Accounts Receivable module based upon setup made to the program. The following steps show you how to use the import function for batch update.
1. Launch the National Account Change program
2. Enter the file ...

By Derek Du
When dealing with firewalls, you must have a clear understanding of which port your application is using.
Today I took it for granted that a SQL Server named instance such as \SQLEXPRESS is sharing the same 1433 port with the default SQL Server instance. Later after I found out it didn’t work, it finally occurred to me that two processes cannot listen to the same port.
Anyways...

By Joe Zhou
Previously, I wrote a blog titled “The OWASP Top 10 Most Critical Web Application Security Risks”. In this blog I outlined the top 10 security risks published by OWASP for year 2013. I also briefly covered how we use the list in our daily coding practice.
Today, I came across an interesting article authored by Rohit Sethi.  It is titled “Don’t Focus on t...

By Brian Terrell
How has CodePartners helped more than 500 companies in nine countries enhance their revenues or reduce their costs? We have a specific methodology to help our clients achieve these impressive results. Over the next several weeks, I’ll spend some time on each step of our process, which is illustrated here.
...