Schulz Consulting 833-724-3100

Sage 100cloud Consulting

Here are The Sage 100 2018 Downloads Needed for Year-End 2018

by Leave a Comment

Here are links to all the latest file versions needed to update both Sage 100 and Sage 100cloud version 2018.x for year-end 2018 processing.

We recommend payroll users stay on the latest release of Sage 100. If you are still on Sage 100 Payroll 2017.1 or 2016.5 then you should finish the year on that release and upgrade to Payroll 2.x toward the end of Q1 2019.

If you are using 2016.5 please note that this is the last year tax tables and IRD will be available for that release.

Before upgrading your software please ensure that all third-party enhancements are compatible with the upgraded version you are moving to. Please consult your Sage partner for specific questions about the upgrade process.

These downloads include (in the order of use):

Where Required, Install Before the Last Payroll of 2018:

  • Sage 100 2018 Full Product
  • Sage 100 2018.5 – Latest Sage product update
  • Sage 100 Payroll 2.19.0 (if using Payroll 2.x)
  • Sage 100 Interim Release Download for 2018 Year-End

Install After The Last Payroll of 2018 but Before The First Payroll of 2019:

  • Sage 100 2019 Q1 tax table update – install this after printing W-2s and before the first 2019 payroll

Sage 100 2018 Download Portal

 

Sage 100 and Sage 100cloud 2018 Payroll, Tax and IRD Updates Available

by

Sage has just released their year-end updates for users of Sage 100 and Sage 100cloud.

These updates contain program fixes which some versions of Sage 100 and Sage 100cloud may need to process the end-of-year.

Please note that if you are using Sage 100 or Sage 100cloud version 2016 that this is your LAST year-end update.

Please consult with your Sage partner prior to installing any updates. Make a backup before year-end processing.

Sage 100 Payroll 2.19 – This upgrade is for users of Payroll 2.x which is installed for Sage 100 2018. – Download

What’s New:

  • Tax Rule Inquiry utility
  • Capped Wages window
  • Payroll employee tax information window
  • Read more in the Payroll Upgrade and Installation Guide found here. Release notes are found here.

Sage 100 IRD for 2018 – This Interim Release Download includes program updates which may be needed to process year-end.  – Download

Must be at one of these minimum versions to install the Sage 100 IRD:

  • 2016.5*
  • 2017.1 or later
  • 2018.2 or later**
  • *The 2018 IRD will be the last year-end IRD for Sage 100 2016

**The 2018 IRD only needs to be installed by Sage 100 2018 users if they are processing 1099-DIVs.

Sage 100 Payroll – Tax Table Update for Q1 2019 – Download

This tax table update (TTU) is available for Sage 100 Standard and Advanced versions 2017 and 2016. If you’re using Sage 100 2018, when the tax update is available, a message will ask if you want to install it when you start a Payroll task. Also, you can use the Payroll Tax Update utility to check for updates.

  • The TTU is required for federal tax filing and for filing in some states. This update impacts payroll tax filing for filing year 2019.
  • The 2019 Q1 TTU should be installed after processing W-2 forms for tax year 2018 and before processing the first payroll in 2019.
  • The 2019 Q1 TTU will be the last TTU for Sage 100 2016.

Here is a list of what’s new in the Sage 100 Tax Table Update Dated December 18, 2018

 

 

 

 

 

 

Sage 100cloud – Providex ( PVX ) vs SQL – Pros And Cons

by

As Sage 100 users migrate to  Sage 100cloud we are often advising them to consider whether a move to a SQL database may be of benefit to their operations.

One of the key benefits of the Sage 100cloud subscription is the ability to use any of the following flavors of Sage 100cloud with no additional charge for changing the underlying database driving Sage 100cloud:

  1. Sage 100cloud Standard  – Providex based
  2. Sage 100cloud Advanced – Providex based – runs in a client-server type environments
  3. Sage 100cloud Premium – SQL backend – runs on Microsoft SQL server

What’s The Best Option For Sage 100cloud: Providex or SQL?

Below is a condensed version of the pros and cons of changing your Sage 100cloud to a back-end SQL database. Typically we recommend considering this switch when you:

  1. Have significant database sizes (> 500 MB) and expecting to continue growing
  2. Noticeably slow reporting – especially with externally connected reports/queries
  3. 10+ users on the system concurrently (now or expected in the future)

Your end users don’t need to know anything about SQL. About the only thing they’ll notice is if they use the SOTAMAS90 for external reporting they will have to change drivers in favor of a connection to the SQL tables.

Benefits of SQL for Sage 100 and Sage 100cloud

  • No premium for premium (a true benefit of Sage 100cloud subscription)
  • External reports based on SOTAMAS90 pretty easy to convert to Premium
  • Customers notice a speed increase in external reporting (true value added)
  • Virtually all 3rd party ISV solutions work with Premium
  • Reporting via external tools/connections can be significantly faster
  • Straightforward to set up Sage 100cloud on Premium
  • The prior penalty for SQL speeds in native Sage screens seems mostly gone
  • Data File Display & Maintenance (DFDM) goes away but you can download a free DSD SQL DFDM
  • Skilled users can use SQL tools for query/changes (recommend locking users out of write capabilities)

Disadvantages of SQL for Sage 100 and Sage 100cloud

  • Need to be comfortable setting up a SQL server
  • Some customers reluctant to invest in a new server to maintain (especially if they don’t have on-staff IT person)
  • Sage has limited info about how to configure the SQL server
  • Easy to use SQL tools to change data without Sage 100cloud which could result in lost data if not performed by a qualified person
  • WO, MRP users can’t use Premium as of December 2018 (due Q1 2019)
  • Tricks you may do with Providex such as swapping in or out single data files are difficult/impossible with Premium
  • Cannot simply insert a new license key – a system upgrade will be required which involves migrating existing data to a new installation of Sage 100cloud Premium

 

If you are considering a move to Sage 100cloud Premium ( aka SQL ) then consult our summarized guide to selecting and configuring Microsoft SQL for Sage 100 Premium.

The use of SQL is a popular selection for growing Sage 100cloud customers with significant reporting requirements now or in the future.

For more information contacts us or give your Sage 100cloud partner a call.

StarShip Advises Their Users: Wait To Install Sage 100cloud 2018 Product Update 4

by

V-Technologies, publisher of the popular Starship shipping solution for Sage 100cloud just notified users they should wait to install the latest Sage 100cloud 2018 Product Update 4.

Are you planning an upgrade to Sage 100cloud 2018 Product Update 4?
We are in the process of performing compatibility tests with StarShip for Sage 100cloud 2018 PU4. Please delay upgrading to Sage 100cloud 2018.4 as this interface is currently NOT supported. The 2018.4 release includes an enhancement to support multiple orders against a shipment resulting in extensive changes to Shipping Data Entry. We are actively reviewing the changes and options for supporting this enhancement and expect to provide an updated roadmap soon. We will contact you as soon as we have more information.

 

If you are using Starship with Sage 100cloud be sure to wait for the notice from V-Technologies telling you it’s safe to install the latest Sage product update.

To receive timely information about Sage 100cloud, consider signing up for our weekly Sage 100cloud email newsletter – Schulz Says.

 

 

Sage 100 2018 Product Update 4 Available for Download

by

Sage has just released the latest product update 4 for their Sage 100 accounting product.

Before installing the update be certain to check with your Sage partner. If you are using any 3rd party enhancements you also should verify (and in many cases reinstall them) compatibility.

Product updates are self-installable bundles of fixes. These updates often contain new features which have been added between the major update releases (Sage 100 2019 ETA March 2019).

Sage 100 2018.4 is available for both Sage 100 and Sage 100cloud users.

New to this release:

  • Credit card EMV chip support
  • Processing payment cards with EMV chips through Paya (formerly Sage Payment
    Solutions) is supported when using the following card readers:

    • Ingenico ipp320
    • Equinox L5300
  • Consolidate multiple sales orders onto one invoice inside Shipping Data Entry
  • Sage University videos accessed from within Sage 100
  • Click here for the full list (pdf)

Notable fixes include: 

Beginning with Payroll 2.0 for Sage 100 2018 the payroll updates are installed separately. The latest payroll release 2.18.4 was also released and users can download that update from here.

Schulz Consulting provides consulting services for all versions of Sage 100 and Sage 100cloud. Based in Glastonbury  Connecticut, we service all of the New England areas including New York, Massachusetts, New Hampshire, Rhode Island, and Vermont.

Whether you are looking for a Sage 100 second opinion, an upgrade to your existing system or perhaps a new Sage 100cloud implementation — we can provide assistance.

Pricing is all fixed fee for Sage 100 and Sage 100cloud consulting. We support all versions and platforms of Sage 100.

Some of the integrated third-party solutions which we work with include:

  • V-Technologies – Starship Shipping for Sage 100
  • Scanforce Warehouse Management
  • DSD Multi-Bin for Sage 100 Inventory
  • Avalara Sales Tax Integration to Sage 100
  • DSD InstaDocs for Sage 100
  • xkzero iSales and Getx search
  • cimcloud / Website Pipeline ecommerce
  • ROI Consulting – IN-SYNCH

 

Please make a backup first and check with your Sage partner before installing any product updates or enhancements.

For more information and to review the expected release schedule for future Sage 100 updates please visit this link.

Contact Us

Schulz Consulting
160 Oak Street
Glastonbury, CT 06033
Phone: 833.724.3100
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide. We are a local affiliate of DSD Business Systems.