Sage has announced a new hosted option for Sage 50. If you’re not familiar with hosting, it means that instead of maintaining the Sage 50 application and data on your workstation and/or server, they are kept on a server that Sage maintains and you access it through your web browser or a special application. This […]
Welcome
Thanks for visiting my blog. The main purpose of this blog is to serve as an archive of the tips that I send out in my monthly email newsletter. Each month’s issue includes a tip for users of Sage 50 (formerly Peachtree) Accounting software as well as any relevant news or announcements. For several months after a new release I also highlight a new feature.
Since most people use more than just Sage 50/Peachtree, I also include a tip for Excel, Word, or some other program that I think people will find helpful. If you like what you read here, click on the link to the right and sign up for my mailing list. Then you can get free tips and tricks in your inbox every month.
Also be sure to visit my main web site where you can take a free test drive of Sage 50-US Edition and find detailed comparisons of each version of Sage 50/Peachtree.
Steve Collins
IQ Accounting Solutions
CTRL+Backspace You’re deep in a spreadsheet typing away and have to scroll to the bottom to look at a number. How do you quickly get back to where you were? Ctrl+Backspace will jump you back to the active cell. CTRL+. You have a large group of cells highlighted and want to move to […]
Date Shortcuts in Sage 50
Apr 29
Knowing how to be efficient in the small things can actually make a big difference in how long it takes you to accomplish tasks and how much you enjoy (or don’t enjoy) using software. One place I see people wasting a lot of time in Sage 50 is entering dates. Opening the calendar and selecting […]
Have you ever wanted to break up text into two or more lines within the same cell of an Excel worksheet? It’s actually really easy to do. Just hold down the alt key and press Enter to insert a line break. Then type the next line of text. Excel will automatically turn on text wrapping […]
As you know by now, Sage did not release version 2025 of Sage 50 on their normal schedule. Sage has released an update to delay the obsolescence message that is built into version 2024. The update is supposed to download and install automatically. If you see a message in Sage 50 v2024 (this does not […]
If you have a report open in Sage 50 and a transaction that affects that report is entered or changed, your report will normally refresh when you click back onto it. But did you know you can stop reports from automatically refreshing? Just go to the Options menu and choose Global. Select the General tab. […]
In September, many people started receiving a script error when opening Sage 50. Sage quickly released a fix for the problem, but only for version 2024. It is supposed to install automatically. But if you use Sage 50 20204 and are still getting the the script error, open Sage 50 by right-clicking on your Sage […]
Here’s a problem I’ve run into before. You have a numbered list in Excel, but you insert or remove entries from the list. Then you have to renumber all the rows, or at least hopefully you remember to do it. What if the row numbers could be automatically maintained? This is where SEQUENCE() comes in. […]
On September 11th 2024, many Sage 50 users started receiving a script error when opening Sage 50. Last week Sage released a fix. The update is supposed to download and install automatically. If you are still getting the error, you can force Sage 50 to retrieve the update by going to the Services menu and […]
Let’s say you have a list of invoices. But what you really want to know is which customers are on that list. You could sort the list by customer name, but here’s an easier solution. In the example below, our original report is in columns A through D. In cell F2, enter the formula =UNIQUE(C2:C8). […]
