Tag "Excel"

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

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

Refreshable Excel Reports Mean Right-to-the-Minute Data

A high priority on every CFO’s task list is equipping employees with the best tools to gather the correct and most current information in order to make the best decisions with real time results. Using Microsoft Dynamics GP with Smartlist Builder to publish refreshable Microsoft Office Excel reports into Microsoft Outlook is a fantastic way to put a check on that list. With the ability to format the reports to include graphs, arrange information so its best understood by the user, and refresh at any time to gather the most current data – making an informed decision goes from burdening task to smooth solution.

Read More

SmartList Export Solutions

If you regularly export data from a SmartList and format the data using Excel, then you’ll want to learn how to use the Export Solutions tool. This tool allows you to run a macro within Excel on the exported data, allowing you to create calculated fields, charts, or even pivot tables automatically. Not only will this save you time, but it will also add the convenience of having consistent formatting each time data is exported and eliminate human errors.

Read More