sage 100cloud

30 Ways to Fix Sage 100 “Data is not selected for report printing”

October 8, 2019 by Wayne Schulz

If you are working in Sage 100 or Sage 100cloud and encounter the message “Data is not selected for report printing” while trying to print a form or a report then you should look at this Sage knowledgebase article.

This comprehensive article lists 30 different reasons for the “Data is not selected” message as well as links to specific knowledge articles which can help you resolve any problems.

In some cases you may be recieving the message because there truly is no dataa to print ( if , say, your Sales Order has the “print picking sheet” box UN-checked ).

However, there are some other reasons that Sage outlines where you can also run into this issue unexpectedly and the steps to take to resolve the problem and get your Sage 100 form or report printing as expected.

Some issues that this article covers include:

Report settings have been filtered such that there are no eligible records
Corrupted, damaged, or missing SY_ReportEngine.pvc file
Report Settings for one Sage 100 user have changed
Previously known issue that has been patched in latest updates
Return of Goods Entry print box not checked
Data Corruption
Blank Records in the Masterfile that need to be deleted
E-mail PDF Delivery Option is not selected for vendor
Print Invoices checkbox not checked in AR or SO Invoice Defaults
Damaged User profile
“Default Special Items to Drop Ship” selected in SO Options
Using MultiBin and there are items not distributed to bins
Line items on Sales Order are Backordered or Quantity Ordered is zero (0)
SO_SalesOrderPrint.m4t data file may be corrupted
SY_ReportOption.m4t file contains corrupted values after upgrading to version 2015
Bank Reconciliation and Accounts Payable module not Integrated
E-mail was not selected for customer in Paperless setup
History files have been removed due to Years to Retain options
Need to Rebuild Sort Files for Work Order module
Module code was incorrectly entered
Prospect does not have a Customer ID
Reported issue which Sage Engineering is Currently Reviewing

For a full list of the issues related to this printing message please visit the Sage knowledgebase here – Error: “Data is not selected for Report Printing”

These Are The Supported Versions of Sage 100cloud As of October 1, 2019

September 30, 2019 by Wayne Schulz

As of October 1, 2019 the following Sage 100cloud versions are eligible for support directly from Sage.

Depending upon the Sage 100cloud version ( these dates also apply to the Sage 100 perpetual license) the level of support varies.

There Are Four Primary Types of Sage 100cloud Support:

Product Updates – Self-instlling bundle of fixes as well as some feature enhancements. These are typically issued on a regular basis throughought the year.

IRD – Interim Release Download – a special annual update which readies the verison of Sage 100cloud for year-end tax processing ( Accounts Payable and Payroll ) – expected release date mid-December 2019

Hot-Fixes – typically quick fixes which are issued urgently to fix a problem when the fix can’t wait until the next product update or when the version may not be eligible for product updates but is eligible for hot-fix.

Phone Support – the longest running support benefit is phone support which allows those with a Sage Business Care plan to call Sage directly.

The official Sage chart outlining the Sage 100cloud product versions which they suppport is available here.

Sage 100cloud Supported Versions – 10/1/2019

Product Updates, IRD, Hot-Fixes & Phone Support

Sage 100 2019

IRD, Hot-Fixes & Phone Support

Sage 100 2018

IRD & Phone Support

Sage 100 2017

If you are using Payroll with Sage 100cloud, this is the last year that Sage 100 2017 will be eligible for payroll updates coming into the 2019 year-end.

Users of the updated Payroll 2.x will want to update to version 2.2 ( expected mid-December 2019 release date ) which will be required for processing payroll taxes for 2019.

Schulz Consulting offers Sage 100cloud Support for one low fixed price. If requested, we can also price in an annual upgrade ( typically every other year ). Contact us here for more information.

Warehouse Wizard Series Parts 4 – 6

July 9, 2019 by Darcy Boerio

Last month we brought you parts 1 – 3 of the six-part “Warehouse Wizard Series”, a joint effort by ScanForce and Sage Inventory Advisor to provide educational content for Sage 100 users who operate warehouses.

Read Parts 1 – 3 of the Warehouse Wizard Series

And now for parts 4 – 6:

Part 4: Incorrect Levels Drive Excess Inventory

While having excess inventory on hand can seem like a safe bet to make sure you can meet demand, it is not cost-effective and can stunt your business’ growth.

On the other hand, you can have the best methodology imaginable in place to optimize replenishment and avoid excess inventory, but if your inputs are wrong, you will still fail. Good decisions start with accurate data.

Read Reducing Excess Inventory to learn about how to address the complexities associated with not having a source of truth for your levels.

Part 5: The Advantages of ABC Analysis

Ranking your items lets you focus on the ones that really matter. Whether they’re high velocity/high value or slow moving/low value or anywhere in between, these criteria can help you make better decisions about where to focus your time and working capital.

Read up on The 5 Advantages of an Effective ABC Analysis to learn how these classifications can lead to increased profits.

Part 6: Free Tools for Sage 100cloud to Optimize Inventory

Your Sage 100cloud subscription comes with a number of free tools that were previously only available for purchase. Two of these products that are included “out of the box” are:

DSD/ScanForce Multi-Bin Basic by ScanForce
Sage Inventory Advisor Basics by Sage Inventory Advisor

Are you taking advantage of these features you already own? The infographic shows some of the functionality available to help you optimize inventory without purchasing any additional software.

That’s it for the series. Thanks for reading along! You’re a Warehouse Wizard!

Contact ScanForce or Sage Inventory Advisor if we can be of assistance with any of the initiatives you learned about in the series.

Sage Abra Suite End-Of-Life FAQ

June 20, 2019 by Wayne Schulz

Sage recently announced end-of-life for their Sage Abra Suite. This has resulted in some questions about the process including when support and sales will end for this HR product.

HOW DO I KNOW IF I AM IMPACTED BY SAGE ABRA SUITE END-OF-LIFE?

This change impacts ALL customers who utilize Sage Abra Suite.

2. WHAT DO I DO IF I AM IMPACTED?

We recommend that you discuss your needs with your DSD account manager to review the migration path from Sage Abra Suite to another supported HCM solution.

3. WHAT HAPPENS IF IDON’T MIGRATE?

Sage Abra Suite will continue to function after December 28, 2020. However, you will not be able to receive updates, security fixes, tax, and legislative updates, or access the Sage support center for assistance as of December 28, 2020. This is pertinent because the new tax tables and forms would normally be available prior to year-end reporting, but will now not be available.

4. WHAT IS THE DATE OF THE LAST UPDATE ON SAGE ABRA SUITE?

The final compliance and maintenance update for Sage Abra Suite will be released in September 2020.

5. WHAT IS THE LAST DATE SAGE SUPPORT WILL HELP WITH ABRA SUITE?

The final date for Sage to support Abra is December 28, 2020.

6.WHAT IF MY RENEWAL DATE IS AFTER DECEMBER 28,2019?

Sage will prorate your M&S to December 28, 2020.

7. WHERE CAN I ACCESS INFORMATION ON HCM PRODUCTS THAT DSD OFFERS?

Many HCM solutions which integrate to Sage or can be used standalone are featured on our website.

Warehouse Wizard Series Parts 1 – 3

June 13, 2019 by Darcy Boerio

From ensuring that you have an accurate picture of what you have on hand and where everything is to informed decision making on replenishment, there are many moving parts when it comes to managing inventory (pun intended).

The inventory and warehouse experts and Sage Inventory Advisor and ScanForce have teamed up to bring you a series of tips to help you become a “Warehouse Wizard”. For this article, we’ll look at the first three of the six tips.

Part 1: Two Sides of Inventory Management

From managing the physical product through accuracy in receiving, pick/pack/ship, physical counts, and labeling, inventory control is crucial to warehouse efficiency. It’s the foundation that allows you to make informed decisions on forecasting, ordering, and expediting, all in the name of inventory optimization.

In this 5 minute video, Russ Graf of NetStock and Steve Showalter of ScanForce discuss the key components of Inventory Control and Inventory Replenishment, and why even if business is booming, NOW is the time to invest in warehouse productivity tools.

Read the full article and watch “The Two Sides of Inventory Management” here.

Part 2: The Right Items in the Right Place at the Right Time

What if your warehouse had just the right amount of inventory to meet demands? Not too little, not too much, but just right?

Having the right items means faster fulfillment, happy customers, and more sales.

Having them in the right place leads to increased productivity and lower operating costs.

Having them at the right time prevents excess inventory and stock-outs.

And it all leads to increased profit.

Read the full article on how to “get it right” here.

Part 3: Hidden Costs of Inventory Spreadsheets

Who doesn’t love Excel? It’s inexpensive and easy to use. But when it comes to managing inventory, it’s not the right tool for the job.

In this 6 minute video, Russ and Steve expose some of the hidden costs lurking in your inventory spreadsheets, and how using tools designed for Sage 100 users can help you avoid the risks of spreadsheet inaccuracies.

Read the full article and watch “The Hidden Costs of Inventory Spreadsheets” here.

Watch here on the Schulz Consulting blog for parts 4 – 6 coming soon!

Want to learn more about the tools discussed in these tips? Visit scanforce.com or inventoryadvisor.co