The Microsoft SQL Server Report Pack for Microsoft Axapta 3.0 is a set of 8 predefined report definition files that work with a sample database from Microsoft Axapta. You can use the sample reports as templates for designing new reports

This Report Pack includes the following reports:
· CRM Recap
Compiles all customer relations management data for a specified customer into one report, organized by CRM categories. This report provides a complete, up-to-date picture of the interaction that currently exists for that customer.
· Customer Order Delivery Performance
Allows management to measure and report on customer delivery performance in order to improve on-time delivery to customers. The report summarizes shipment deliveries as defined by three categories: on time, early, or late.
· Open Production Orders
Allows management to view the status of open production orders.
· Open Sales Orders
Allows management to review all sales orders for the selected company according to scheduled delivery date.
· Purchase Order Planning
Provides purchasing managers, planners, and buyers with the information they need to place new purchase orders and to make schedule changes to open purchase orders.
· Rolling Invoice
Shows invoice activity (in dollars) for the 12 months preceding a user-defined date. The report compares the YTD invoice amounts for the current year and the previous year. The report is summarized by customer group, with details for specific customers within the group.
· Sub Report - Inventory On Hand
Is a sub-report of the Purchase Order Planning report.
· Sub Report - Open Purchase Order Detail
Is a sub-report of the Purchase Order Planning report.


Requirements:

· Microsoft SQL Server 2000 Reporting Services SP1 or later
· Microsoft SQL Server 2000 SP3a or later
· Microsoft Internet Explorer 5.5 or later
· Microsoft Visual Studio .NET 2003 with Report Designer installed (for uploading or modifying the reports)
· Sample Database: 119 megabytes
· Sample Reports: 819 kilobytes