Sage 100c – Page 6 – Schulz Consulting

Sage Fixed Assets 2018.x Causes Crystal Reports Issue With Earlier Sage 100 Versions (Resolution)

February 15, 2018 by Wayne Schulz

Sage has just posted an updated knowledgeable article 89164 which outlined 5 different resolutions to a Crystal Reports version incompatibility between Sage Fixed Assets 2018 and Sage 100 versions earlier than 2018.

The incompatibility can arise when the Crystal Reports version used is not identical between these two products.

Error messages which can occur:

Error:”Unable to cast COM object…” when printing any report on Sage 100 2017 and prior versions, after installing Sage Fixed Assets Client 2018.1

Error:”Unable to cast COM object of type ‘CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass’ to interface type ‘CrytsalDecisions.ReportAppServer.Controllers.ISCRReportSource’.
This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{98CDE168-C1BF-4179-BE4C-F2CFA7CB8398}’failed due to the following error:
No such interface supported (Exception from HRESULT:0x80004002 (E_NOINTERFACE)).

Sage 100 Crystal Incompatibility Fixes

Upgrade Sage 100 to version 2018
Sage 100 2018 include Crystal Report Runtime SP21
Select the 2016-2017 version of Sage 100 configuration from the chart below see resolution

First, review this chart and note the version of Sage 100 and the type of installation (Note that only supported versions are listed):

Then, using the resolution number from the chart, follow the suggested fix below:

Note: installing the SFA client on workstations that do not access SFA can be substituted by installing SAP Crystal Report SP21 x32 on the workstation. http://downloads.businessobjects.com/akdlm/crnetruntime/clickonce/CRRuntime_32bit_13_0_22.msi

Note: Sage 100 must be on versions 2016.1 and higher. Please refer to Integrated Solutions Compatibility Matrix in Additional Resources.

Sage 100 Payroll Tax Table Update Available: January 26, 2018

January 26, 2018 by Wayne Schulz

Sage has just updated the payroll tax tables for the latest Federal Withholding tax changes. The changes include in this update are cumulative. You only need to install the latest update in order to have access to the latest tables.

This tax table update is compatible with currently supported versions of Sage 100 2015, 2016 and 2017.

To verify whether you have the latest Sage 100 TTU installed:

1. Select Library Master > Setup > System Configuration.
2. On the Modules tab, in the grid at the bottom of the screen, look for 2018-Q1 Tax Tables in the Module column as well as the applicable Release Date.

If you are using Sage 100 2018 and Payroll 2.0 then payroll tax tables are self-updating and you do not need to separately update the payroll tax table.

Sage 100 Payroll Tax Table Changes – 1/26/2018

Federal – Updated withholding tax tables
Federal – Dependent exemption increases
Federal – Supplemental rate decrease

State Tax Table Changes

CO – Colorado – Colorado income tax withholding rounding to nearest dollar repealed
KY – Kentucky – Standard deduction increase
MO – Missouri – Withholding tax tables
MO – Missouri – Standard deduction increases
MS – Mississippi – Withholding tax tables
TN – Tennessee – UI wage base decrease

More information on the Sage 100 tax table changes available in this guide.

Download the 1/26/2018 updated payroll tax tables here.

What Is Sage 100cloud? – ( The Product Formerly Known As Sage 100c )

January 23, 2018 by Wayne Schulz

On a conference call today Sage announced that they would rebrand their Sage 100c product as Sage 100cloud effective March 7, 2018.

This move was explained as more of a marketing change.

So this is a way to reinforce the connected cloud capabilities of the c-line products and align closer our native cloud solutions under Sage Business Cloud

At least initially, the internal features and benefits of Sage 100cloud will be identical to Sage 100c. Think of Sage 100cloud as Sage’s way of more directly explaining that in the future they expect to have Sage 100cloud utilize more cloud connections.

What Is Sage 100cloud?

Sage 100 Cloud is the product formerly known as Sage 100c. It is optimized for a hosted cloud although you can also run the program locally within your own office.

As an extension of the product formerly referred to as Sage 100c, Sage 100 Cloud offers all the same unique benefits which were included with Sage 100c. The pricing of Sage 100 Cloud is also based on a subscription with minimal up-front costs.

While Sage 100c will run as a hosted application in a cloud environment, it is important to note that the hosting portion is an optional added cost.

Sage first launched Sage 100c in November 2015. Initially, the primary difference between Sage 100 and Sage 100c was that Sage 100c would be sold under a subscription license with less of a hefty up-front cost.

What Is Unique To Sage 100cloud?

Over time Sage has added features unique to Sage 100c:

Multi-Bin processing from DSD and Scanforce
AP Automation
Sage 100c Manufacturing
Payroll 2.0
Inactive warehouse
Sage Mobility by Scanco

As development continues on Sage 100 Cloud we expect the the bulk of new features will be created on that platform. We also expect increased integration capabilities from Sage Business Cloud.

How Can I Host Sage 100cloud?

Sage 100 Cloud will run locally or you may host it run a private or public cloud environment. The choice of a host is completely up to you. There are few limitations on what integrations may be used in the Sage 100 Cloud hosted environment.

As an example, users of Sage 100 Cloud who wish to access the software in the cloud may select from plans ranging from $65/mo per user to $139/mo per user.

The Sage 100 Cloud hosting includes all maintenance, update and upgrade for every version of Sage 100. Data backup, recovery and redundancy is also included with each Sage 100 Cloud hosting plan.

Third-party applications from popular ISVS such as Starship, Scanco, Scanforce, MAPADOC, Highjump, Biznet and more will all work seamlessly when hosted in the Sage 100 Cloud.

Cloud hosting for Sage 100 is most popular with users having multiple remote offices or lacking adequate IT coverage to service their accounting software.

For more information on Sage 100 Hosting options – Sage 100cloud

Sage 100 Payroll 2018: A Payroll tax update is in process.

January 13, 2018 by Wayne Schulz

If you’ve updated to the latest Sage 100 2018 Payroll – also referred to as Sage Payroll 2.0 – and you are receiving a message “A Payroll tax update is in process. Please try again in a few minutes” when you open payroll, here is the fix.

Note: Always create a backup copy of any file which you are modifying with utilities. Use of Sage file utilities can cause issues if the steps are not followed. Consult with your Sage partner prior to attempting this.

Change SyncStatus field to ‘1’ in PR_SPASyncControl.m4t file using Data File Display and Maintenance

Have everyone else exit Sage100
Open Library Master, Utilities, Data File Display and Maintenance. Select ‘OK’ to warning message
Select folder icon to the right of the File Name field and select …\MAS90\MAS_System\PR_SPASyncControl.m4t
Select Open
Select Edit
Select ‘2 – SyncStatus (numeric)’ from the Field Number dropbox field
Enter: ‘1’, in Change field
Select OK
Exit Data File Display and Maintenance
Open Payroll, Utilities, Payroll Tax Update
Select Proceed
Click OK

Source

Sage 100 Patches Address Issues With Disappearing Payroll Files

January 9, 2018 by Wayne Schulz

Over the past few weeks, numerous users and consultants have wrestled with an annoying issue with disappearing data files.

This primarily occurred with payroll and seemed to be present in all versions of Sage 100 – including Sage 100c.

In many cases, users would notice that payroll data files like PR9, PRB, PRI, PRJ, PRK, PRL, etc. are missing when printing Payroll registers or checks.

An Error 12 PRWUAA 8825 would also sometimes appear while running payroll tax calculation.

According to Sage KB 106266

This primarily affects users of Payroll but may affect any Legacy module data entry file. Other messages may include Work Order data entry files are missing, Job Cost data entry files are missing, Time Card data entry files are missing, etc. Legacy versions of Sage 100 (formerly Sage MAS 90 or 200) may also experience issues in other modules.

It seems as if two non-Sage updates were the cause of the issue:

a. Microsoft Security updates – kb4051034 and kb4054518

b. Webroot Anti-Virus changes

Sage just posted a series of fixes that address this issue as follows:

The behavior that we have been able to address is that for Sage 100 Standard users in some environments, after applying specific Windows Security Updates (KB4051034 and KB4054518) customers are having problems with those files. The KB articles with the Program Fixes are 88508 (2018.1), 88509 (2017.1 – 2017.3), 88510 (2016.1 – 2016.5), and 88511 (2015 and prior).

We have also heard that Webroot is removing those files, even if the Sage 100 program and “MAS 90” and “PRXXX” directories are excluded. Unfortunately, in the case of Webroot the only solution we have at this time is to remove Webroot and use another product.

To resolve this issue, navigate to the appropriate Sage KB article and apply the fix. If you are using Webroot Anti-Virus you should consider removing it and using a different brand of AV. Note: Do NOT go without anti-virus, rather you should use a different brand that won’t interfere with Sage.

Sage 100 2015 and Prior Program Fix LM5031T – Payroll files are missing – Fix LM5031T

Sage 100 2016.1 – 2016.5 Program Fix LM5030T – Payroll files are missing – Fix LM5030T

Sage 100 2017.1 – 2017.3 Program Fix LM5028T – Payroll files are missing – Fix LM5028T

Sage 100 2018.1 Program Fix LM5029 – Payroll data files are missing – Fix LM5029

For the latest in Sage 100 and Sage 100c news and technical tips – please subscribe to our Sage 100 email newsletter.

via Sage City Sage 100 Announcement Forum