By Emma Tsai

The Employee Number Change program for Sage ERP 300 is one of our best component sellers. It allows users to update the Employee Number for all selected employees in Sage ERP 300 Bank Services and Payroll modules, based upon setup made to the program. Besides changing the numbers one-by-one, do you know that it also allows you to make employee number changes in a batch simply by one click? Here is how the magic works:

1. After you set up the database connection information in the Employee Number Change program, you can export the employee numbers that you want to update by clicking on Export.

2. Then you can find the exported file in the file path you specified.

3. Fill in new employee numbers in Excel and update employee numbers with the file.

4. Check the results.

You can also check out our demo on YouTube.

By Derek Du

There are certain scenarios when you would need to use some windows control in your web application server side. Taking a snapshot of a URL/web page is an example when you would need to use Windows.Forms.WebBrowser control to load up a URL/HTML and save the page to a Bitmap. However you may receive an error saying: ActiveX control ’8856f961-340a-11d0-a96b-00c04fd705a2′ cannot be instantiated because the current thread is not in a single-threaded apartment.

This is because by default ASP.NET web application runs in Multi-Thread Apartment (MTA) mode, but WebBrowser control object is required to run in Single-Threaded Apartment (STA) mode as it does not handle its own threads synchronization, thus not thread safe.

Adding AspCompat=”true” to the page directive will force ASP.NET request thread to be in STA mode thus share a single thread with the COM object, e.g. WebBorwser control, it creates, and effectively resolve our issue:

These links explain the concepts better than I do:

COM Component Compatibility
How to use System.Windows.Forms.WebBrowser in a web app?
What does AspCompat=”true” mean and when should I ...

By Joe Zhou

OWASP, the Open Web Application Security Project, is a non-profit organization established to promote secure web application design. OWASP has produced some excellent security guidelines over the years. One of the most referenced guidelines is The Ten Most Critical Web Application Security Risks, a.k.a the Top 10 project. The primary aim of the OWASP Top 10 project is to educate developers, designers, architects, managers, and organizations about the consequences of the most important web application security weaknesses. The Top 10 provides basic techniques to protect against these high-risk problem areas – and also provides guidance on where to go from here. Below is the top 10 list – 2013 RC1.

A1 – Injection
Injection flaws, such as SQL, OS, and LDAP injection occur when un-trusted data is sent to an interpreter as part of a command or query. The attacker’s hostile data can trick the interpreter into executing unintended commands or accessing unauthorized data.

A2 – Broken Authentication and Session Management
Application functions related to authentication and session management are often not implemented correctly, allowing attackers to compromise ...

By Brian Terrell

I have heard a lot about sales tax, use tax and other local taxation issues recently. Congress has continued efforts to expand the collection of sales tax on Internet transactions. In fact, the Senate passed last week the Marketplace Fairness Act, and it requires Internet businesses to collect sales taxes for local and state governments, the same as brick and mortar stores. As it stands now, and until the full Congress passes this or similar legislation, use tax may be due already. Use tax is the sales tax paid by the end user of taxable goods and services. The difference between use tax and sales tax is essentially who remits the tax to the taxing authority. Purchasers must calculate and collect sales tax when the seller doesn't collect it or when taxable goods are taken directly from inventory in the warehouse for internal consumption by a business. Use tax liabilities apply to both businesses and consumers, but I'll focus on businesses and how they might use Sage 300 ERP to automate the payment of use tax.

Can a ...

By Sheila Zhang

Have you noticed the Recognized columns on the Contract Maintenance screen?

It recently came to my attention when I worked on a Crystal Report based on the PJC module. I couldn’t figure out the numbers on any existing analytical report in the module. So, I started researching, based on my understanding of the process in PJC module. After you create and post the Revenue Recognition Worksheet of a contract or a project, some numbers are shown in the Recognized column on Contract Total or Project Total tab. In the backend, if you look at the database, the field "RRCOMPLETE" in table "PMTRAN" (Project Transaction History table) change its value from 1 to 3. Using the 2 fields “COSTREV” and “RRCOMPLETE” in table “PMTRAN”, you can get what the recognized numbers come from.

It seems that the first several projects made perfect sense.  You can see one of them in below image.

However, when I went down to project "1012", I found my assumption really wasn't correct. The ...

By Kristi Feng

Last week, I received an email from a client asking for a custom program that will Ship and Invoice Orders for Sage 300 ERP by selecting a range on order dates.

I immediately thought of our CP00110 OE Ship/Invoice All.

With this component user can select open order by the combination of the following criteria,
• Customer Numbers
• SO Numbers
• Expected Ship Date

Sort by one of the following fields, 
• Customer Number
• Customer Name
• Order Number
• Ship-To ID
• Ship-To Name
• Original Order Amount
• Order Amount Balance
• Expected Ship Date
Click the search button to load the open orders that met the criteria. Select the orders that you want to ship and invoice then click on process button. Then just sit back and wait for the component to ship and invoice the order for you.

This component is very helpful to companies that have a large number of orders and have the need to ship/invoice the orders at the same time for a range of orders.

Check out the CodePartners complete Read More »

By Jacky Xu

Last week, I worked on a big and urgent project scheduled to be completed this Wednesday. But my schedule was delayed by some debug projects. A small problem was that the relevant persons with the big project were not updated promptly. So, I am thinking about how to create a simple task management system: the task list is updated by any new assignment in the system and informs related people.

I searched “SignalR”, which will make this function possible. According to the authority limit, the authorized people will be kept updated about any new added task. Click here for a demo site with SignalR.

By Hrayr Galoyan

I stumbled upon DropBox a couple of years ago and life has never been the same again. OK, that was an exaggeration, but DropBox did make my life easier. I don’t have to think about backing up important files anymore, and it is also very useful for sharing files with clients, colleagues, and friends. It is totally transparent and unobtrusive in use, and platform independent, which is important for me because I am a Mac fan, and most of my colleagues and clients use Windows.

Once installed, DropBox creates a new folder, called, surprisingly enough, “DropBox”. Anything you place in that folder is automatically synchronized with their cloud based storage. It happens in the background, so there is no delay whatsoever in opening and saving files. The files are still local to you. Here is how the DropBox folder looks on my laptop.

I use DropBox to:

1. Backup On-line.
2. Synchronize files between my devices.
3. Share files with clients, colleagues, and friends.

On-line Backup

As I mentioned, any file placed in the DropBox ...

By Emma Tsai

What is SEO? SEO stands for Search Engine Optimization, which is the process of structuring a web page so that it can be found and read by search engines in the most efficient and effective way. It makes your web site more visible to search engines and your audience. 

You may know that WordPress is one of the most popular content management systems available today. In September 2012, it was reported that WordPress powers 1 in 6 websites. I found this article providing some basic tips to help you improve your WordPress site for SEO and the user experience. Click Here to Read the Article, or see below for a quick summary:

1. Remove Some WordPress Defaults
The top item to remove from WordPress sites: the “Hello World” post and “Sample Page”. If the site is still in development, then these elements are OK to have for testing layout and typography. Once the site is live to the public, however, make sure you remove them – you could even delete them from the trash to keep your database ...