Tag "SmartList"

Better Form, Function, and Features with GP Service Pack 2

The Microsoft Dynamics GP 2013 Service Pack 2 not only includes resolutions for numerous items but it also includes new features within Analytical Accounting, Document Attach, Human Resources and Payroll, Smartlist Designer, and Visual Studio Tools.

Read More

How to Create SmartLists for Comprehensive Leave Manager

If Comprehensive Leave Manager is setup to accrue leave time during payroll processing, the system will calculate the leave time during the build and calculate process. After calculating whether a user would like to validate the leave accruals for employees, a SmartList can be built from the Employee Leave Summary information.

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

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

SmartList in the Toolbar

Do you wish the SmartList was easier to find? Add it to the Toolbar at the top of the Microsoft Dynamics GP window.

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