Sage 100 2018 Product Update 4 (

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2018.4
For a full list of Enhancements, refer to the What's New page inside the Product.

Product updates are cumulative; in other words, this update includes all enhancements and program corrections found in prior updates for version 2018. Smart Update will install only the programs that have been updated since your last update was installed.

Workstation Synchronization has been enhanced to update Sage 100 Standard Workstations along with Sage 100 Advanced and Premium Workstations. Sage 100 Standard Users are no longer required to run WksUpdate Standard.exe on each Sage 100 Standard Workstation. 

All Sage 100 updates must be installed on the server where Sage 100 is installed.

For eBusiness Manager users upgrading for the first time to Product Update 3 or higher, you will need to perform the following one time:
  1. From the Sage 100 Server, copy the following files located in the ..\MAS90\Home folder:
    1. pvxclr4.dll
    2. Sage.Exchange.dll
    3. wsVault.dll
  2. Copy the 3 files above to the server where the Sage 100 Web Engine is installed. The default location for the Sage 100 Web Engine installation is "C:\Program Files (x86)\Sage\Sage 100 20XX WebEngine\WEBENG\Home\", but this is configurable.
  3. Restart the Web Engine and run as an application. Running the Web Engine as a Service is not recommended at this time. See Knowledge Base entries 82537 and 82539 for more information. Make a copy of any existing files before replacing.

Accounts Receivable

  1. Memos are no longer displayed in Customer Inquiry & Customer Maintenance when Memo Options is set to Hide and Auto Display is not checked in AR Memo Manager Maintenance for Customer Memo Type.
  2. "Error 15 AR_CustomerListingBal_rpt.pvc 572" no longer occurs when running AR Customer Listing with Balance report.
  3. Sage 100 Support added for EMV Credit Card Chip Processing using an Ingenico iPP320 or Equinox L5300 device.

Bar Code

  1. An updated SetupConnectIt64.exe is being installed to the Sage 100 Server's ..\mas90\wksetup\Prerequisites\Scanco folder.
  2. Mobility for Bar Code Enhancement, import batching can now be controlled by a batch comment from the hand held device.

Bill of Materials

  1. ***Invalid Bill*** no longer prints on Summarized Bill of Materials Report for Option Bills with a component that is also a Bill of Material.

Job Cost

  1. The address on the Job Cost Billing Invoice now prints the address from AR Customer.
  2. Error "A General Ledger Account is missing for a division number: xx" no longer occurs when posting Retention in Job Billing and "Track Job Cost Retention Receivables" is unchecked in AR Options.
  3. "JC_ConvertToFramework:000000:000 - Error #1: Logical END-OF-RECORD reached, File: JC_JobMemo.m4t" no longer occurs during conversion.
  4. Multiple J/C Reports Job to Date amount is now accurate.
  5. There is a new Cost Type Mapping Utility to map invalid cost types to valid values. The new utility can be launched from File > Run > *UTL.
  6. Actual % Complete entered in Job Billing Data Entry now prints correctly on Job Billing Invoice.
  7. No longer receive error "The Cost Code Format is Invalid", when creating Alphanumeric Cost Code less than 9 characters.
  8. Customer Address no longer populates Job Address field in Job Maintenance when creating a new job and then selecting the Customer No.
  9. Billable Contract amount no longer changes when Retention amount is changed in Job Billing Data Entry.
  10. Job Status Maintenance settings are no longer ignored and do not prevent posting.
  11. Job description and job address are now carried over from the estimate when using Estimate Update to Jobs.
  12. When updating the Time Track Register from Job Cost, Time Track History is no longer overwritten if the exact same Employee, Date Worked and Sequence Number are used again in Time Track Entry.
    NOTE: This defect only fixes the Time Track Register when it is updated from Job Cost, where Time Track is only enabled in Job Cost Options. If Time Track is enabled in BOTH Job Cost And Payroll Options then you must also install PR 2.18.4 in order to fix both updates. (PR update was fixed in 2.18.4, Defect# 109771)
  13. Job Billing Data Entry for Time and Material jobs now includes the Item Code in the Description for transactions originating from Inventory.

Library Master

  1. Error 55 SY_LineEntry_ui.pvc 778 no longer occurs after creating a valid routine for a new field added to payroll.
  2. ALE Full Text search now returns results as expected in Sage 100.
  3. Error 65 SY_TASKLAUNCHER.M4P 0382 no longer occurs when running Journal/Registers task from Task Scheduler.
  4. Auto complete search now returns expected results in Sage 100.
  5. Records are now being written out to PR_EmployeePIIWRK correctly.

Paperless Office

  1. The Same e-mail Subject header text, such as the same <CustomerName> merge field, is no longer received by multiple recipients of Paperless Office Electronic Delivery e-mails.


  1. An Error 45 no longer occurs when printing the Direct Deposit Maintenance Listing. Sage 100 2018 Product Update 4 or higher must also be installed to resolve the issue.

Purchase Order

  1. Quantity on Purchase Order is now correct after updating receipts with the same purchase order at the same time.

Sales Order

  1. Credit Card Authorization Date now populates into the SO_PickingSheetWrk table from SO_SalesOrderPayment.
  2. Corrected issue with Reset row in SO Invoice Data Entry clearing the line item when it is a Miscellaneous charge or a comment item instead of recalling the item from Sales Order.
  3. Corrected blank invoice list box in Sales Order and Quote History Inquiry drill down into item level when order has been applied to a Multi SO Invoice entry.
  4. Sales Commission and Gross Profit is no longer Overstated on Kit Items with Back Order.
  5. Print Pick Sheets is now deselected in Sales Order Entry when Sales Order Type is changed from Standard to Quote.
  6. SO Invoice Printing, Lines are now printed in proper order.
  7. Corrected issue with reset row removing miscellaneous charge and comment type item in Shipping Data Entry
  8. Workstation Synchronization has been enhanced to display a warning if one or more files could not be updated. See Sage 100 Knowledge base number 92996 for more information.

System Setup

  1. Updated Sage NA Sync Client to handle TLS 1.2.

Sage CRM 2018 Release 3 Coming Soon

Written by Todd Martin on .

Sage CRM 2018 Release 3 (R3) is scheduled for availability in August 2018. This latest version will include a number of improvements including these highlights:

More Calendar Enhancements - in addition to the ability to now create quick appointments for other users, you can also view all items in the calendar as a list to make better use of screen real estate.

Quick Find - Quick Find has been improved so you can search for Person and Company records by their postal address, email address, or phone number.

Supported Character Sets - improved support for Unicode characters, including special characters and emojis.

Customer Cases - more than 50 customer cases and product fixes have been addressed with this release.

©2018 Juice Marketing, LLC. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.

Bill of Materials in Sage 100 Cloud 2018.3

Written by Todd Martin on .

A new field ‘Sync Misc Charge Changes with Bill Tables’ has been added to Bill of Materials Options. There are three options for updating bills with changes made for miscellaneous change items in Miscellaneous Item Maintenance:
  • Yes - to update bills with the changes made in Miscellaneous Item Maintenance.
  • No - if you do not want to update the bills
  • Prompt - to receive a message when you update a field for a charge item in Miscellaneous Item Maintenance asking if you want to update the field in Bill of Materials.

Release Notes and Other Details

Download the What’s New Document and Release Notes for full details of all enhancements and program fixes applied in Sage 100 Version 2018.3 and be sure to contact us if you need help updating your Sage 100/Sage 100cloud system to the current release.

©2018 Juice Marketing, LLC. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.

Sales and Purchasing in Sage 100 Cloud 2018.3

Written by Todd Martin on .

In the Sales Order module during invoice data entry, you can now apply multiple sales orders to an invoice if the invoice type is either Standard or Cash Sale. In addition, several reports, forms, registers, and on-screen inquiries have been updated to indicate that multiple sales orders have been applied.

In the Purchase Order module when creating POs using ‘Auto Generate from Sales Orders’, any drop-ship items that are used in multiple lines in a sales order can now remain on separate lines in the purchase order. Previously, duplicate lines were consolidated into one line in the PO.

©2018 Juice Marketing, LLC. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.


Written by Todd Martin on .

The #1 Customer-Requested Add-on

According to a 2017 survey that Sage conducted of customers, accounts payable automation was the most requested new functionality. So it should come as no surprise that Sage recently introduced

Huge Savings on Sage Software in September!

Written by Kate Phillips on .

Off plan customers offer

Existing Customers of Sage 100 and Sage CRM

Buy 5 User licenses, get one free!

Expanding your resources to meet the expanding demands of the marketplace, is the right action to take now. Don't miss out!  Act soon and when you buy five Sage CRM or Sage ERP licenses, you'll get an additional license for free!*

*Offer valid through September 28, 2015. Offer is valid for existing Sage 100 ERP customers.  Maintenance and support is charged on all six licenses.  Offer is not eligible for subscription orders.

Off-plan customers of Sage 100 and Sage CRM 

  • 40% off software upgrade fees* (reinstate) or off new license fees (repurchase)
  • New subscription license now available (subscribe)
Product Line     Reinstate Repurchase Subscribe
Sage 100  V 2015, 2014, 2013  V 4.5 or older  All Versions
Sage CRM  V 2015, 2014, 7.1  V 7.0 or older   All Versions

*Software upgrade fees are also known as software update and lapsed fees for Sage 100.

Note: Offer cannot be combined with any other promotion. Discount applies only to customers who come back on plan to the same product platform. Discount does not apply to new subscription license, Sage Business Care, additional users, or add-on modules. Promotion expires September 28, 2015.

Working with User Defined Fields

Written by Todd Martin on .

Sage 100 ERP user defined fields setupWhen you originally implemented Sage 100 ERP, you probably made some important decisions about your chart of account structure, account segments, and other aspects of accounting and reporting.

But what happens if your tracking and reporting needs change over time? That's where User-Defined Fields (UDFs) can help. Let's take a look.

What is a User-Defined Field?

User-defined fields can be added to any table in the Sage 100 ERP database. As the name suggests, these custom fields are defined and created by the user (that's you!) and allow you to store and track additional transaction detail that may not be provided as a standard field in Sage 100.

What is Social CRM?

Written by Todd Martin on .

Social media with CRMSuccessful companies are increasingly using tools like Sage CRM to develop and manage customer relationships. But if you only focus on your own internal CRM data, you could be missing opportunities online. Nowadays, more consumers are using social media to research products, ask questions, and solicit recommendations from their social networks.

So we want to introduce you to the concept of Social CRM. This concept is the combining of social media conversations with your in-house CRM data to help uncover new opportunities.

Understanding Level 3 Credit Card Processing

Written by Todd Martin on .

Sage 100 ERP customers can now take advantage of Level 3 Credit Card Processing. This new functionality for the Ready to Get Started? platform allows you to qualify for lower rates when processing business, commercial, and government payments. Here's what you need to know.

What is Level 3 Processing?

Level 3 processing expands your payment processing capabilities beyond the typical consumer transaction by allowing you to process business-to-business (B2B) and business-to-government (B2G) purchase cards. That's because B2B and B2G transactions are considered "lower risk" and carry much lower interchange rates. This means that merchants like you are charged less per transaction and for other fees like charge-backs.

Sage MAS Intelligence

Written by Todd Martin on .

Sage MAS Intelligence (SMI) is the replacement for FRx for Sage Software. Microsoft has given FRx an end of life date (end of 2012) and it is approaching. Sage is not going to wait around until the product is no longer supported. They have already found a replacement product and SMI is that product.

Sage ERP MAS Intelligence empowers you to quickly and easily gain control and obtain the information you need for operations and strategic planning. Using the familiar look of Microsoft Excel®, analyze Sage ERP MAS 90, 200, or 500 ERP data. Effortlessly create real-time, automated, and preformatted reports with up-to-date, accurate, and meaningful information. Sage ERP MAS Intelligence allows you to spend more time focusing on analysis and interpretation and less time pulling the data together.

ACH Electronic Payment

Written by Todd Martin on .

A new feature that was added with product update is ACH Electronic Payment. ACH Electronic Payment update now provides you with the ability to pay your vendors electronically. This topic provides information and requirements for generating an ACH file that contains payment information for vendors that is submitted to your financial institution.

In this video from Sage University we can see how to use the new feature.

Enhanced Customer PO Number Validation

Written by Todd Martin on .

A new feature that was added with product update is Enhanced Customer PO Number Validation. In Sales Order Options, you can now optionally choose to check for duplicate customer PO numbers in Sales Order Entry, Sales Order Invoice Data Entry, Sales Order History, Accounts Receivable Invoice Data Entry, and Accounts Receivable Invoice History.

In this video from Sage University we can see how to use the new feature.

Allowed Job Statuses in Data Entry Tasks

Written by Todd Martin on .

A new feature that was added with product update is to have Allowed Job Statuses in Data Entry Tasks. You can now control the selection of jobs in data entry tasks based on the job status. For example, you can define settings that only allow users to enter a billing for jobs that have a job status of Complete.

In this video from Sage University we can see how to use the new feature.

September 2009 - Volume 9 - Issue 5

Written by Todd Martin on .

This Issues Topics:

Payroll Processing-In House, Outsource, Or The Best Of Both?

What is the most efficient and cost effective way to handle your payroll processing? In this article, we will discuss the pluses and minuses of handling payroll in house versus outsourcing to a service, and cover one way you can have the best of both options.


New Parallel Migration Smooths Upgrade Process

Picking the right time to upgrade your software is often a tricky proposition. Even a well-planned upgrade can sometimes run into difficulties. There can be data corruption issues, reports that don't print quite right, or changes that require staff retraining. To avoid downtime, companies often try to upgrade over the weekend, adding time pressure to the equation. Now with the Sage Parallel Migration Wizard, we can take some of the stress out of upgrading and make the process less time sensitive.


The Bill Of Materials Module: More Than Its Name

The Sage MAS 90 ERP Bill of Materials module is not just for manufacturing, it can help you to do much more than its name implies. Early next year, the Bill of Materials module will be updated to the Business Framework with the Version 4.4 release.


Client/Server - Fat Client vs. Thin Client

Written by Todd Martin on .

This is another article found in the depths of our archives about Client Server architecture. It contrasts the Fat Client implementation of MAS 90 with the Thin Client of MAS 200. This white paper was written to help our clients understand the difference between Sage MAS 90 and Sage MAS 200.

Business Insights Explorer (BIE)

Written by Todd Martin on .

Business Insights Explorer (BIE) provides comprehensive business intelligence, plus workflow and reporting tools that enable users to quickly drill down and get specific data on customers and much more. BIE includes 75 predesigned views, that allows users to quickly find information they need. Beyond business intelligence, BIE streamlines the workflow process by enabling users to navigate directly to and perform tasks directly from BIE.

An example of this can be seen in the video where a customer service rep answers a call and they need to find the customer in the system and change their repetative order.

September 2008 - Volume 8 - Issue 5

Written by Todd Martin on .

This Issues Topics:

Efficient Sage MAS 90 Shipping Solutions
Efficient delivery of your products is critical, inefficiencies can cut quickly into already slim profit margins. Sage MAS 90 ERP is equipped with the features and functionality to streamline your shipping operation.
Read more..

Sales Tax Compliance Issues
There are more than 8,000 taxing jurisdictions across the United States. State, county, and municipal jurisdictions typically overlap, making it very difficult to determine what taxes to collect for a particular street address.

Combatting Check Fraud
Fraud costs businesses billions of dollars each year. What can your business do to protect itself from check fraud? Here are some practical steps you can take.

New Extended Enterprise Suite
Sage Software recently introduced Sage MAS 90 and 200 Extended Enterprise Suite. The Sage MAS 90 and 200 Extended Enterprise Suite combines financial, operational, customer relations, and business intelligence applications.

September 2007 - Volume 7 - Issue 5

Written by Todd Martin on .

This Issues Topics:

Custom Office Customizer
Sage MAS 90 ERP is at home in companies spanning dozens of industries, from wholesale distributors to service organizations. Some reasons this solution works so well for such diverse organizations include the software's strong core functionality, large number of available modules, various industry-specific add-on applications, and perhaps most importantly, its ability to be customized and...

Headline News
Sage MAS 90 version 3.71 is slated for retirement. In December 2007, customers will receive the final 3.71 Year-End Tax Table updates and...

Tips & Tricks
This tip takes you step by step through the creation of an Item Masterfile user-defined field (UDF)...

Extended Solutions For Multi-Company Accounting
With its multi-company functionality, Sage MAS 90 ERP allows you to maintain and account for the separate business entities, store locations, or discrete business divisions within your corporate structure. Keeping financial transactions separate is often a necessity, and...

In The Spotlight
Sage MAS 90 Fixed Asset Module

Accurately managing and tracking your company's fixed assets is a necessary, if less than glamorous task. Many companies rely on spreadsheets to keep a listing of those assets and turn the documents over to their CPA at tax time to perform the necessary calculations. If you're ready to take a more active role...

September 2005 - Volume 5 - Issue 5

Written by Todd Martin on .

This Issues Topics:

High Quality Return
The Sage MAS 90 RMA Module
A necessary component of good customer service is accepting returns or exchanges. Your customers expect it, appreciate it, and tend to buy from those vendors who offer a flexible return policy. You must ensure that this process is handled efficiently and accurately...

Headline News
Sage Software has opened registration for Sage Summit, the company’s annual customer conference. The conference will be held in San Diego, CA...

Sage Payroll Services For Sage MAS 90
If you are currently using an outsourced payroll services provider, or have considered outsourcing payroll as a viable option for your organization, you’ll be interested in learning about Sage Payroll Services, a full-service online payroll solution that integrates with Sage MAS 90 and...

Sage MAS 90
In The Spotlight Extended Solutions—Serial Numbers
The Sage MAS 90 solution is renowned for its strong distribution focus. Part of this strength lies in the product’s inherent ability to handle lot and serialized item processing, a crucial component for many distributors. In this article we look at three Extended Solutions from Sage Software that expand on...

Acumatica PartnerAcumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations.

Lean More
sage PartnerWhen it’s time for your business to move beyond simple accounting software, you can count on Sage to help you manage your manufacturing, distribution, and service industry processes from beginning to end. Unite your company so you can grow revenues, reduce costs, and increase profitability.

Lean More

Subscribe to Newsletter
Subscribe here for MBA Business Software's newsletter and product information to stay informed about the products and services offered by MBA.

90 Minds
90 Minds Consulting Group is an 
association of proactive consulting professionals who combine technology skills while still operating their own independent companies.

MBA Business Software
1117 Perimeter Center West, 
Suite E210
Sandy Springs, Georgia 30338
(P) 678-495-5700 
(F) 770-399-5772

Remote Offices
Chicago, Illinois
Cape Coral, Florida