Joe Noll Blog Post New Home

I am writing this to inform you that I am now posting at a new locaiton. My new location is

Please make this change to follow me at this new location.

Windows Server 2008 High Performance vs Balanced Setting

You can see in the Specification area below that the system contains a 2.70 GHz processor yet the Core Speed area shows that the system is actually running at 798.3 MHz. How can that be you may ask? Well that is what I continue to see repeatedly when logging in to systems when I am asked to review some performance issues.

I am not saying this is the only issue but fixing this issue alone has solved quite a few of the reported issues, especially when I hear that my system is fast for a while then it slows down after several days or so. The tool shown above is called CPU-Z from CPUID. There are other tools that you can use. I am just a fan of this one. It is free and very small.

So now let’s go look at where this is configured. I am doing the changes below in Windows Server 2008. This is in Windows Server Power Options.

Go to Control Panel-System and Security-Power Options

Make sure the setting has High Performance selected

If the above setting was balanced it will adjust the Core Speed down based on average use to save on power and energy. Once it settles in on a number for Balanced it will not speed up again to full speed until you do a reboot. This is true in a virtual server as well.

In addition to the Windows Server 2008 your physical systems also contain BIOS settings as well to allow you to configure the system to run balanced or optimized as well. Please consult your hardware documentation for more information on CPU Throttling.

These terms are a little misleading in my mind as I think this means efficiently in terms of power consumption. I understand why these settings are important to save energy but if the purpose of your system is to be a high performance system then this setting defeats the purpose.

14 Days of Sage ERP X3 – Day 13 of 14 – Commissions in Sage ERP X3

The reason I picked this topic was it was an area we need some additional clarification on. So we compiled some information. Before I begin, I need to thank Tom, from the Sage ERP X3 team for his valuable input that I used as a baseline for this post.

The Commissions are not presented in the documentation, as there are many ways to configure them.  If you want to link specific products with specific reps, and, specific customers then Price books will be the best way to manage this. Sage ERP X3, at a basic level, will assign a commission at time of sales order based upon rep assignment to the line ordered.  For example, if no rep is referenced, then, no commission is calculated.  Also, the sales rep must be referenced on the ship-to customer address for the default to occur at the line during sales order entry.


Set up a sales rep with the commission factors:


The customer must also have commission set up:



Optional Price book with Commission factor over-ride:


Sales order entry:


There are many additional configuration and variations way too many to cover here… remember to start with this from the simplistic level and work your way up to the complex, the complex level being managed with price book definitions. I will try to make a more complex sample in a future post.

14 Days of Sage ERP X3 – Day 9 of 14 – How to Add a Custom Report in Sage ERP X3

Most times clients do not use the AP Check format that is delivered with Sage ERP X3. So for this example I am going to be creating a custom version of AP Checks. We will be starting with the base format and just making a copy of it to use instead of starting from scratch.

  1. Go to Development -> Processes -> Reports
  2. Pull up an existing report code (e.g. XBCHECKS)
  3. Add a “Z” in front of the report code to indicate it is a customer changed report
  4. Change the Crystal Report Name to reference ZXBCHECKS

  5. Click on the Parameters tab and change any references to the old report name

  6. Click the Create button to save the new report code
  7. Go to Parameters -> Destinations -> Print Codes
  8. Sort the list by Print Code and check through the list to see if the report you are copying exists
  9. If the report exists, insert a new line in the grid referencing the new print code

  10. Click Save to save your changes for the new report
  11. Go to Parameters -> Destinations -> Default Values
  12. Search through the list on Report Code for the existing report
  13. Pull up the entry for the existing report
  14. Select the contents of the grid and copy/paste them into Excel
  15. Add a “Z” in front of the reports field to reference the newly created report
  16. Add the default values by copying and pasting from Excel into the grid (each field individually)

  17. Once the parameter defaults match, click the Create button
  18. In windows explorer, make a copy of the existing crystal report file and rename it with a Z in front


  19. To have a report specific to an individual folder, create it in PILOT or PROD respectively. Otherwise the individual folders use the report from the X3 reference folder.


  20. In X3, go to Reports -> Reports and select the newly created report code, enter the parameters and click the Print button to run the new report

  21. Make any needed changes in Crystal Designer to the Z form.



Why I purchased the NOOK Color…Adventures in configuring!

I want to say that I put a lot of thought and preparation into purchasing the NOOK Color. I also have to say that I did not purchase this for myself. It was a purchase for my wife for her birthday. I also had some discussion with a colleague about some of the details as well. He has one and we were able to do some brief testing on some things I wanted to make sure would work.

So why did I select the NOOK Color? Well my wife already has a Kindle. She has had it for a couple of years, so it is one of the early models. She really liked it but was looking for something that could do more. Her list of requirements was not large but they were very specific. I must add that a data plan was not part of the consideration. We felt that Wi-Fi would be sufficient.

  • Ability to read books, magazines, etc
  • Lightweight
  • Small to be able to carry in a travel bag
  • Able to hold a charge for a long flight
  • Ability to browse the Internet
  • Ability to send and receive email
  • Affordable
  • Ability to copy files to and from the device via her laptop
  • Ability to play movies during travel (FYI, this was the tough part)

I have had the luxury of experimenting with the Apple iPad, Motorola Zoom, and BlackBerry Playbook. I even got a peak at the Galaxy TAB. Some of these are able to meet the needs above but the price points kept them off the list. The other concern with the Apple iPad we discovered in our experimentation was that these were not easy to read if you were in the sunlight or wearing UV sunglasses.

I wanted to make sure that we could address the last bullet item on the list. So I did some research online. I found plenty of information on the fact that it could play movies, however following the discussion lists I had my concerns. Everyone was talking about the fact that they were not able to make it work after the purchase. I decided to call Barnes and Nobles. I was able to get straight through. The person on the phone was very pleasant but unsure of the answer. They put me on hold briefly. While I was on hold I also submitted the same question to the Barnes and Noble online support email. Just as I finished typing and hit submit, the support person came back on the phone. They said yes this is supported and here is the list of supported file types.

  • Nook Color can only play these video formats: 3GP, 3G2, MP4, M4V, and OGG and supports MPEG-4 Simple Profile up to 854×480, H.263 up to 352×288, and H.264 Baseline profile up to 854×480.

About 30 minutes later I received an email from support and they basically gave me the same list. So I reached out to my colleague with this new found information to see if we could experiment on his NOOK Color. We were able to get this to work with a movie he owned after getting a utility to convert the movie to one of the above formats. We used MP4, more on that later.

Finally, I made the purchase at our local Barnes and Noble store. I did this just to confirm once more with the store that this would be easy to configure for movies, plus if my wife has any questions, etc she could take it back in to them.

I decided to read the 3 pages of full instructions. Yes I sometimes avoid this step but I figured I could handle 3 pages. The first step was to do a full charge. Once that was completed it was basically turn on the device and walk through a few steps. The device also comes with a help system and some training videos. I left these videos for my wife since she was actually going to use the device.

I worked down through the configuration and meeting the list of requirements was pretty easy up to that point. So I have it connected to our in home Wi-Fi. I configure it for to attach to her email account using POP. I browse the internet and purchased a book on Barnes and Noble as well as connected to one of her magazine subscriptions. I also connected it her laptop and was able to copy over a PDF file, some pictures, music and an MP4 video file. Then I went to the NOOK and what do you know it was all working. Feeling good!

Now on to tackling the item I had a concern with, loading movies. This was easy for the existing MP4 video that I had tested earlier. Now I wanted to take a couple of movies that my wife owns and put them on the NOOK for her to watch during travel. We were also looking to possible rent a movie and put this on the NOOK as well. No, this is not as easy as copying or renting a movie on the laptop, then drag and drop onto the NOOK. In fact the renting of movies I have still not been able to conquer.

I want to say that I am not endorsing any of these products other than stating that I have used them successfully in my implementation.

My wife took her NOOK on a trip. She read magazines, a book and watched a movie on the plane. She arrived at the hotel and was able to quickly attach to the FREE Wi-Fi to surf the internet and do email. The only issue over a few days at the hotel was a popup in the browser while surfing that would not clear. I found the exact issue at Web Browser Frozen on Nook Color response number 2 and it fixed it right up.

In a future blog I will be discussing one of the other cool features of the NOOK the add-on Memory. These allow you to do many things, one of which is to install another boot operating system such as Honeycomb.

Sage ERP X3 – Global Announcement Introducing v6.2

Today was the official release of Sage ERP X3. With thousands of users attending the official kick-off, the Sage leaders went into detail related to this new product version. The

Announcing Sage ERP X3 v6.2 with its 300+ enhancements, some of the more important items that they covered during this session include:

  • Sage Webtop via the Dashboard Intelligence
  • X3 Standard Edition with 130+ pre-built Visual Processes
  • Connected Services: a few examples include Sage Payment Services, Avalara Sales Tax, and Worldship
  • Enhanced Web Services
  • Job Cost and Project Accounting module to provide a solution for Service industry solution
  • Follow the sun 24 x 5 support services available
  • Microsoft Office 2010 integration
  • Polish and Russian legislation added

ISV Partner announcements

  • Talend : providing an integrated ETL application (data exchange)
  • VersionOne : Providing a high end integrated EDM solution
  • Vertigo : Carbon footprint evaluations

Some Sage ERP X3 Standard Edition information

  • Streamlined implementation methodology
  • 60+ KPIs
  • 300 pre-built Queries
  • 130+ pre-built Visual Processes
  • 440+ reports to assist in best practices
  • Ability to upgrade to Premium Edition “in a flash”

Vertical Industry focus for Sage ERP X3 by creating bundled Edition solutions starting with the following…

  • Discrete Manufacturing Edition
  • Process Manufacturing Edition
  • Distribution Edition
  • Services Edition

To find out more about this product you can visit and as well twitter #sageerp and #sageerpx3.

What’s next they are working Emerald and Jade. These are the next 2 version’s already in design and development mode. Stay tuned…

The creation of ePortal for MAS 500

I have been asked several hundred times over the last 3 years, in various ways, as to what was the background of ePortal for MAS 500. It’s initial intent was to serve as a much more dynamic and robust B2B and salesperson interface than the legacy eCustomer and eSalesforce modules for Sage ERP MAS 500. This was accomplished rather easily and it has morphed into quite a bit more.

The ePortal for MAS 500 framework is built using the Microsoft .NET 3.5 SP1 tool set. It consists of 3 components. They include the following.
ePortal for MAS 500 – This is the user interface. This is ASP.NET and JavaScript.
MAS 500 WS – This layer is comprised of Web Services and WCF Services. This layer is serves as the interface with the MAS 500 database and the UI (ePortal for MAS 500). For those wishing to create their own or just use their existing UI they can just purchase the MAS 500 WS without the ePortal for MAS 500.
SQL Components – The application does not alter any base tables, views or stored procedures of the base Sage ERP MAS 500 solution, but it does have some objects of its own.

The first year we spent finding our way with the product. The initial installations were solely to our customer base to meet their unique requirements that were just no longer possible with the legacy modules. We have continued to add functionality, expand our install based and tweak the functionality based on your feedback.

This has proven to be a success for both RKL and our clients. It is always nice to create something that is extremely flexible but it always creates some anxiety at times while everyone gets acclimated to the product. Thank you to the RKL Team for all the effort spent working on this product vision and to the Sage Partners and Customers who have been adopters of this new interface. We appreciate your business.

%d bloggers like this: