How to Install and Set Up GetX Search for Sage 100 ERP

Installing and setting up GetX Search for Sage 100 ERP is a very straight forward process and can be performed successfully by anyone familiar with typical Sage 100 ERP installation procedures. Allow just 15-20 minutes to complete all the steps.

Prerequisites to installing GetX:

  1. Get administrative access to the server where Sage 100 ERP is installed.
  2. Obtain a network login and password and a Sage 100 ERP login and password. You need both of these logins to set up the indexing engine post-install. Make sure they have passwords that do not change frequently. Also, both logins should have administrative rights.
  3. Ensure your server meets the requirements of Microsoft .NET 2.0 or higher. Most servers current with MS service updates will already satisfy this need.

Instructional Video

Here is an instructional video (4 minutes 47 seconds in length) that shows all the steps needed to install and set up GetX Search for Sage 100 ERP. In case you didn’t know that Sage 100 ERP used to be called both MAS 90 and MAS 200, when the video says “MAS 90,” it means “Sage 100 ERP.”


Keys to a successful installation of GetX:

  1. Download the appropriate version from (It supports Sage 100 ERP Versions 2017 back to 4.5 and the installer will work with Sage 100c, including Standard, Advanced and Premium versions)
  2. Install GetX like any other Sage 100 ERP module. (This must be performed on the Sage 100 ERP server.)
  3. Activate the GetX Module in Company Maintenance for each company for which you wish to perform data searches.
  4. Visit Role Maintenance and make appropriate settings for user role groups.
  5. Visit Modules/GetX /Setup/System Settings. Make any changes to the defaults, as appropriate, and click on “Register” to obtain your initial 30-day free license.
  6. Visit Modules/GetX/Setup/GetX Setup Wizard. Make any changes to the defaults as appropriate.
  7. Browse the ..\MAS90\GX folder and run GetXIndexService.exe. Right-click and select “Run as administrator.” Enter valid network login and password.
  8. Set the timer to indicate how frequently you wish to index data. Run the initial indexing.

Note: The initial indexing may take some time, potentially an hour or more, depending on the size of your database and the caliber of your server. Subsequent indexing will take place silently, behind the scenes by setting up the timer during the installation process.

If, for any reason, you need to remove the software, find instructions for uninstalling GetX here.

We believe that people perform best when they are confident, informed, and have a high level of trust in the tools they use. xkzero builds solutions designed for the best possible user experience, engineered in a flexible way to accommodate the needs of each individual and adaptable to the precise business rules that can vary industry by industry, company by company. If you find us failing to deliver on that, please let us know!

You’re now ready to use GetX and start saving time! Contact us at or 847-416-2009 with any questions!

When You Know What You're Looking For.

GetX – When You Know What You’re Looking For

Sage 100 Scripting Classes: Save the Dates


Save the dates for these two upcoming Sage 100 scripting classes by Alnoor Cassim of xkzero!

  • Basics of Scripting for Sage 100
    2-day class, April 7 and 8
  • Intermediate Scripting for Sage 100
    2-day class, July 23 and 24 (pre-Sage Summit 2016 training)

Early bird alert!
Register for the intermediate class by April 30 to save $300. 
By popular demand, we extended this offer from the original March 1 date.

Email us now to save your spot (and a few hundred bucks)! 

Classes will be held at xkzero’s office, a 10-minute drive from Chicago’s O’Hare International Airport. For your convenience, the Intermediate class is being offered the two days immediately prior to the start of Sage Summit 2016 in Chicago.

Learn from Alnoor Cassim, one of the masters of customizing Sage 100 using Alnoor-LinkedInImageVB scripting. You won’t want to miss these classes.

The cost for each Sage 100 scripting class is $1,199.

Early bird price for Intermediate Scripting class registrations received by April 30, 2016 is $899.

Course registration fees include:

  • 2-day course attendance
  • 40+ page course curriculum
  • 75+ actual scripts of real-life projects
  • Continental breakfast, plus lunch (both days)

Email Santos Rodriguez now at to save your spot!
Space is limited, so contact us right away, and you will be placed into the queue in the order requests are received. A formal invitation with links for official registration and details on payment remittance will follow.

Don’t delay registration. Prior versions of these classes have sold out quickly.

We hope to see you at one or both of Alnoor’s scripting classes!

About Basics of Scripting for Sage 100 Class

The basic level Sage 100 scripting class will be a 2-day, fairly intense on-premise instructor-led classroom training at xkzero’s Chicago training facility. On Day 1, from the morning through lunchtime, Alnoor will lead a review and discussion of scripting concepts, and provide an overview of Sage 100 business objects, and an explanation of the ways Custom Office plays a major role in User-Defined Scripting. After lunch on Day 1, and all of Day 2, participants will have a heavy hands-on experience, with the vast majority of time spent working on labs and activities based on real-life Sage 100 scripting projects. Take-home materials included with the course: 40+ page curriculum, scripting reference guide, and 60+ actual scripts from real-life projects.

About Intermediate Scripting for Sage 100 Class

The intermediate-level Sage 100 scripting class will be a 2-day intense on-premise instructor-led classroom training at xzkero’s Chicago training facility. We have scheduled this class to accommodate those attending Sage Summit 2016 in Chicago, which begins July 25. This is a follow-up class that continues where the basics-level lessons left off. We will emphasize advanced concepts and user-interface (UI) scripts. It is designed for those who have been designing scripts for clients or for their own company projects, and now want to take scripting to the next level. Like the basics class, the majority of time will be spent working on labs and activities. Take-home materials included with the course: 40+ page curriculum, scripting reference guide, and 75+ actual scripts from real-life projects.

Prerequisite: Attendance of the Sage 100 Basics of Scripting course or permission from the instructor.

Early bird alert! Register for Intermediate Scripting by April 30 to save $300. Email us now to save your spot! 





A new fountain of youth (Webinar)


“Like a kid on Christmas morning I tried it last night.  This solves everything I didn’t like about Sage 100″

Sage 100 discovers the fountain of youth?

Sage 100 discovers the fountain of youth?

Whether you’re old enough to remember navigating the internet before Google and Yahoo or not, you’re certainly young enough to imagine how much better Sage 100 could be with the power of total search-ability.

That time is now.

xkzero cordially invites you to join us to learn how one simple add-on to Sage 100 will change the experience for every single user, forever.

Search virtually everything and anything – across companies and across modules – using words, numbers, phrases, combinations, wildcards, date ranges, right within Sage 100. Click and browse straight to what you’re looking for.

Guaranteed to improve customer service, resolve disputes, improve workflow – and reduce training costs.

Who benefits most? Those who use it most.  REGISTER FOR THE WEBINAR NOW

GetX – Universal search for Sage 100 by xkzero installs in 15 minutes, works with versions 2016 back to version 4.5, and won’t break any customizations. GetX even searches User Defined Fields (UDFs), Extended Item Descriptions, transaction details lines, Memos and much much more.

Controllers love it. AP clerks love it. Receptionists love it. Executives love it. Sales reps love it. Managers love it. Operations love it. Newbies love it. Power users love it.

Join our webinar Wednesday March 2 at 11 am CST to see for yourself – and to learn how to claim your FREE 30-day, no obligation trial copy of GetX by xkzero. It’s the single most powerful button in Sage 100. Ever.

Register now – space is limited and filling up fast!



Former Sage Mobile Sales Specialist Joins xkzero

reposted for original publication via PR Web


Mobile sales app developer xkzero today announced the addition of Karen Foreman as mobile sales specialist. Foreman comes to xkzero from Sage where she served in a similar capacity selling Sage Mobile Solutions and CRM.  Karen Foreman

“We are very fortunate to have Karen join our team,” xkzero co-founder, Paul Ziliak said. “Her knowledge of the Sage channel and understanding of the unique needs of Sage customers alone brings us great value, but what really sets Karen apart is her passion for mobile as the next generation technology for business. xkzero continues to invest in its products to help small and mid-sized distributors and manufacturers grow. Adding Karen to our team will only accelerate the number of companies benefiting from the larger orders, new revenue streams and reduced administrative burden delivered through mobile.”

Regarding her decision to join xkzero, Foreman expressed enthusiasm about the company’s offerings. She said, “xkzero continues to make major investments in the evolution of its products. iSales 100 provides advanced mobile selling capabilities that can not only satisfy very unique requirements, but it is also incredibly easy to set up and use. xkzero Mobile Commerce (XMC) offers enterprise caliber functionality out-of-the box for companies using Direct Store Delivery (DSD), and Route Selling as a business growth strategy. Food and beverage producers and distributors are a natural fit for XMC, and its pre-built integrations to Sage 100 and Sage X3 create significant business advantages for growing companies.”

About xkzero:

xkzero specializes in mobile sales, route sales and direct store delivery automation for small and mid-sized manufacturers and wholesale distribution companies.  xkzero is also a certified developer for Sage X3, Sage 100 and Sage 500, creating integrated and embedded mobile solutions into some of North America’s most popular and powerful ERP and accounting systems for the mid-market.

For more information about xkzero or to contact Karen, please visit our website, email us at, or call 847-416-2009.

Apollo Oil Selects xkzero for New Direct Store Delivery Mobile Software

Apollo Oil

xkzero is pleased to announce that major automotive lubricant distributor, Apollo Oil, has selected xkzero Mobile Commerce software to automate its distribution processes for Direct Store Delivery and Route Sales.

Click here for full press release

Apollo Oil, headquartered in Henderson, Kentucky, sells and distributes major brands such as Valvoline, Shell and Castorl throughout the Ohio Valley to car dealerships, quick lubes and automotive service centers.  From their fleet of over 30 trucks, and from multiple warehouses, they also sell and service municipalities, trucking facilities and farming operations, as well as to industrial manufacturers.

In tandem with this project, Apollo is also implementing Sage X3, purchased from leading Sage North American business partner, WAC Consulting.

“Together with Apollo we began evaluating xkzero at Sage Summit 2015 in New Orleans, as an initiative to replace the existing custom built mobile solution”, said Steve Schaefer, Partner of WAC. “XMC will be relied upon to satisfy mission critical processes such as truck loading for both bulk and packaged orders, route selling and direct store delivery automation. Apollo also expects to create improved workflow and accounting for inventory control, route planning and payment handling.”

“Apollo was searching for a system to allow anytime, anywhere processing to better serve our customers with each and every interaction”, said Ed Dotson, Chief Financial Officer of Apollo Oil. “We discovered xkzero at Sage Summit 2015 in New Orleans and their combination of modern mobile technology along with their expertise as Sage X3 developers gives us a very high level of confidence for this project.”

For more information about xkzero Mobile Commerce and direct store delivery and route sales automation, please visit our website or contact us at or 847-416-2009.


Sage Mobile Sales Retirement Announcement and xkzero Promotion



Often in life just as one door closes, another one opens.

With the announcement of the retirement of Sage Mobile Sales  xkzero is happy to offer a special promotion exclusively for Sage 100 businesses.

There is no mobile sales app on the market today that is as easy to install and use that will meet the exact needs of your distribution or manufacturing sales team, than iSales 100.  In fact, we believe that iSales is the most powerful, flexible – useful – mobile sales app for mid-sized and growing small businesses.

Selling from a Trade Show, the showroom floor, or a customer location?  You’ll love how quickly and easily iSales will produce powerful results and have you standing out from the competition.

For those of you who purchased Sage Mobile Sales, we have special savings for you: switch to iSales 100 – Advanced Mobile Sales for Sage 100  between now and January 31, 2016 and receive these additional incentives:

        • 10% off the initial purchase price of iSales 100
        • Plus, a 30 day full money back guarantee!

Here are some of the feature benefits of iSales (feature set varies depending on Edition purchased):

Transaction Processing – Create the Ideal User Experience

  • Process new sales orders, quotes, invoices and credit memos
  • Transaction restrictions by user
  • Add new customers and contacts on the fly
  • Signature capture
  • Receipt printing and emailing
  • Create Sales Order Memos
  • Edit ‘Bill to’, ‘Ship to’, ‘Ship Via’ during transaction entry
  • Reprint open orders and invoices
  • Select multiple items at once for rapid data entry
  • Lot / serial number support
  • Barcode scanning (also supports Alias item numbers)
  • LTL freight calculation
  • Sales tax calculation
  • And more!

Pocket Intelligence:

  • View open sales orders
  • View open invoices
  • View customer memos
  • Item Quantity On Hand, On Sales Order, On Purchase Order, Available
  • Hide / display price – cost – quantity options
  • Customer last purchase history by item
  • Select one or several or all warehouse codes for access

Smart Device Productivity:

  • Spanish language enabled
  • View inventory images from Sage 100 item masterfile
  • Hot lists (favorites)
  • Alert badges for new customers, contacts and items
  • Refined, easy to use data management
  • Phone, email, map, calendar integration


  • Native iOS (Apple mobile devices – iPhone, iPad, iPod Touch
  • Exclusive / native integration to Sage 100
  • Offline synchronization via xkzero Web Services
  • iOS 7 and up
  • Sage 100 version 4.5 and up (2016 coming soon!)


  • Unlimited Device License pricing model
  • Unlimited Users – Unlimited Companies
  • Pricing based on choice of three versions – Inquiry Edition – Business Edition – Enterprise Edition
  • Private label option – enhanced modern B2B sales app

Try before you buy:

We might not be able to solve every mobile sales need with iSales 100, but we’ve built it in a way that let’s us satisfy most.  Care to try it before you buy it?  Just visit our website from your iPhone or iPad at and click on Download.

You’ll be redirected to the Apple App store where you can download the app, log in using the User: demo and Password: password.

Synchronize the data and give it a whirl.

Then if you have questions, contact us at or call 847-416-2009 and we’ll answer all of your questions and provide you a demo of the back end.

More iSales 100 resources here.

iSales for Sage 100: Try it before you buy it!

iSales for Sage 100: Try it before you buy it!



iSales 100 Resources for Mobile Distributor Sales Automation


Advanced Mobile Sales Apps for Distribution – Resource Guide

This resource page is designed to provide you a one-stop location to learn how to use iSales 100 (advanced mobile sales automation for distributor needs) to not only improve customer service and establish your distribution business as the most modern in your industry, but also to grow your business and your profits.

A great mobile sales solution starts when you and your team are confident that your solution will 1) meet and exceed your business objectives 2) create a great user and customer experience and 3) provide a high level of reliability and supportability.

Need additional resources or looking for more information on how iSales 100 can help your business?  Contact us at, call 847-416-2009 or visit

Useful iSales 100 (Advanced Mobile Sales for Sage 100) Resources:

Need additional resources or looking for more information on how iSales 100 can help your business?  Contact us at, call 847-416-2009 or visit

iSales 100

Create and maintain receipt formats: iSales for Sage 100



Now with iSales 100 version 4.1 individual receipt formats can be created for each Sage 100 company / user / and transaction type.  HTML skills are required, and we’ve documented here what you’ll need to know to self serve this feature.

The HTML is on the Sage 100 server and can be edited by anyone with basic HTML knowledge.   Upon request, xkzero can do this for a fee (contact us at

We designed the receipt as an HTML file and use standard web technology to create the page, allowing the form to be previewed in a web browser. We use a template engine, which allows us to merge the data from the transaction into the page. It’s called Mustache – because the variables are bracketed with {{ and }} so they look like mustaches.

The HTML form is found on the Sage 100 server at:


Individual receipts may be setup for each specific Sage 100 company as well as specific Remote User (within a company).  This can be done by adding directories under ‘Content’.  For example, to add a receipt just for ABC company it would be:


And for Remote User ‘JEFF123’ in XYZ Company: 


In addition, in the 4.1.0 version we added the ability to setup different receipts for other transaction type. This is done by making an HTML file named by the transaction type as follows:

  • QuoteReceipt.hmtl
  • InvoiceReceipt.html
  • CreditMemoReceipt.html

Below is a list of Variables (labeled ‘MustacheVariables’) that are available. There are 2 parts of the page. There is the main page level and then there is the line level. The template will hit the line level and repeat the section for every line. So, in the variables file there are Line specific data elements.

In the file there are indented sections under Customer. This is a sub section. So, for each order we can get to the Customer information using ‘dot’ notation. For example:


Similar for Item information in the lines section.

Any information not in the list of variables is not available. So, UDF’s that are not one of the 8 UDF’s on Customers and Items (setup in Remote User Maint) are not available.


- Because it’s basically a web page, it is one big page without breaks. We are investigating ways to make it print like a standard form where the header will print at top of every page and a

footer at the bottom. But, for the time being it simply breaks wherever the page ends and continues printing on the next page.


  Customer {
  Lines[] {
    Item {
    Warehouse {

Any questions or comments?  Customers current on xkzero maintenance and support plans should contact us at



More iSales 100 resources from xkzero.







iSales (mobile sales) for Sage 100 and iOS 9



Apple will be depositing iOS 9 onto your iPhone and iPad any day (any hour?) now, so you should know that xkzero has you covered – iSales 100 is compatible with iOS 9.  But in order to be compatible with iOS 9 you’ll need to download and install the newly released version 4.1 from the Apple app store.

iOS 9 is filled with great new features, so we figured we’d add some great new features to iSales 100 too.  Read about our new release here!

In order to take advantage of the new features in iSales 100 version 4.1 please contact your xkzero account executive at for details about installing the necessary components on your back end Sage 100 server.

To learn more about iSales 100 and the benefit of mobilizing your salesforce, please visit our website or contact us at 847-416-2009.


Great new operating system from Apple, and great new features from xkzero too!

Great new operating system from Apple, and great new features from xkzero too!



Choosing the right mobile sales app for your business

Empowering sales and customer service teams with mobile-ability straight from your ERP/accounting system can have a powerful impact on your business. Not only can it increase revenue, but benefit the bottom line in other ways, too–like reducing labor costs and eliminating redundant data entry.  Distributor sales rep

Mobile selling also can provide a new means of intelligence gathering, making your people more confident, and more engaging.

But because everyone’s needs are not the same, choosing the right solution for your business is really important, but luckily, not complicated.

Whatever your needs are, these are some important things to keep in mind:

  • A great mobile solution starts with a vision. Get the mobile conversation started with your most free thinking people.  And be open to ideas come from anyone in your organization.  Everyone and anyone on your team might be sitting on a billion dollar idea.
  • Identify the business processes that require change.  Mobilizing your workforce is good old fashioned business process reengineering.
  • Articulate expected benefits. What financial and behavioral impacts do you seek from mobile?  If you don’t have a profit motive, why would you do it?
  • Evaluate customized and pre-existing packaged solutions to determine which will work best.  Then ask yourself if what you really need is a custom app, because you want to separate your company from any competitor, and a packaged app could be done by anyone.
  • Determine the optimal level of integration with your accounting/ERP/CRM system. Don’t overlook the fact that security is an important matter here, and that can vary user-by-user, role-by-role within your company.
  • Select a mobile platform after choosing a solution. The real value is not a matter of Android versus Apple. Remember that the real value is in the experience you create for salespeople and customers, and the processes you transform.  The phone itself is usually the commodity – if not – what you created has not much value beyond the price of the device.

Consider the greater impact of mobile. Mobile allows for a significant number of changes that can have a transformative effect on your business.  It will even change the way your customers look at you.

The video below is a recording of a recent webinar we presented.  It is geared for small and mid-sized distribution and manufacturing companies who use Sage 100 software to run their businesses.  It also contains nuggets that are useful regardless of your back-end system of choice.

It includes descriptions of some key differences between Sage Mobile Sales and these two packaged solutions published by xkzero:

Also, there is a feature comparison beginning at 23:38.

[51 min 58 sec]

Would you like to talk mobile strategy for your distribution business?  At xkzero we’d love to hear from you. or 847-416-2009.