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 and find detailed comparisons of each version of Sage 50/Peachtree.

Steve Collins
IQ Accounting Solutions

[Facebook] [LinkedIn] [StumbleUpon] [Twitter]

Sending Sage 50 Invoices to More Than One Email Address

Do you have customers that want you to email invoices to more than one email address but you assumed it can’t be done because there’s no opportunity to select a second contact? Well, there’s a simple work-around, other than manually adding another recipient in Outlook. In Maintain Customers/Prospects, the E-mail field on the General tab […]

Reset an Excel Spreadsheet – Delete your data but not your formulas

Have you ever built a spreadsheet and then wanted to re-use it, say for the next year, but realized you forgot to save a blank copy? That means you have to delete all the data that was entered into the workbook while being careful not to delete any of your formulas. That can be a […]

Sage 50 – A workaround for Item IDs that are too long to see in transaction entry screens.

Many people ask if there’s a way to make the Item ID column wider in transaction entry screens, such as Sales Invoicing and  Purchases/Receive Inventory (AKA Enter Bills). Even though there isn’t, there is a work-around that can work for many people. The basic idea is to add the Item ID to the Item Description […]

Find & Replace in Excel

Excel’s Find and Replace feature lets you quickly update information anywhere in your spreadsheet with just a few clicks.

Sage Summit 2017

Sage Summit 2017: Sage’s annual conference is in Atlanta this year on May 10th & 11th. I’ll be leading 3 roundtable discussions for Sage 50 users.These are designed to be discussion oriented question & answer sessions rather than lecture style sessions. If you’re coming to Summit I’d love to have a chance to meet my […]

Sage 50 2017.2 Update New Features

Sage recently started rolling out the second update (2017.2) to Sage 50 2017. Updates are released gradually to users so that Sage’s servers (and technical support) don’t get overwhelmed. Everyone on a current subscription or Business Care plan should receive the download notification soon. You can also go to the Services menu in Sage 50 […]

NAMED RANGES IN EXCEL

Giving a name to a range of cells can make it much easier to write formulas or jump to a specific location.

Item Sales History By Customer list

Whether you want to know which customers are buying an inventory item or if you want to know which items a customer is buying, the Item Sales History by Customer, hidden in Lists instead of Reports, will help you find the information you need quickly.

Troubleshooting Formulas In Excel With “Evaluate Formula”

When you were in school, your math teacher probably insisted that you show your work to explain how you arrived at your answer. When you aren’t getting the result you expected from a formula in Excel, you can make Excel show you how it came up with its answer by using the Evaluate Formula feature.

Sage 50 Audit Trail Report – Answering Who, What, & When

Have you ever wished you had a way to find out when a transaction was entered into Sage 50 or who entered it? How about a way to find out if something was changed or deleted? Well that’s exactly what the Audit Trail Report is for. To find the report, go to the Reports & […]