LinkedIn Twitter
Share some Innovation
"Innovative Thinking" A Newsletter from Innovative IT Consulting In This Issue

June 2012

Innovative IT Consulting is one of the only consulting companies dedicated to Sage ERP X3. Read our lead story to understand the value of working with a consulting company.

In the expert's corner John Pellegrino helps you validate your data in this month's tip column, "The Long and Short of It - Data Type "ADI".

On the blog front, check out Paul's latest post on the Sage ERP Business Management Blog - on the increasing complexity of many "small businesses".

Sage Summit - Update - Registiration is now open. Don't forget to register for Sage Summit. There are sessions for everyone, and gaining insight into the direction of Sage is critical to every X3 user. Sage Summit is the best way for you to gain insight into product direction, strategy and talk directly with Sage execs. Look for the specifics regarding the meeting of our Sage ERP X3 Linked In Group for further details. Click HERE to see what all the excitement is about.

By Paul Sita, Principal, Innovative IT Consulting, LLC. Paul can be reached at 631-549-1685 or

Sales first, everything else second. Sage acquired the X3 product from Adonix and has invested heavily in developing X3 as its flagship, global ERP System. Part of that investment is the development of a sales channel of qualified partners who can help Sage gain ROI on that investment In X3. Sage is after all a for profit, public corporation. However, Sage derives revenue from customers only when they purchase licenses, and support. And while most of the Sage Reselling partners claim to be consulting companies, they are under pressure to implement systems and "move on" to the next customer. They are implementers of X3. They neither have the skills, nor the people to deliver a comprehensive consultative process.. This goes against the strategic nature of the X3 ERP System.

Innovative is a consulting company first and foremost. Innovative is certified in Sage ERP X3. But our heritage is as a consulting company. No customer is locked into doing business with us because of support contracts or license registrations. Our value proposition is based on our ability to add value to our customers, pure and simple.

The Consultative Approach The Consultative Approach starts with our first conversation, and continues throughout our relationship. We are always looking for ways to make our customers more successful. Very frequently this means we act as an extension of their strategic IT staff - helping them plan, organize, structure and execute a series of projects and initiatives that revolve around X3 but are not limited to X3. We look for the best solutions to our customers needs, not just the best Sage sold solutions.

Strategy, Planning and Execution. Our belief is that in the mid market, most customers are limited by not enough time to develop Sound Strategy, Plan that strategy and then Execute that strategy through well planned and managed initiatives. Innovative brings those skills to every customer engagement, regardless of how big or small. We believe that X3 is a strategic platform for customers, and that customers need a strategic partner to help them be successful with X3. Innovative IT Consulting is that partner.

By John Pellegrino, Principal, Innovative IT Consulting, LLC. John can be reached at 631-549-1685 or

What's your type? For those of you that work with the personalization tools with Sage ERP X3 you are aware that you can associate actions with data types you create. This allows you to affect the behavior of a field through coding without having to write the code every time you add a field that requires that behavior. Of course, many of these data types are supplied with the X3 system. One of these data types – “ADI” for miscellaneous table set-up - I have found to be a very easy way to add a custom field that requires edit-checking against a list of valid entries.

It’s as easy as 1 – 2 - 3. Setting this up is a 3-step process. First, you need to create a miscellaneous table to store the list of valid entries. In order to stay out of the way of any standard miscellaneous tables I always use table number 6000 or higher. I try to keep the code at the standard 3 characters and you can have a long description of 30 characters as well as a short description of 12 characters. Second, add a field to the appropriate table to store the code. This can be an alphanumeric data type of length 3. Third, add the field to the appropriate screen, this time using the ADI data type. Set the Tunnel column to “Yes” and choose either “Long” or “Short” in the Link column, which will display the long or short description next to the entry field.

3 is the magic number I include for reference, 3 items to note. One, when you select ADI as the data type in the screen the system will automatically ask for the table number. Two, if you are short on space in the screen you can select the “Short” description, but if you have space the “Long” description is preferred. Three, as a reminder, don’t forget to validate the table and the screen after you make the changes.

"What Innovative IT brings to the X3 marketplace." (2 words)

O T A S V E L N C U I T   P C R H P A O A

_ _ _ _ _ _ _ _ _ _ _ _   _ _ _ _ _ _ _ _

Answer to last month's word scramle.

"The X3 version that starts with a clean slate. (2 words)." (PREMIUM EDITION)

Summer is coming. Enjoy the summer and see us at SAGE SUMMIT! Stay tuned for more information on recent development with Sage ERP X3, and Innovative's expanding practice. Keep your comments and suggestions coming in. We love to hear from you ! Please keep checking the INNOVATIVE WEB SITE for useful tips, and our newsletter archives.

The Innovative Approach to Sage ERP X3. Blending X3 Expertise with the Consulting Process.

X3 eXpert's Corner. The Long and Short of It. - - Data Type "ADI".

Word scramble.


Innovative Ideas
in your Inbox

If you would like to receive Innovative Ideas as an Email Newsletter, please sign up here: