Year-end closing is quickly approaching and we know that it can be the busiest time of year and add extra stress to your work life. Luckily, we’ve gathered some great tips and tricks from Sage to help make the process go a little smoother. Read on to learn about these…
Working within the Sage 100 Enhancements department at DSD Business Systems, I commonly get the question, “What should I do when I have a problem or error with an Enhancement or Extended Solution?” This blog will help guide you through the steps of what to do when you encounter an…
Effective project management requires transparent communication. Technology, process, and product implementation depends on the ability of each project contributor’s ability to connect with decision makers and make things happen. Project managers and contributors can all benefit from effective communication practices to streamline implementation processes and boost employee adoption rates. The…
Do you have a large set of data you need to manipulate? Are you looking to improve the functionality of your financial spreadsheets? If so, Pivot Tables might be a great solution. They’re one of Excel’s most powerful features, so if you don’t yet know how to use them, you’re…
As you plan for year-end closing with Sage 100, you likely already know that the Inventory Management portion of the close-out process is one of the most important and most time-consuming. Fortunately, the whole point of Sage is to help make inventory management and the entire year-end closing process run…
DSD Business Systems recently switched over to a new in-house ERP system and I was part of the in-house ERP implementation team, a role that involved making sure all parts of the implementation were completed, allowing for a smooth transition. During this time, I was able to grow from the…
Who isn’t stressed these days? Technology is bombarding us from every direction, recent economic twists and turns have made layoffs far too common, and then, there’s our actual work: projects, deadlines, coworkers and bosses. And that’s just during business hours! Fortunately, there are things you can do can do to…
1. Not Making A Backup This mistake is so simple and inexpensive to avoid. Everyone backs up their files, right? You’d be surprised at the number of Sage 100 disaster recovery projects we undertake in a year. Whether it’s a physical disaster, such as flood or fire, or a technical…
1. VLOOKUP VLOOKUP stands for Vertical Lookup and can be a really handy tool if you’re looking for specific information in a list or table and want to save time. Instead of reading through the whole list or table, simply find a cell where you can enter a VLOOKUP formula….
1. Simultaneously Format Multiple Pages Sometimes when you’re formatting a worksheet in Excel, you know you’re going to want to format a second or third worksheet the exact same way. Doing that manually seems tedious and unnecessary – and it is! You can actually use Excel’s grouped worksheets feature to…
