February 2018 News & Tips
NEWS |
|
SAGE 50 |
|
EXCEL |
Introducing Sage50cloud
10 Years of IQ Accounting Solutions |
|
Customize the default text used when emailing invoices or other forms |
|
Forcing Page Breaks |
News
Introducing Sage50cloud: As part of Sage's new
Sage Business Cloud initiative, Sage has announced Sage50cloud. Here are some common questions and answers about this exciting new development:
Q: Is Sage 50 now being offered as a cloud product?
A: No.
Q: Is Sage 50cloud just the new name for Sage 50c?
A: Yes.
Q: If it's still a desktop product, why is it named Sage50cloud?
A: Sage changed the name to emphasize that Sage 50 is, in their terms, a "connected cloud" product. That is, a desktop product that you already know and trust that has links to cloud offerings such as Sage One (AKA Sage Business Cloud Accounting), Sage Drive, and Microsoft Office 365. Oh, and marketing people think you can sell anything if you slap the word "cloud" on it.
Q: If this is just another product renaming, why is it exciting?
A: Sage said it was, so it must be. Plus if the cloud offerings continue to mature, they have the potential to add genuinely useful new functions.
IQ Accounting Solutions 10 Year Anniversary: The end of February will mark 10 years since I started business as IQ Accounting Solutions. I'd like to thank every one of my customers for helping make this business a success. Some of you are very new, and others I worked with long before I started my own business, but I genuinely enjoy working with all of you and look forward to seeing what changes the next 10 years (and more) will bring to this industry.
Steve Collins
IQ Accounting Solutions LLC
918-851-9713
scollins@iqaccountingsolutions.com
www.iqaccountingsolutions.com
Sage 50/Peachtree Tip - Customizing Default Email Text in Sage 50
Do you email invoices, quotes, purchase orders, or other forms out of Sage 50? Have you ever wished you could change the standard text that Sage 50 puts in those emails? We'll you can, and it's really easy to do.
Open the Maintain menu and choose
Email Setup. In the Email Setup window select a form from the list. Choices are:
- Invoices
- Quotes
- Proposals
- Receipts
- Credit Memos
- Customer Statements
- Purchase Orders
- Sales Orders
After selecting a form, the current email message text for that form shows in the
Message for Transaction Type box. Simply type whatever you want in that box and click the OK button when done to save your changes.
While you can enter any message you want, you are limited to plain text. You won't find even basic formatting options like bold or italics. You can't use HTML. And you can't insert a field, such as customer name, to make the message content dynamic.
I don't know how much text you can enter because I got tired of counting before I ran out of room. But I'm confident it will handle even the longest signature lines and legal disclaimers.
Forward To A Friend
Excel Tip - Forcing Page Breaks
Sometimes page breaks fall at inconvenient places in your spreadsheet. But you can do more than just adjust your margins. Excel allows you to insert and even move page breaks. I'll show you two methods for controlling page breaks in your Excel workbooks.
First we'll cover the old-school method. It's simple but effective. Just put your cursor on the line that should begin a new page. Select the
Page Layout tab on the ribbon. Click the
Breaks button and choose
Insert Page Break. If your cursor is in column A, the page break will be inserted between the current row and the row above it. If you are in any column other than A, Excel will also insert a vertical page break to the left of the current column. You can remove a page break by positioning your cursor immediately below a horizontal page break or to the right of a vertical page break and choosing
Remove Page Break instead of
Insert Page Break. The
Breaks button also includes an option to reset all page breaks.
The other method takes a more visual approach. Click on the
View tab on the ribbon and select the
Page Break Preview button. The view will change slightly, allowing you to see only the printable area, and blue dashed lines will appear representing the automatic page breaks. Solid blue lines represent manually inserted or adjusted page breaks. You can drag any of those lines to adjust the page breaks. If you move a page break to put less on a page, the other automatic page breaks will simply shift an equal distance (manual page breaks will not be changed). But if you move a page break to make more print on a page, Excel will automatically scale down the print size as needed to fit everything onto the page. If you want to undo all of your changes the
Reset All Page Breaks option from the
Breaks button on the
Page Layout tab works regardless of which method you used to set the page breaks.
Forward To A Friend
If you know other Sage 50/Peachtree users, do them (and me) a favor and pass this along to them. If you are someone that this has been passed on to, and would like to be added to my email list, you can subscribe for free at
www.iqaccountingsolutions.com/signup.html or send me an email at
newsletter@iqaccountingsolutions.com. If you need to change your email address or would like to unsubscribe, you can use the links at the end of this email.
Steve Collins
IQ Accounting Solutions LLC
918-851-9713
10611 E 17th Place
Tulsa, OK 74128