![[Facebook]](http://www.iqaccountingsolutions.com/blog/wp-content/plugins/bookmarkify/facebook.png)
![[LinkedIn]](http://www.iqaccountingsolutions.com/blog/wp-content/plugins/bookmarkify/linkedin.png)
![[StumbleUpon]](http://www.iqaccountingsolutions.com/blog/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Twitter]](http://www.iqaccountingsolutions.com/blog/wp-content/plugins/bookmarkify/twitter.png)
![[Email]](http://www.iqaccountingsolutions.com/blog/wp-content/plugins/bookmarkify/email.png)
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 [...]
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 2013 and find detailed comparisons of each version of Sage 50/Peachtree.
Steve Collins
IQ Accounting Solutions
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.
Text copied or imported onto a spreadsheet may not be capitalized the way you want. Or if several different people work on the same spreadsheet you may get some people typing in all caps while others use normal capitalization. Excel doesn’t have a Change Case button like Word does, but you don’t have to copy your text to Word to change case and copy it back. Excel has three functions, UPPER, LOWER, and PROPER that you can use to change the case of text.
In Sage 50/Peachtree the error “Exception has been thrown by the target of an invocation” means that there is a problem in the user-maintained tax table. It may mean that the file was damaged. But if the error appeared after a tax update was installed there is another likely explanation.
