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

August 2022 News & Tips

Sage 50 2013 - 2019 activation problem reminder. Upgrade by 8/31/22 and get free installation.   Receive inventory in Sage 50 before you have an invoice using the Waiting On Bill option.   Easily fill in blank cells from the cell above


Now Is A Good Time To Upgrade: Order your upgrade by 8/31/2022 and I'll install your software for free! This is just a reminder of the problem Sage warned us about a few months ago. "Due to a third-party database component that is no longer supported, Sage 50 US users will be unable to install and activate Sage 50 US versions 2013 through 2019."

That doesn't mean your software will stop working, but you won't be able to move it to a new computer. And if you have a problem that requires Sage 50 to be reinstalled, you will not be able to do so. So I encourage everyone on version 2019 or older to be proactive and upgrade now to avoid down time. Your purchase includes 1 year of upgrades and updates. So you can purchase now and still receive version 2023 when it releases later this year.

Both traditional perpetual licenses and subscriptions are available at 20% off list price for new customers, or existing customers on versions 2019 or older. Version 2015 or older will not convert automatically to version 2022. I can convert that data for you for $50 per company.
  Perpetual License Subscription (Sage 50cloud)
  List Price 20% Off List Price 20% Off
Sage 50 Pro Accounting                        620.00                        496.00                        567.00                                    453.60
Sage 50 Premium Accounting 1-User                        889.00                        711.20                        924.00                                    739.20
Sage 50 Premium Accounting 2-User                     1,185.00                        948.00                     1,168.00                                    934.40
Sage 50 Premium Accounting 3-User                     1,482.00                     1,185.60                     1,463.00                               1,170.40
Sage 50 Premium Accounting 4-User                     1,778.00                     1,422.40                     1,821.00                               1,456.80
Sage 50 Premium Accounting 5-User                     2,075.00                     1,660.00                     2,116.00                               1,692.80
Sage 50 Quantum Accounting 1-User                     1,719.00                     1,375.20                     1,533.00                     1,226.40
Sage 50 Quantum Accounting 2-User                     2,463.00                     1,970.40                     1,908.00                     1,526.40
Sage 50 Quantum Accounting 3-User                     3,209.00                     2,567.20                     2,282.00                     1,825.60
Sage 50 Quantum Accounting 4-User                     3,951.00                     3,160.80                     2,654.00                     2,123.20
Sage 50 Quantum Accounting 5-User                     4,695.00                     3,756.00                     2,874.00                     2,299.20
Sage 50 Quantum Accounting 6-User                     5,440.00                     4,352.00                     3,016.00                     2,412.80
Sage 50 Quantum Accounting 7-User                     6,182.00                     4,945.60                     3,171.00                     2,536.80
Sage 50 Quantum Accounting 8-User                     6,929.00                     5,543.20                     3,467.00                     2,773.60
Sage 50 Quantum Accounting 9-User                     7,672.00                     6,137.60                     3,609.00                     2,887.20
Sage 50 Quantum Accounting 10-User                     8,737.00                     6,989.60                     3,912.00                     3,129.60
Sage 50 Quantum Accounting 15-User                   10,270.00                     8,216.00                     4,202.00                     3,361.60
Sage 50 Quantum Accounting 20-User                   12,138.00                     9,710.40                     4,498.00                     3,598.40
Sage 50 Quantum Accounting 30-User                   13,625.00                   10,900.00                     5,980.00                     4,784.00
Sage 50 Quantum Accounting 40-User                   15,114.00                   12,091.20                     7,461.00                     5,968.80

Steve Collins
IQ Accounting Solutions LLC

A complete archive of these tips is available at

Sage 50/Peachtree Tip - Waiting On Bill

In real life, receiving inventory and receiving the invoice for that inventory are often two separate events that occur days, or even weeks apart. But in Sage 50 both happen in one transaction. Sometimes waiting for the invoice to get the inventory in Sage 50 is fine. But what about the times you are waiting for that inventory to fill orders?  You could invoice the customer and let your Sage 50 inventory go negative. But most people recommend you avoid negative inventory. This is where the Waiting On Bill option comes in.

In the Purchases/Receive Inventory (Enter Bills) window, below the Invoice No field there is a check box labeled Waiting On Bill. When you need to receive inventory without an invoice, enter everything just like you would if you were entering the invoice except you will leave the invoice number blank and check Waiting On Bill. This is the only way you can save a purchase without an invoice number.  Now your inventory will be updated so you can enter sales invoices for those items.

When the vendor's invoice arrives, go back to Purchases/Receive Inventory and click the List button. Find the transaction from the previous step and double click to open it. If you click twice on the Waiting On Bill column heading in the list, the waiting transactions will be sorted to the top of the list so they are easier to find. Once you have opened the transaction, enter the invoice number and uncheck the Waiting On Bill box. Review the details and make any needed changes.

Up to that point everything is pretty simple, but now there are some important considerations and they all revolve around the invoice date. If the invoice date is not the same as the date you used when receiving the inventory, changing it will move the inventory receipt to the invoice date. That means your previous sales invoice could now push your inventory negative even though it didn’t when you entered the sale. Because of that I recommend leaving the date alone and manually adjusting the due date in the Terms field so it will get paid at the right time.

If the invoice didn’t come in until the next month you could have more issues to deal with. If the amounts on the invoice are different than the amounts originally entered, changing them will change balances in a prior month. When, for reporting reasons, you can’t allow the prior month to be changed, the only thing you can do is leave the amounts as they were originally entered and post a new invoice for the difference in the current month. Do not use inventory items on that invoice unless item quantities need to be adjusted. Otherwise just post the dollar amount to a GL account – typically COGS.  But check with your CPA to see what account they want you to use.


Excel Tip - Easily fill in blank cells with data from the cell above

You're probably thinking "of course it's easy, just copy it." But sometimes you have data laid out like the example below. The customer name and sales rep have only been entered when the data changes. This way they act like headings and make the report easier to read. But if you want to sort this list, filter it, or use the insert subtotals as described in a previous tip, you need all of the information on every line. That's a tedious process when done line by line.
Customer Sales Rep Date Invoice/CM # Amount Due
Aldred Builders, Inc. DGROSS 42415 10129 4426.94
    42444 10220 66.72
    42444 10345 42.39
    42451 10360 13.73
Snowden Interior Design SPRICHARD 42395 10209 7102
    42416 10325 59.98
  DBECK 42440 10306 184.29
Chapple Law Offices DGROSS 42430 10256 693.7
    42443 10341 37.1
    42444 10313 199.96
    42444 10335 180.09
Archer Scapes and Ponds BNUNNLEY 42423 10209 7374.69
    42433 10329 59.98
    42444 10317 49.99
    42444 10320 -49.99

Combining a few Excel tricks turns this into an amazingly easy process. The basic steps are:
  1. Select all of the empty cells
  2. Enter a formula in each of those cells at once that points to the cell above it
  3. Convert the result of the formula into text.
To select the empty cells, use the Go To command either by pressing the F5 key or pressing Ctrl+G. In the Go To window click the Special button, then choose Blanks and click OK. You should now have only the blank cells selected. If it selected cells outside of the range you wanted, manually select the entire range, then repeat those steps to select just the empty cells within that range.

To enter the formula, with the empty cells still selected, type an equal sign and then press the up arrow key. In the sample spreadsheet above you would see =A2 in the first blank cell. You should see something similar in your spreadsheet. Now press Ctrl+Enter, that is, hold down the Control key (usually shortened to Ctrl) and then press Enter. That will enter the formula into the first cell and simultaneously copy it into all of the other selected cells.

Now you just need to convert the formulas to text. Manually select the entire area that contains the new formulas. In most cases it's easiest to select all the columns or press Ctrl+A to select the entire spreadsheet. Now copy the selected the cells (Ctrl+C or right click and choose Copy). Then right click anywhere in the selected area, choose Past Special, and then Paste Values. Your formulas have now been replaced with the text, numbers, dates, etc. that were the result of each formula.

One warning about the last step is that every formula in the copied range will be converted to a value. So if you have some formulas that you wanted to preserve you would need to be careful not to select those cells before performing the Copy/Paste Special step.


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 or send me an email at 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
10611 E 17th Place
Tulsa, OK 74128
Copyright © 2022 IQ Accounting Solutions LLC, All rights reserved.
Email Marketing Powered by Mailchimp