Microsoft Dynamics NAV 2013 provides several new reporting enhancements that take advantage of the tight integration with Microsoft Excel and other Microsoft technologies to help boost productivity among more users and drive decision-making processes for better control. These enhancements include:
EXCEL ADD-IN FOR AD-HOC REPORTING
This is a smart new Excel Add-In that is an extension to the existing send-to-Excel functionality in NAV. A new refresh capability is available when creating ad-hoc reports in Excel. You can integrate with Microsoft Excel to produce Excel-based reports that use Microsoft Dynamics NAV pages as data sources. The data in Excel is provided in a data region format so that you can create PivotTables and reports. You can refresh the data in your Excel report to reflect updates that are made in Microsoft Dynamics NAV. This makes it easier for more users to take advantage of the rich data in NAV and the powerful analytical capabilities of Excel to create ad-hoc reports.
EXCEL INTEGRATION TO QUERY
New OData Web services capabilities in NAV 2013 enables customers and partners to take advantage of the robust analytical tools in Excel, such as PowerPivot and other tools, to perform more advanced business data analysis scenarios by extracting complicated data sets using queries. NAV 2013 delivers some standard queries out of the box, but the Excel integration to query and OData Web services in NAV 2013 enables partners to more easily build new queries to suit the specific reporting and analytical needs of their customers.
ITEM AVAILABILITY BY TIMELINE
Microsoft Dynamics NAV 2013 delivers new business data visualization capabilities, including Timeline Visualization, which provides a unique way to view and analyze business data in Microsoft Dynamics NAV, such as Item Availability.
The Item Availability by Timeline window shows a graphical view of the expected inventory level for a specific item or stockkeeping unit over time. Users are able to get an immediate overview of projected inventory and quickly understand the planning suggestions. Drag and drop functionality enables users to optimize suggestions easily. Item Availability by Timeline functionality gives customers an effective way to optimize ordering and inventory cost for improved control and better margins. A flexible tool, this feature helps customers to respond quickly to changes in demand.
ITEM AVAILABILITY BY EVENT
The Item Availability by Event window shows projected inventory figures by demand or supply event. The window only has information about the dates when figures change because of an event, such as a sales order or purchase order. You can filter the Item Availability by Event window to also include forecasted figures and planning suggestions. Users have much easier access to and visibility of data and the event changes when they occur, enabling greater control.
Next Steps: Visit our Microsoft Dynamics NAV 2013 Website