Archive for category All

UNIT OF MEASURE CONVERSIONS

Unit of measure conversions allow you to buy, stock, and sell the same product in different units of measure. So if you need to buy something by the case and sell if buy the each, this is the feature you have been looking for.

Creating a Simple In-Cell Bar Chart in Excel using REPT()

Excel has some powerful features for creating graphs and charts, but sometimes they are overkill. Also, most charts give a view of your information that is completely separate from the original data. But if you have a list with numbers in Excel you can use the REPT() function to easily create a bar chart style […]

New Features in Sage 50 2019.2

Fewer Steps to Print Picking Lists and Packing Slips – After printing a sales order or invoice, a prompt will open asking “Would you like to print another form of this transaction?” Clicking Yes will take you back to the Print window so you can select the format you want to print. If you click […]

Switching Between Open Excel Workbooks

You may already be familiar with using Alt+Tab to switch between open windows. But the more windows you have open the less efficient that becomes. If you’re working in Excel and you want jump to another Excel workbook that’s already open you can bypass all the other programs that are running and just switch between […]

Washington Paid Family Leave in Sage 50 Payroll

In the February 2019 payroll tax update Sage finally released a formula for Washington state’s new Paid Family Leave tax that took effect 1/1/2019. Unfortunately they failed to realize that the new formula uses the Special1 Additional Withholding field, which is already used by the Washington L&I tax, causing the family leave formula to calculate […]

Hide Divide By Zero Errors in Excel Using IF

Nobody likes to see #DIV/0!, Excel’s divide by zero error, on their spreadsheet. But there is no option to suppress it and sometimes your data makes the error inevitable. Fortunately you can use the IF function to hide or replace the divide by zero error message.

Sending Identical Invoices to Multiple Customers in Sage 50

If you have ever spent time entering identical invoices for multiple customer, the Broadcast Invoice feature was made for you.

Setting Up Report Groups in Sage 50

Report Groups allow you to print a group of reports all at once with just a single mouse click.

Use the Split Button to Divide an Excel Worksheet Into 2 or More Viewing Panes

Using the Split feature allows you look at different parts of an Excel worksheet at the same time.

Adjusting Year End Balances for Sick Leave and Vacation in Sage 50

In Sage 50 you can choose whether or not sick leave and vacation can be carried over into the new year. You can also set a limit on the maximum number of hours an employee can accrue. But you can’t set a limit on the number of hours that can be carried over into the […]