Customer over-payments don’t happen often, but do you know how to deal with them when the situation arises? I’ll also explain how they are affected by a new feature in version 2014.
Archive for category All
Nobody likes to see #DIV/0!, Excel’s divide by zero error, on their spreadsheet. But there is no option to suppress it and sometimes your data makes the error inevitable. Fortunately you can use the IF function to hide or replace the divide by zero error message.
Sage 50 2014 has arrived. I think most people will be happy with the upgrade even though it doesn’t have the type of big new features people often look for in a new version. Instead this release focuses on making the things you’re already doing easier, and it accomplishes that without making you relearn how [...]
Split View in Excel
Apr 22
Using the Split feature allows you look at different parts of an Excel worksheet at the same time.
Setting up multiple ship-to addresses for customers in Sage 50 (formerly Peachtree) is simple once you understand how to ship-to addresses relate to contacts.
Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen. This month I’ll show you how you can choose rows or columns to appear on every page when you print.
Thanks for 5 Great Years
Mar 1
Today marks 5 years since IQ Accounting Solutions opened for business. We’ve all heard the statistics about the survival rate of small businesses, so I am very happy to have reached this milestone. Part of the reason I enjoy doing what I do is because I get to help all of you beat those odds [...]
Sage 50 defaults to saving your backups in the same folder your data is in – not very helpful if that hard drive fails. Here is an easy way you can save your backups to a different location.
Freeze Panes lets you keep row and columns headings visible as you scroll through a large spreadsheet.
If you have ever tried to open a task in Sage 50/Peachtree and it showed up on the Windows task bar but no window ever appeared, don’t worry. You can usually solve the problem with a few simple keyboard commands.
