If you sell variations of the same item, such as a shirt that comes in different sizes and colors, master stock items will make your inventory easier to manage. Master stock items work in conjunction with substock items, with the master item functioning like a heading for the sub items. The master stock item is […]
Archive for category All
If need to know the number of days between two dates, that is very easy to do in Excel. Just subtract one date from the other. For example if cell A2 has an invoice date in it of 1/1/2015 and cell B2 has a date paid of 1/30/2015, then you could enter use the formula […]
Many times when you are looking at a transaction in Sage 50, you need a quick way to locate related transactions. Maybe you need to see the payment related to an invoice. Or you might want to know which sales order number a quote was converted into. In most cases the information you need is […]
Do you ever get tired of removing or fixing a cell’s borders after you copy something in Excel? It’s really frustrating to discover that your last minute copy placed some random cell borders in your otherwise neatly formatted spreadsheet, or that the cells you pasted into the middle of a table have no borders even […]
Several states, including California and Massachusetts, have passed laws mandating paid sick leave. Under many of these plans, the sick time benefit is based on actual hours worked. Even though Sage 50 doesn’t offer that method out of the box, I can customize the sick time formulas for you so they will calculate based on […]
Since Sage 50/Peachtree allows you to have two years open, this is the time of year when most people close out the prior year so they will be ready to go for next year. Even though most reports can be run for closed years, it’s a good idea to make a copy of your Sage […]
A few months ago I explained how to use the Excel functions Left, Mid, or Right to to pull information from the beginning, middle, or end of another cell’s contents. That prompted this question from a Youtube viewer: I’ve got a slightly different challenge: I need to extract numbers from a single cell which reads […]
Just because you enter transactions one at a time,doesn’t mean you have to print them one at a time. You have a choice between printing them individually from the related transaction entry window or printing them as a batch. The key to printing forms in a batch is to leave the transaction number (invoice number, […]
Usually we think of adding numbers on a spreadsheet, but sometimes you just need to count the items in a list. If you have tried to use Excel’s COUNT() function you may or may not have gotten the results you wanted. There are two very similar functions in Excel: COUNT() and COUNTA(). The difference between […]
One advantage of Sage 50 Quantum over Premium is the ability to have more than 5 users (up to 40 actually). But the more users you have, the bigger nuisance it is when you have to get everyone out so you can perform a single user function such as changing periods, making a backup, or […]
