Since Sage 50/Peachtree allows you to have two years open, this is the time of year when most people close out the prior year so they will be ready to go for next year. Even though most reports can be run for closed years, it’s a good idea to make a copy of your Sage […]
A few months ago I explained how to use the Excel functions Left, Mid, or Right to to pull information from the beginning, middle, or end of another cell’s contents. That prompted this question from a Youtube viewer: I’ve got a slightly different challenge: I need to extract numbers from a single cell which reads […]
Just because you enter transactions one at a time,doesn’t mean you have to print them one at a time. You have a choice between printing them individually from the related transaction entry window or printing them as a batch. The key to printing forms in a batch is to leave the transaction number (invoice number, […]
Usually we think of adding numbers on a spreadsheet, but sometimes you just need to count the items in a list. If you have tried to use Excel’s COUNT() function you may or may not have gotten the results you wanted. There are two very similar functions in Excel: COUNT() and COUNTA(). The difference between […]
One advantage of Sage 50 Quantum over Premium is the ability to have more than 5 users (up to 40 actually). But the more users you have, the bigger nuisance it is when you have to get everyone out so you can perform a single user function such as changing periods, making a backup, or […]
Have you ever found yourself entering the same text or the same formula on multiple tabs of an Excel workbook? You don’t have to go to all that trouble. You can enter text, numbers, of formulas on multiple tabs at the same time. Just click on the first tab you want to use then hold […]
Emailing invoices out of Sage 50 (formerly Peachtree) is a huge time saver. But Sage 50 only lets you email one invoice at a time and sometimes you need to send multiple invoices to a customer. You could send each one in a separate email. Or you can send each invoice to an email but […]
Last July I explained how to void and replace a payroll check in Sage 50/Peachtree. One year later Sage has added a new feature in version 2015.1 that allows you to accomplish almost the entire process with one click. If you need to replace a payroll check, open the original check in Payroll Entry. Click […]
Charts and can help show trends that are hard to pick out of a large table of numbers. But often you need the detail that is on those numbers. What if you could have both at the same time? That is where Sparklines come in. They are mini charts that fit within a cell in […]
When Sage released version 2015 of Sage 50 (Peachtree), they said that they intended to start providing updates year round instead of just once a year. On July 9th 2014 we saw the first installment on that promise. If you are wondering what was in that update that popped up a couple of weeks ago, […]
