Schulz Consulting

Sage 100cloud Consulting

Sage 100 Files to Exclude from Antivirus Scanning

by Leave a Comment

No matter how fast your computer system hardware may be there is always room for improvement. One way that Sage 100 users have found to improve the speed of their accounting software is by excluding certain Sage 100 files from scanning by antivirus software.

Sage has a published list of the files and file extensions which may normally be excluded from scanning by antivirus software.

Since these file extensions are specific to Sage 100 there is a small risk of infection which leads Sage to recommend their exclusion.

There is a Sage knowledge article available online – How to exclude Sage 100 from antivirus scans.

The article recommends the following antivirus expulsions which may speed up the processing of Sage 100.

In general these exclusions should happen on both the server and workstation.

Update 3/2/2021

Consider testing by temporarily disabling your antivirus product to see if this improves performance: speed, file locking problems encountered, error messages, etc.

If performance improves, exclude the Sage 100 programs, folders, and file extensions from your Antivirus program:

In your Antivirus product:

  • Disable any aggressive or continuous (also known as on-access, constant, or real-time, or “network scanning“) monitoring or scanning of Sage 100 (formerly Sage MAS 90 or 200) programs if they exist:
    • “..\MAS90\Home\Pvxwin32.exe“
    • “..\MAS90\Home\pvxiosvr.exe“
    • “..\MAS90\Launcher\Launch32.exe“
    • “..\MAS90\Launcher\Launcher.old.exe“
  • Exclude the “..\MAS90” directory and sub-directories and contents on the server where Sage 100 is installed.
    • Note: Do the same for the workstations, if using Sage 100 Advanced or Premium editions (formerly Sage MAS 200 and Sage MAS 200 SQL editions)
  • Exclude the following file extensions:
    • AUC, DCL, DD, DDE, DDF, EXP, LCK, LIB, KDF, M4D, M4L, M4P, M4T, M4X, PRM, PVC, PVX, RPT, SOA, XEQ
  • Spa.NA.Com must be a trusted site

Note: It is okay to run nightly scans when users are out.

We advise that you consult with your IT staff prior to making any exclusions. Never disable your antivirus or malware scanners without understanding the risks involved.

WFH Tip For Sage 100: Go Paperless

by Leave a Comment

If your workflow is now like that of many companies you probably have most or all of your staff working from home.

When your staff is working in Sage 100 they are likely printing and updating journals and registers as they go about their regular workday.

These registers require paper and if you are manually printing and requiring staff to come into the office to later file the journals and registers – you are working too hard.

Sage 100 includes a feature called Paperless Office. It’s essentially taking all those journals and registers and automatically saving them as PDF files in a location determined by you.

What’s nice about this feature is that once enabled it automatically saves a copy of the output no matter whether your staff tries to send it to a printer or manually creates a PDF.

Sage has a set of detailed instructions online. These only look complicated as the actual setup is fairly straightforward.

If you decide to setup Paperless Office in Sage 100, here are a couple quick tips.

  • Create a common storage location which will survive upgrades. Don’t embed the saved paperless documents inside the \MAS90 folder or you’ll need to move them ( or keep that old folder ) with each upgrade.
  • Usually what we do is create a folder \acct then inside there have a folder \v20xx for the actual Sage 100, also a \acct\Paperless folder which holds the paperless documents.

That’s it. It’s very easy to automatically saved copies of your journals and registers to PDF automatically which will save your staff from having to manually file those documents.

With a little more setup effort you can also email out invoices using paperless. Some third-party credit card processors also support embedding links inside the invoices so your Sage 100 customers can pay directly from the invoice.

Previously we’ve had some customers dismiss paperless office as an unnecessary step. Now with more companies adjusting to working from home this handy feature is not only included in your product but can provide a very real return on your Sage 100 investment.

Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021

by

For the 2020 tax year, the IRS introduced a new 1099-NEC form. This new form replaces the 1099-MISC for reporting non-employee compensation.

Sage has incorporated this update into accounts payable provided you are using the most recent versions.

What has been missing is the ability to set 1099-NEC boxes in the Purchase Order Module. Initially Sage indicated that this functionality would be added in a future release.

Recently Sage provided guidance on how they would add 1099-NEC functionality for those who rely on purchase orders.

The following Sage 100 versions will receive an update adding 1099-NEC functionality to purchase orders (Estimated release – Spring 2021 ):

Sage 100 2021
Sage 100 2020 Update 2
Sage 100 2019 Update 5

What Are The Differences Between Sage 100 Perpetual and Subscription Licenses?

by

Sage has been urging their Sage 100 customers to migrate their perpetual licenses to subscription since launching Sage 100c in November 2015.

This release was primarily a subscription version of their Sage 100 perpetual license.

Prior to the introduction of subscription pricing, Sage 100 modules had been sold as perpetual licenses meaning a company would pay a larger up-front initial license fee and a somewhat optional annual maintenance fee which covered upgrades and Sage support.

While the ongoing costs were typically the same the subscription ( Sage 100c ) version offered a much lower initial purchase price.

The biggest difference initially between perpetual and subscription was that if you stopped paying your subscription license fee the Sage 100c offering would go into read-only mode.

Over time Sage adjusted their subscription offer. First, by rebranding Sage 100c as Sage 100cloud in November 2018. Next Sage signaled that they would likely do away with the confusion over the cloud brand and simply refer to their Sage 100 offers by three broad brands.

  1. Sage 100 Perpetual
  2. Sage 100 Subscription
  3. Sage 100 Partner Cloud ( Subscription – partner-hosted on Azure )

What Are The Differences Between Sage 100 Perpetual and Subscription

Sage 100 Perpetual offers a somewhat limited number of modules than either Sage 100 Subscription or Sage 10 Partner Cloud.

The biggest current feature difference is that Sage 100 Subscription ( including Partner Cloud ) offerings provide access to multiple bin usage for inventory items.

Many companies assign multiple bin numbers to the same inventory items for a variety of reasons – including inspection, committed quantities, and other requirements.

The most important distinction between the perpetual and subscription license is that Sage indicates perpetual licenses will receive maintenance and compliance updates only.

New feature releases will focus on enhancing or developing features for Sage 100 subscription licenses only.

Here Are The New Features Added To Sage 100 Subscription Only In 2020 and 2021

During 2020 and 2021 Sage has added a number of new features which are exclusive to their subscription license.

Some of these features – such as pre-defined role security templates – are slated for release in the upcoming 2021 release.

Prior to Sage 100 2020, there were a number of features and add-ons which were exclusive to subscription – including

Moving forward all of Sage’s development efforts for Sage 100 will center on the subscription version of the solution which is less costly to acquire and also less expensive in most cases to add or remove user licenses.

For more information on the new features in Sage 100 subscription please see this Sage brochure.

1169452_Sage100_ComparisonGuide_2020Download

Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020

by

Early e-filers of W2 forms may have erroneously received a notice from Aatrix that their 2020 Sage 100 payroll files contained erroneous social security information.

The message indicated that the employee SSNs could not be verified by the IRS and that the company submitting the file should verify that the correct SSN were submitted.

Later in the day Aatrix began to notify users that the message had been sent to some in error and there may not be any issue with the social security number validation.

Aatrix advises that if you have received a message indicating SSN mismatches that you can use the following instructions to verify your filing:

To view Filing Status:

  1. Navigate to https://efile.aatrix.com/ 2. Click on Log In in the upper right corner 3. Login with your eFile username and password 4. Click on the Filings Tab
    a) Open Status: One or more parts of the filing are not complete.
    b) Closed Status: All parts of the filing has been confirmed as complete or the filing was manually closed through the Aatrix online account.
    c) Deleted Status: The filing is deleted and no part of the filing will be processed.
  2. Click on the Details Link for the appropriate AFID number in the filings list.
  3. In the additional details for the filing, each part of the filing will be listed with a status:
    a) Awaiting Batch Processing: Not yet submitted to agency.
    b) Rejected: Reason for rejection will be displayed.
    c) Not Confirmed: Submitted to agency, but not yet confirmed.
    d) Accepted: Submitted to agency and confirmed as received/processed.

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.