Until last month when Sage released the 2017.1 update to Sage 50, sending invoices or other forms and reports by email required you to have a MAPI compliant email program such as Outlook or Thunderbird installed on your computer. If you wanted to send email using a web based email client, such as Gmail or […]
Using Webmail with Sage 50
Dec 22
I’ve heard from many Sage 50 users confused by the calls they get from Sage sales reps trying to get them to switch to Sage 50c, now also known as Sage 50cloud. The first thing you need to know is that you do NOT have to switch if you don’t want to. Here’s my summary […]
Have you ever tried to copy numbers from one spreadsheet to another, only to discover that the cells you copied actually contained formulas? When you pasted them into the new location, each cell had an error instead of the number you wanted. Here are 3 different ways you can convert a formula into the number that is the result of that formula.
Some people have experienced a problem running Sage 50 after installing the 2017.1 update. In the cases I’ve run across, Sage 50 opened without a problem after the installation finished. But the next time they try to launch Sage 50 they get the error “Sage 50 Accounting has stopped working.” All I’ve been able to […]
Sage 50 2017.1 New Features
Nov 21
On November 16, 2016, Sage 50 U.S. released the 2017.1 update to Sage 50. Sage is following through with their plan to provide additional cloud and mobility features in the Sage 50c (subscription) variant of the product, differentiating it from the traditionally licensed Sage 50. For some users, the additional features could make it worth […]
Excel – Worksheet Protection
Nov 11
If you want to keep part or all of a spreadsheet from being changed, you need Excel’s worksheet protection feature.
To save you time, Peachtree can create purchase orders for you, either to fill specific sales orders, or to replenish low inventory.
Most Excel users know how to use the SUM function to get the total of a group of numbers. But did you know that Excel also gives you the ability to total just the numbers that meet your conditions?
IF YOU USE THE “ALWAYS NOTIFY” FEATURE FOR CUSTOMERS, DO NOT UPGRADE TO VERSION 2017 YET! If you have been waiting to upgrade to version 2017 of Sage 50, you may want to wait a little longer. In my Sept 2016 newsletter I said that I hadn’t found any significant problems in Sage 50 2017 […]
Excel’s IF FUNCTION
Sep 30
If you what you want to display in a cell on a spreadsheet, or if the formula that you use needs to vary depending on the contents of a different cell, then the IF function is just what you need.
