Overcome these errors when using a Multiselect Lookup Type with a Pass Through variable

In our last tip we showed you how to use a Code Description pair to make your lookups more descriptive.  The same principle can be applied when using a Pass Through Variable in your reports. Although standard Expressions and Pass Through Variables include some of the same lookup types, the Pass Through variable also has […]

Continue reading


How to reduce the size of your Report Designer workbook allowing for a faster run time

The Report Designer is a powerful tool designed to meet your financial reporting needs.  Based on your company data, the resulting workbook can be large in size and depending on your requirements, a lot of the information it contains may not be necessary. Take the example of a report writer we worked with recently.  Using […]

Continue reading


How to format your financials when distributing your reports using the Excel TEXT Function

You’re probably aware that when distributing reports via email, you can reference cells from the layouts you’re sending in your email body.  This is useful, for example, if you want to provide a summary of your report for your recipients. This is useful, for example, if you need to provide a summary of your report […]

Continue reading


Learn how to use your Sales report to create a sales commission calculator

One of the features that customers often look for in an accounting or sales software package is the ability to calculate commission. Generally, sales reps earn a percentage income for any sales they produce in a given period, this income is referred to as commission. Not many accounting software packages built for small businesses calculate […]

Continue reading