How to Color Code Companies in Sage 300 ERP (Accpac)

Posted by Mark Badran on Tue, Feb 26, 2013

Expected for availability in late February 2013, Sage 300 ERP 2012 Product Update 1 (PU1) will include enhancements to Sage CRM, Intelligence Reporting, and Payroll. But one useful new feature that will perhaps fly under the radar is the ability to color code different companies in Sage 300 ERP .

Why Color Code?

Before we talk about how, let's talk about why.  The ability to color code will come in handy for Sage 300 ERP customers that have data stored in multiple databases.  In those cases, it's possible to have multiple screens for multiple companies open at the same time. It's also easier to accidentally post transactions to Company A when they should have been posted to Company B.  That's where color coded companies comes into play.

How to Color Code

The new option to configure company colors will be found in Database Setup. The list of companies displayed will now include a "color" column with the option to automatically assign default colors to all of your companies.  If you don’t like the defaults and prefer to assign a specific color to each company, you could manually edit the individual company color profile in the Edit SQL Server Database Profile task. When finished, your various company windows will be easy to distinguish and look something like this (below):

Sage 300 ERP Color Code Companies

Need help figuring it all out?  Be sure to contact us with any questions about upgrading, updating, or anything in between!

Get the Whole Scoop

This post is an article that appeared in our Sage 300 ERP newsletter for 1st Quarter - 2013. To download or view the full newsletter, click the thumbnail image below:

Sage 300 ERP Newsletter - Q1 2013

Related Articles

Other Sage 300 ERP newsletter articles you might be interested in:

Sage 300 ERP Version 2012 Gets a Little Smarter

Sage 300 ERP News & Updates

Working with File Attachments in Sage CRM

A Quick Message to Sage CRM Customers

Topics: Sage 300 Tips & Tricks

Submit a Comment

Need Help Now?

Request a Call