Copy
News and tips for Sage 50 (formerly Peachtree), Excel, and whatever other general nerd knowledge I think will help computer users be more productive.

IQ Accounting Solutions LLC

June 2021 News & Tips

 
NEWS   SAGE 50   EXCEL
Sage 50 2022 scheduled for release this July.   Start a new line within the description field of invoices or other transactions.   View multiple tabs of an Excel workbook at the same time.



News

New Version Coming: I don't have any news yet about what new features are in store, but I just got word from Sage that Sage 50 US version 2022 is scheduled to release on July 21, 2021. If you have a current subscription or Business Care Plan you should receive it as an automatic download shortly after that. They usually roll upgrades out gradually to ease the load on the download servers (and the support line).

Steve Collins
IQ Accounting Solutions LLC
918-851-9713
scollins@iqaccountingsolutions.com
www.iqaccountingsolutions.com


A complete archive of these tips is available at http://www.iqaccountingsolutions.com/blog
 
 

Sage 50/Peachtree Tip - Starting a New Line Within a Description Field


The description field on a Sage 50 invoice can hold up to 160 characters. But if you need a description that long, there is a good chance you'll want to start a new line of text within that description. The enter key will move you to the next field. So how do you start a new line? Ctrl+Enter is the answer. Holding down the Ctrl key while pressing Enter will insert a line break so you can start a new line of text within the same description field. The same key combination works in the invoice note and on other forms such as purchase order or checks, as well as in the Description For Sales/Purchases field of Maintain Inventory Items.

Another use for Ctrl+Enter is to add space between line items. At the end of the description, type Ctrl+Enter twice. Then you will end up with a blank line on your invoice before the next line.




 
 

Excel Tip - View Multiple Tabs From The Same Workbook Side By Side

The worksheets (or tabs) in an Excel workbook are a nearly indispensable tool for organizing data. (I know some of you remember when tabs were a new feature.) But how many times have you repeatedly jumped back and forth between tabs trying to compare information? There's a much better way. You can actually show both (or several) at the same time.

Go to the View tab on the ribbon and click the New Window button. Depending on how your windows are arranged it may look like nothing happened, but Excel will open the same workbook in a new window. Now click the Arrange All button (right next to New Window) and choose how you want your windows arranged. Now you can select a different tab in each window. No more jumping back and forth.

You can even enter or edit data in either window, and all windows will automatically be updated.



 

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
 
Copyright © 2021 IQ Accounting Solutions LLC, All rights reserved.
Email Marketing Powered by Mailchimp