Sage 100 2017 Product Update 5 (5.40.5.0)

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2017.5
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 2017. Smart Update will install only the programs that have been updated since your last update was installed.

Sage 100 Advanced and Premium Workstation Synchronization automatically updates the client workstations.

If you use Sage 100 Standard over a network, run WKsUpdate Standard.exe on each workstation. This program is located in the ..\mas90\wksetup folder on the server where Sage 100 2017 Standard is installed. 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 5 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. Running the Credit Card Settlement Report no longer returns a communication error.

Bill of Materials

  1. "Record <Part Number> is missing..." error no longer occurs when running the Bill of Materials Summarized Where–Used Report in Sage 100 Premium.

Customizer

  1. PO Receipt Header UDF now updates PO Purchase Order Header UDF.

e-Business Manager

  1. The message "An error occurred while attempting to process the page you requested. Contact your account representative or the Webmaster" when processing credit cards on a website using eBusiness Manager, can be resolved by copying the following files from the Sage 100 Server and adding/replacing them on the Server running the Web Engine: pvxclr4.dll,Sage.Exchange.dll, and wsVault.dll. Then run the Web Engine as an Application, not as a Service. There is another outstanding defect regarding the Web Engine running as a Service,see Knowledge Base entries 82537 and 82539.

Fixed Assets

  1. Closing date is no longer different than the Sage Fixed Assets ending date.

Inventory Management

  1. Tier Type is no longer missing from IM_ItemCost after update quantity committed.


Sales Order

  1. Error 14 _WINPROC 320 no longer appears when performing more than one Quick Print in Shipping Data Entry.


Web Services

  1. Certain Web Services APIs no longer fail after upgrading to Sage Exchange Desktop (SED) 2.0.

New Warehouse Status Settings - Version 2018

Written by Todd Martin on .

With the release of Sage 100 Version 2018, there are new warehouse status settings available that help you better manage your warehouses and inventory. In this article, we’ll take a closer look.

Warehouse Maintenance

warehouse boxIn Warehouse Code Maintenance, a new status field has been added that allows you to set a warehouse status to one of three options including Active, Inactive, or Restricted. Since the Active status is self-explanatory, we’ll explore what it means to chose either Inactive or Restricted.

Inactive Warehouse Status

The Inactive status is intended for warehouses that are no longer in use. If a warehouse status is Inactive

Sage 100 2018 Product Update 3 (6.00.3.0)

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2018.3
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 Payable

  1. The DiscountAmt field in AP_CheckHeader file now shows the total discount for all invoices included on the check.
  2. Vendor Maintenance Invoice Inquiry feature under 'More' displays invoices generated from Purchase Order Invoice amount now matches the Net Invoice Amount displayed on the AP Invoice History drill down screen.

Accounts Receivable

  1. Error "The Cash Receipts entry files are empty" no longer occurs when updating an A/R Cash Receipts batch where one deposit within the batch was transferred to a new batch.
  2. Running the Credit Card Settlement Report no longer returns a communication error.

Bill of Materials

  1. Enhancement made to allow for syncing of Misc Charge item fields that are changed to the bill detail tables.
  2. "Record <Part Number> is missing..." error no longer occurs when running the Bill of Materials Summarized Where–Used Report in Sage 100 Premium.

CRM

  1. Sage 100 Rebuild CRM no longer cuts off CRM Company Names more than 30 characters long.
  2. Added information to the "Cannot Synchronize Data with Sage CRM" message to help resolve the issue when no company records exist in Sage CRM.
  3. Quick Order Entry Component.exe is now being installed to the servers ..\mas90\CRM directory.
  4. Import into AR_Customer does create new CRM companies automatically.

Common Item

  1. In Direct Deposit Maintenance when an invalid routing/transit number is entered for the Immediate Destination a prompt now displays to accept the number.

Customizer

  1. PO Receipt Header UDF now updates PO Purchase Order Header UDF.

e-Business Manager

  1. The message "An error occurred while attempting to process the page you requested. Contact your account representative or the Webmaster" when processing credit cards on a website using eBusiness Manager, can be resolved by copying the following files from the Sage 100 Server and adding/replacing them on the Server running the Web Engine: pvxclr4.dll,Sage.Exchange.dll, and wsVault.dll. Then run the Web Engine as an Application, not as a Service. There is another outstanding defect regarding the Web Engine running as a Service, see Knowledge Base entries 82537 and 82539.

Fixed Assets

  1. Closing date is no longer different than the Sage Fixed Assets ending date

Inventory Management

  1. No longer receive "Error 43 IM_LOTSERIALTRANSINQUIRY_UI.pvc 534" after selecting a Lot/Serial number with Extension greater than 99,999,999.99 in Lot/Serial Inquiry.
  2. Tier Type is no longer missing from IM_ItemCost after update quantity committed.

Job Cost

  1. Fix "(Tax Code)" is not numeric" in version 2018 Job Billing Data Entry for a Fixed Contract job.
  2. No longer receive "record (report Name) is missing from SY_ReportManagerMaster.M4T." when using the Designer button to open any report on the Job Cost > Estimating menu.
  3. Cost Code Maintenance is no longer truncating alphanumeric Cost Code numbers that include a special character.
  4. Job Estimate Printing *SUB and *TOT calculation is now correct if the line is deleted and re-entered to a different line on the grid.
  5. New Comments or changes to Comment are now retained in Job Maintenance.
  6. Corrected issue with Time & Material transactions not summarizing by Job in Daily Transaction Register.
  7. Job Estimate Printing with Print Estimate Recap selected now calculates Overhead and Profit calculations correctly on the Estimate Recap.
  8. Job Transaction Detail Report no longer inserts a Page Break between each job when "Page Break by Job" is unchecked in report options.
  9. Corrected issue with Cost Code unit price and unit cost being truncated in Job Posting Entry.
  10. Corrected issue with navigation buttons not refreshing Revised Contract Amount display in Change Orders tab when moving between records.
  11. Error "xx-xx-xxx is not on file" after migrating data to v2018 with a Cost Code length less than 9 characters.
  12. Job Trans Detail History Report no longer inserts a Page Break between each job when "Page Break by Job" is unchecked in report options. And transactions are now sorted in date order under the Cost Code.
  13. The Error "The Burden Job Type generated an invalid Cost Code" no longer occurs when updating Payroll with Burden Allocation defined and using a Cost Code less than 9 characters.
  14. Overhead Allocation Register (Monthly or Daily) now updates to G/L in summary format.
  15. Job Billing Selection no longer duplicates Time and Material job transactions if the transaction date is less than or equal to the module date.
  16. Job Billing History Report Current Balance column no longer displays ##### if the Current Balance exceeds $999,999.99.
  17. Direct Cost Job Posting Register and Job Daily Transaction Register no longer prints ######## when amount is 1,000,000.00 or above.
  18. The correct Cost Code description now prints on the Job Cost Code Detail Report.
  19. Negative amounts entered in Job Posting Entry now post correctly to the G/L.

Library Master

  1. Error: "Database Connector Error: '[Database Vendor Code:9]' no longer occurs when printing the System Configuration Listing and the Payroll module is not part of the product key.
  2. The copy company process no longer completes when Sage Exchange Desktop is not installed and running.

Material Requirements Planning

  1. MRP Weekly Projected Demand is now reduced by a Sales Order in the same time period if the week starts in one month and ends in another month.

Purchase Order

  1. Fix incorrect overhead allocation calculation.
  2. No longer receive,"Missing selection table JC_JOB" in Auto Generate from Sales Order accessed from Purchase Order.

Sales Order

  1. Line messages on Sales Order Picking Sheets now print the quotation symbols instead of QUO+QUO.
  2. Error 14 _WINPROC 320 no longer appears when performing more than one Quick Print in Shipping Data Entry.
  3. Ship via no longer populates wrong freight amount in Shipping Data Entry.
  4. Batch is no longer locked in Print/Update status after transferring invoice in Sales Order Invoice Data Entry.
  5. In Sales Order Options, on the Job Cost tab, the window now displays when clicking on the Display Cost Type button.
  6. PTD, YTD, JTD cost at the Cost Code/Cost Type level is no longer overstated when posting invoices from Sales Orders where multiple jobs are created on the fly.
  7. Exclude from Certified Payroll Report field in JC_Job.m4t now defaults to N when a job is created on-the-fly in Sales Order.
  8. Error "SO_SalesOrderQuickPrint_UI.pvc 122" no longer occurs when printing Invoice from Sales Order and Quote History Inquiry if a Sales Order form was updated from 2018.1 or 2018.2 and Line 1 Message was populated.

Visual Integrator

  1. Auto generated Material Issue is now created with a batch number when importing a Completion into WO.TRNSENT with batch entry enabled.

Web Services

  1. Certain Web Services APIs no longer fail after upgrading to Sage Exchange Desktop (SED) 2.0.

Work Order Processing

  1. Error "The Warehouse Code is required" no longer occurs when entering a Completion transaction for a Special Item in Work Order.

New Usability Enhancements in Sage 100 Version 2017

Written by Todd Martin on .

With any new release, we often see a collection of features called usability enhancements. These aren’t typically headline-grabbing features that everyone eagerly anticipates. However, depending on your workflow and how you use Sage 100, these minor tweaks can turn into huge time-savers. So here’s a look at some of the global usability enhancements included in Sage 100 Version 2017.

Enhanced Auto-Complete Search

When using the auto-complete feature, your search criteria is now compared with all words within the searched fields. Previously, Sage 100 considered

Sage 100 ERP Q3 Tax Table Updates for 2015

Written by Kate Phillips on .

Sage has released the 3rd Quarter Payroll Update for Sage 100 ERP.  This release is available to all Sage 100 ERP customers that are current on Sage Business Care.  The update is available for Versions 2013,2014 and 2015

Payroll Tax Table Update Levels 2013, 2014 and 2015

To download the TTU (Tax Table Update): 
  1. Log on to the Sage Customer Portal by entering your name and password* (you must be logged in or you cannot access the Tax Table Updates).
  2. Select the Sage 100 ERP icon
  3. Under Download Product Updates section on the left toolbar, click Tax Table Updates.
NOTE: Those customers that are current on Sage Business Care and are on MBA Preferred Support can contact MBA Business Software through the Support line to have MBA download and install this TTU.The following is a list of changes contained on the 2015Q1 Tax Table Update delivery as of 02/06/15. Released for 2015-Q3 dated 06/03/15

Sage 100 ERP 2014 Product Update 6 (5.10.6.0)

Written by Kate Phillips on .

Sage has released the sixth product update for version 2014 (5.10.6.0) on 6/29/15. The following is a list of enhancements and corrections that have been incorporated for Sage 100 ERP 2014 in this Product Update. Product Updates are cumulative, comprised of all program corrections found in prior updates. Smart Update will install only the programs that need to be updated since your last Product Update Installation. If you choose to install this Product Update on a system that already has Product Update 5 installed, all programs released in Product Updates 1 through 5 will be reinstalled.

Sage 100 ERP Advanced and Premium Workstation Synchronization now updates the client workstation automatically. This replaces the need to run WKsUpdate.exe after installing a product update. Users running Sage 100 ERP Standard over a network will still need to run WKsUpdate Standard.exe on each workstation. This program is located in the ..\mas90\wksetup directory on the Sage 100 ERP 2014 Standard Server.

All Sage 100 ERP 2014 Product Updates require the installation to be from the Sage 100 ERP Server.MBA Business Software customers that are on Software Support – Preferred (SSA-PF) can contact us to schedule your update to this version. As part of your support plan, minor updates and hot fixes are included. Not on a support plan but interested? Find out more about what MBA offers for support. 
An updated "eBusiness Web Services.exe" was introduced in Product Update 5 and is being installed to the Sage 100 ERP 2014 Server's ..\MAS90\WS folder to correct the following issue:

"UnitPrice is no longer being reset in Sales Order Detail when previewing orders with eBusiness Web Services."

Existing eBusiness Web Services users should update their existing installation by uninstalling the existing eBusiness Web Services and installing the updated version. (OPTIONAL Method, existing users can replace their existing Sage100ERP.WebServices.dll with the updated version also located in the ..\MAS90\WS folder on the Sage 100 ERP 2014 Server.)

New eBusiness Web Services users should install using the updated "eBusiness Web Services.exe" located in the Sage 100 ERP 2014 Server's ..\MAS90\WS folder.

Sage 100 ERP 2015 Product Update 2 (5.20.2.0)

Written by Kate Phillips on .

Sage has released the second product update for version 2015 (5.20.2.0) on 6/29/15. The following is a list of enhancements and corrections that have been incorporated for Sage 100 ERP 2015 in this Product Update. Product Updates are cumulative, comprised of all enhancements and program corrections found in prior updates. Smart Update will install only the programs that need to be updated since your last Product Update Installation.  

An updated "eBusiness Web Services.exe" was introduced in Product Update 1 and is being installed to the Sage 100 ERP 2015 Server's ..\MAS90\WS folder to correct the following issue:

"UnitPrice is no longer being reset in Sales Order Detail when previewing orders with eBusiness Web Services."  

Existing eBusiness Web Services users should update their existing installation by uninstalling the existing eBusiness Web Services and installing the updated version. (OPTIONAL Method, existing users can replace their existing Sage100ERP.WebServices.dll with the updated version also located in the ..\MAS90\WS folder on the Sage 100 ERP 2015 Server.) 

New eBusiness Web Services users should install using the updated "eBusiness Web Services.exe" located in the Sage 100 ERP 2015 Server's ..\MAS90\WS folder.
MBA Business Software customers that are on Software Support – Preferred (SSA-PF) can contact us to schedule your update to this version. As part of your support plan, minor updates and hot fixes are included. Not on a support plan but interested? Find out more about what MBA offers for support. Sage 100 ERP Advanced and Premium Workstation Synchronization now updates the client workstation automatically. This replaces the need to run WKsUpdate.exe after installing a product update. Users running Sage 100 ERP Standard over a network will still need to run WKsUpdate Standard.exe on each workstation. This program is located in the ..\mas90\wksetup directory on the Sage 100 ERP 2015 Standard Server. 

All Sage 100 ERP Product Updates require the installation to be from the Sage 100 ERP Server.

Sage Summit 2015

Written by Kate Phillips on .

SageSummit2015

This year Sage Summit is headed to New Orleans for the annual gathering of Sage customers and partners which will take place July 27 - 30, 2015.

Recently-announced "Featured Speakers" Include:


  • Tony Hawk - Entrepreneur and Pro Skateboarder
  • Chad Hurley - Co-founder of YouTube
  • Jane Seymour - Award-winning Actress
  • Matthew Weiner - Executive Producer of Mad Men

Sage 100 Sessions and Agenda

Sage has also published conference sessions, product lessons, and deep-dive learning opportunities broken out by product categories. Click below to see what's in store for you at Sage Summit 2015:

Browse Sage 100 ERP Product Sessions >>>

Getting Started with Sage Cloud Connector

Written by Todd Martin on .

With all the buzz (and confusion) surrounding "the cloud", it can be hard deciding whether or not it makes sense for your business. But with Sage 100 ERP and the Sage Cloud Connector, you don't have to choose because you get the best of both worlds - flexibility of the cloud combined with the stability of your on-premises software. Let's take a closer look at this important new technology.

How Does it Work?

The Sage Cloud Connector works as the buffer (or bridge) between your on-premises Sage 100 ERP software and the cloud - connecting you to a whole new world of web-based add-on applications without having to purchase, install, and configure web servers or special hardware in-house.

You've probably heard about the new Sage web and mobile applications that are available in the cloud like Sage Inventory Advisor, Sage Mobile Sales, Sage Mobile Service, and many others. Sage Cloud Connector is the technology that allows the data and transactions to flow freely between your on-premises accounting system and these cloud applications. That means there's no duplicate data entry or import/export routines - it all flows seamlessly between your office and the cloud.

Why Should I Care?

8 Reasons to Upgrade

Written by Todd Martin on .

Sage 100 ERP Version 2014

To upgrade or not to upgrade? That is the question on the minds of many customers now that Sage 100 ERP 2014 is released and available for download. You may be wondering whether moving up to the latest version will benefit your company. So here are 8 reasons to consider an upgrade.

1. You Want to Leverage the Cloud

Sage 100 ERP Version 2014 allows you to connect your ERP system to

Introducing Visual Process Flows

Written by Todd Martin on .

Thinking about upgrading to Sage 100 ERP 2013? The new release boasts an impressive array of enhancements that are designed to improve productivity, such as the new Visual Process Flows. These graphical, job-oriented diagrams provide a visual representation of your business processes, simplify system navigation, and help you perform daily tasks quickly. Let’s take a closer look at this helpful new feature.

Sage MAS 90 and 200 ERP Product Update 6 (4.40.0.06)

Written by Todd Martin on .

Sage released Product Update 6 (PU6) yesterday for Sage MAS 90 and 200 version 4.4. It is available for download from Sage Online. This update is a bug fix release. There are no new features with this release.

When installing Service Packs:

  • Install service update from the same computer that was used to install Sage MAS 90 or 200.
  • Be sure to apply this service update before data conversion.

For those customers that are on Preferred Support with MBA Business Software, remember that you get these updates installed for FREE! Call our office to schedule your appointment now to get this service update installed for you. If you are not on Preferred Support with MBA Business Software, why not call us to see what you can be getting for FREE as part of our Preferred Support.

Time wasted without Paperless Office

Written by Todd Martin on .

See Jane. See Jane waste time by scanning her reports and registers from Sage MAS 90. See Jane learn that forms, reports, registers can automatically be scanned using Paperless Office. Contact us to learn more about Paperless office and how you can benefit from it now.

Product update 4.40.0.2 coming soon

Written by Todd Martin on .

Sage released a notice today to business partners that the new product update will be coming soon. This will be the second release to the 4.4 version of Sage MAS 90 and 200. The first pre-release notification for 4.40.0.1 noted new features such as Record Wire Transfers in Account Payable and Search by Lot or Serial Number in Inventory. In this pre-release notification for 4.4.0.2 Sage noted new features like a Recalculate Outstanding Entries Totals Utility for Bank Reconciliation and Positive Pay Export Wizard. New features that Sage has added to the product along with existing Extended Solutions that have been encorparated into the product continue to make Sage MAS 90 and MAS 200 a very strong product that continues to grow. We can all help Sage in their process of making Sage MAS 90 and MAS 200 a strong product by suggesting product enhancements. Here is what was in the announcement from Sage:

Should you trust your data to someone else?

Written by Todd Martin on .

I found an article today about Carbonite, an online backup service, that is suing their supplier, Promise, due to a product that they bought that didn't work. Too bad this supplier wasn't for a door that was not closing properly. Instead they were the supplier for a RAID system that would guaranteethat the backups they have would be available in case of failure. The company (Carbonite) lost 7,500 customers data when drives did fail. I would not want to be one of those customers trusting an outside source to manage my data. Read more about this atwww.channelregister.co.uk.

If you are worried about your data being backed up, contact us for a quote on our preferred method of backups.

June 2007 - Volume 7 - Issue 3

Written by Todd Martin on .

This Issues Topics:

New SageCRM Integration Link
If your company is like most, different types of customer information are kept in two or more applications. This requires a fair amount of duplicate data entry to keep both systems current. This lack of a central view of customer information impacts the effectiveness and efficiency of both your front office customer service and sales staff, and your back office accounting and finance staff...
Read more...

Headline News
Sage Summit, the annual conference for Sage Software customers, will be held this year in Chicago, during the first week of November. You’ll learn about...
Read more...

Keep Your Data Secure
Data security has always been a top concern of businesses. Threats seem to be everywhere: viruses, malware, natural disasters, power surges, disgruntled or simply careless employees—and the list goes on. What are some practical steps you can take to ensure the security of...
Read more...

Vista Compatibility
Currently, Sage MAS 90 and 200 Version 4.2 does not support the Microsoft Windows Vista operating system. In June 2007, a Version 4.2 Service Pack will be available that provides Vista-capable support. Sage integrated...
Read more...

In The Spotlight
Sage MAS 90 Sales Tax
Sage Software has partnered with Avalara to create a useful module for Sage MAS 90 ERP: Sage MAS 90 Sales Tax. Powered by AvaTax, Sage MAS 90 Sales Tax is a sales and use tax calculation service that works in the background of your accounting system via a secure internet connection. This integrated Web-based sales tax calculation service helps ensure...
Read 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
Headquarters
6100 Lake Forrest Drive, 
Suite 520
Sandy Springs, Georgia 30328
(P) 678-495-5700 
(F) 770-399-5772

Remote Office
Chicago, Illinois

twitterfacebookyoutubefeedlinkedin