By Jacky Xu
Recently we discussed source code version control for ERP projects. Most ERP projects are based on VB6, while other projects use .Net IDE. We wanted to use the same tool to manage the source code. I did some research on Github, but it would not work for us. Yesterday, Joe Zhou sent me a link about how VB6 works with .Net TFS and I did some research. Below are some steps on how to inte...

By Hrayr Galoyan
Recently, I had a chance to work on a customization project on how Sage 300 ERP (Accpac) generates purchase orders from inventory. This gave me an opportunity to investigate in detail how to reorder quantities in the IC module. There are several parameters in Accpac that affect the logic of generating POs.
Let’s have a look at the Reorder Quantities screen first.
...

By Emma Tsai
The Company Duplicator is an application we developed for Sage ERP 300 that allows users to duplicate non-transactional records from the Source Company to the Destination Company without going through a painful manual process of exporting/importing the relevant master file data. You decide which modules to duplicate and then further select records types within each module. Here are s...

By Derek Du
One good thing about JavaScript is the simplicity of working on object property. For example, to traverse all properties of an object:

You may want to use hasOwnProperty () and isPropertyEnumerable to further filter the properties, but it is simple enough.
Also to add or delete a property is just as simple as:
...

By Joe Zhou

Here is a tutorial to use the RSA Protected Configuration provider and the Aspnet_regiis.exe tool to help encrypt connection strings in the Web.Config files of an ASP.NET 2.0 website that is deployed in a Web Farm environment. At run time ASP.NET decrypts encrypted connection strings on the fly. This approach will protect sensitive database connection information such as database user...

By Brian Terrell
Last week, I gave a preliminary price range for a prospective development project. Today, the customer wanted to know if I thought the eventual price would be more likely to fall in the lower, middle or upper end of that range. I resist giving a price range generally, as it always means we do not understand exactly what the proposed project means to either our prospect or to us. ...

By Kristi Feng
Employee Paystub Web Self Service is a simple web application we developed that allows employees to login and check their paystub history.
There are a few steps to setup the component.
Website

• • Run the SQL script against the Accpac Company Database to create the table to store the check images
  • Setup the Web Application on the web server
  &bu...

By Kristi Feng
Recently I had a client that needed to upgrade from Sage CRM 6.2 to Sage CRM 7.1.  Since CRM 7.1.f. supports multiple browsers, I need to make sure that the customization for this client still works in Safari browser on OS X. 
Then I realized, I don't have any machine that runs the OS X operating system. So, how did I do the test?
Luckily for me, there are companies th...

By Jacky Xu
Some sensitive information on web projects, such as database connection strings, are usually saved in unencrypted web.config files. The security of these files is always poor, because if an unauthorized person opens the files, he will see the database log-in info.
Revealing data is a danger to the safety of the database. I found a solution from Microsoft to encrypt web.config files,...

By Hrayr Galoyan
With Internet sales tax legislation looming, many business owners may be wondering how they will handle the additional burden of collecting and reporting sales taxes for all states. Fortunately, technology exists to help; and best of all, much of it is free.
Let me start with a paid option. Avalara is a company based in Washington that provides software to handle sales taxes. In t...