GP Reporting

Easy Sales Tax Collection and Reporting for Small and Medium-Sized Businesses

In the not-so-distant past, it was relatively easy to determine if a company needed to collect sales tax from its customers. Usually, a physical office location in a single state meant that companies needed to collect tax in their home

Read More

Achieve Expense Reporting Nirvana

Let’s face it: Nobody likes doing expense reports! But it is a necessary function of today’s increasingly mobile workforce. Yet, companies continue to struggle with inefficient manual processes that not only provide limited visibility into travel and expenses (T&E) spend,

Read More

Microsoft Dynamics GP 2013 Exporting SmartList to Excel – values have 5 decimal places

After upgrading to GP2013, do some of the field values you export to Excel display differently? We are seeing some issues when exporting the same reports used in prior version of Microsoft Dynamics GP when exporting SmartLists to Excel.

Read More

Microsoft Dynamics GP Enhancement Plans – Which Level is Right for You?

When it comes time to renew your annual Microsoft Dynamics GP Enhancement Plan, you have the option to choose between three plans:

Read More

Excel Budgets – did you know?

Use the following tips to troubleshoot issues that may occur when you use Excel-Based Budgeting:

Read More

GP Miscellaneous – did you know?

Did you know – you can rename SmartList fields in the regular SmartList – click on the columns name and type over the names in the display names portion of the window. With the information populated under the new name – drag the column heading to fit the data and save as a favorite. The Smartlist will fit across the window better

Read More

Electronic Banking for Businesses

There are many, varied impressions and ideas of what electronic banking is and what it can mean to an individual or an organization. In the personal banking world, some people think about accessing a bank web portal to pay utility bills, schedule a recurring mortgage payment, or maybe schedule an amount to be transferred to a savings account each month. Others may think of having a pay check automatically deposited by an employer. Using a credit card to process a payment online is another common example.

Read More

Cannot find file error when using Metrics in GP 2010

Recently, an issue started where users at a company were receiving an error when they clicked on the View button in Metrics to display their chart or KPI in their web browser. The error message was similar to:

Read More

Consolidating Your Databases with Microsoft Dynamics GP and Binary Stream

Many companies today must decide if they can benefit from consolidating multiple company databases that have been added through growth or acquisitions. A client of ours, a flourishing medical and healthcare company, really needed to consolidate all their databases.

Read More

Microsoft Dynamics GP 2013 SmartList Export to Excel values are 0

A customer brought an issue to our attention with Microsoft Dynamics GP 2013 and exporting SmartLists to Excel. Using the Employee default to create a new Smartlist, if you add a column called “Vacation Accrual Amount”, in SmartList after that column is added, the values show up in SmartList just fine. However, when you export the list to Excel the values for this column are zero in Excel. If you export this to Word, the values are there.

Read More