The next release of Microsoft Dynamics GP, Microsoft Dynamics GP 2015 R2, is due to arrive in June, and we’ve been looking at some of the new features that will be delivered. In our last couple of entries, we’ve looked at the following new features:
- All-in-one document viewer for purchasing
- Payables transaction approval workflow
- Employee self-service access to their W2
- Scriptable provisioning and management
Today let’s put the spotlight on another new feature, analytical accounting transaction lists.
This feature brings improvements to SmartLists and Excel reports for analytical accounting transaction data. There will now be a greater amount of information available to be included as columns in the analytical accounting SmartLists and Excel reports. Analytical accounting tracks a great deal of information for each record, and now more of this data will be included in SmartLists and Excel reports.
Microsoft has also improved the way analytical accounting dimension code information is displayed in the lists. Before, the lists contained a single column for the analytical accounting transaction code, so if a company is tracking more than one dimension on a transaction, multiple lines are required in the list for distribution entry. Now with Microsoft Dynamics GP 2015 R2, SmartLists and Excel reports have been updated to display a column for each transaction dimension, showing the code assigned for that dimension. As an example, the SmartList pictured below shows how the list would be displayed for a company that is tracking Cost Center and Project as analytical accounting dimensions.
This change in data display improves the readability of the report, and it also improves the ease with which users can summarize and work with data in Excel using pivot table functionality.