Servers

SQL Server Report Pack for Microsoft Dynamics GP

Language:
English
A set of 8 reports that work with Microsoft Dynamics GP sample database (Fabrikam) and, with some minor changes, can work against existing Dynamics GP 8.0 or 9.0 environments.
  • Version:

    1.0

    File Name:

    SQLReportPackGreatPlains.msi

    Date Published:

    03/31/2005

    File Size:

    14.1 MB

      The SQL Server 2000 Report Pack for Microsoft Dynamics GP is a set of 8 Microsoft SQL Server 2000 Reporting Services reports that work with both the Dynamics GP sample database, Fabrikam.

      With the report pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

      This report pack includes the following reports:

      • Commissions Report
        Shows sales commissions by territory, salesperson, and year. Expand a territory to view sales commissions by a salesperson, or expand a year to view quarterly commissions by territory.
      • Customer Profitability Report
        Shows sales, total profit, and gross margin percentage per customer for the selected year. Expand customer ID to view the sales, total profit, and gross margin percentage by document number.
      • Inventory Value by Site Report
        Shows a bar graph of the value of inventory by site and the total inventory value for the company. Click an inventory site bar to display the Inventory Value by Site. Use the Item Number Report to view items and their total value for that site.
      • Item Quantity Back Order Report
        Shows the quantity of items that are back ordered, quantities that are allocated to purchase orders, and item quantities available for all sites. Expand each item number to view item quantities for all sites.
      • Open Purchase Orders Report
        Shows purchase orders that have not been closed or canceled per vendor or for all vendors. The report also displays in a list view the number, status, and date of each purchase order, along with the vendor assigned to the purchase order. Expand each purchase order to display the line items and the status of each line item.
      • Open Sales Orders Report
        Shows a list of unposted sales orders for a range of customers. The report displays in a list view the sales order number, the date of each sales order, customer information, the requested ship date, and the amount remaining on the order, as well as the salesperson assigned to the order. Expand each purchase order to display the line items and specific information about each line item.
      • Work Center by Weeks - Employee Capacity Report
        Shows the available work centers and the employee capacity of each work center by weeks.
      • Work Center by Weeks - Machine Capacity Report
        Shows the available work centers and the machine capacity of each work center by weeks.

      Note: This software is licensed “as-is.” It is not supported, and you bear the risk of using it. Microsoft gives no express warranties, guarantees or conditions.
  • Supported Operating Systems:

    Windows 2000 Advanced Server, Windows 2000 Professional Edition , Windows 2000 Server, Windows Server 2003, Windows XP Professional Edition

      • Microsoft SQL Server 2000 Reporting Services SP1 or later

      • Microsoft SQL Server 2000 SP3a or later

      • Microsoft Internet Explorer 5.0 or later

      • Microsoft Visual Studio .NET 2003 with Report Designer installed (optional)

      • Sample Database: 92 megabytes

      • Sample Reports: 2 megabytes

      1. Download the file by clicking the Download link (above) and saving the file to your hard disk.

      2. Launch the SQLReportPackGreatPlains.msi program file on your hard disk to start the setup program.

      3. Follow the instructions on the screen to complete the installation.

      4. Additional setup instructions are provided in the accompanying Readme file.


Popular Downloads

Loading your results, please wait...

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers