GP Reporting

This content is classified under GP Reporting.

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.

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:

Excel Budgets – did you know?

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

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

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.

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:

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.

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.

Finding SQL tables for Microsoft Dynamics GP

At times, the Resource Descriptions can be a useful tool when figuring out a table name. However, it can be difficult to track down the exact table needed if all you know is the GP window.

Tips for 1099 Reporting in Dynamics GP

Time is tight to generate 2012 1099s. As a Microsoft Dynamics GP user, relying on the canned 1099 Smartlist report is not recommended. 1099s generated using this canned report are not always accurate. So, how best to get 1099s generated in the next few days that you can be more confident in? Follow these detailed tips to use Smartlist Builder and check 1099 reporting off your To DO list!
Subscribe to RSS - GP Reporting