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 […]
Archive for category All
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). […]
As we approach year end, are you looking for an easy way to get a summary of sales by customer? You have two great choices with the Customer Sales History or the Items Sold To Customers reports. To get to either report, go to to the Reports & Forms menu and choose Accounts Receivable. To […]
Do you get tired of adjusting column widths to fit what you think is your longest entry only to discover when you scroll down that the column needs to be wider? Excel makes it easy to adjust your columns widths or row heights to match your data. Let’s start with the simplest example. If you […]
Sage 50 2024 New Features
Nov 30
In my last newsletter I told you that Sage 50 2024 had released and that it now offered integration with Sage HR. I didn’t go into any details because Sage was a little late on getting those details to me. But here’s my summary of what’s new. In version 2024, Sage 50 payroll users will […]
Last month I talked about how to use Transpose to copy data from a row and paste it into a column or vice versa. This month we’ll look at a fairly new Excel function ToCol() that can pull data from several adjacent rows and columns and combine it into one column. (There’s also a ToRow() […]
Sage 50 2024 New Release
Oct 16
Sage 50 Accounting US Edition 2024 was released on October 16th 2023. As in previous years, Sage 50 will automatically download the update for anyone with a current subscription or business care plan. Once it has been downloaded you will be prompted to install it when exiting Sage 50. Like always, it’s up to you […]
Over the years, customers, vendors, and inventory items come and go. That means lists get cluttered up with obsolete records. While you can’t delete those customers, vendors, or inventory items as long as you still have transactions linked to them, there is an easy way to hide them so they don’t show in the drop […]
