Print Crystal Report Directly to the printer using VBA

One of my friends asked me about how to directly print the crystal report to the printer using VBA on pressing a button on any of Microsoft Dynamics GP Windows, and I thought I should share this tip:

First, on your VBA project, go to Tools>> References and add a reference to

“Crystal Reports ActiveX Designer Design and Runtime Library”

image

Place your report in an accessible location to be loaded, then place code below where you need to print the report:

Dim CRApp As New CRAXDDRT.Application
Dim CRReport As New CRAXDDRT.Report
Set CRReport = CRApp.OpenReport(“C:\rptAccounts.rpt”, 1)

Dim CP As CRAXDDRT.ConnectionProperties
For Each tbl In CRReport.Database.Tables
    Set CP = tbl.ConnectionProperties
    CP.Item(“User ID”) = “sa”
    CP.Item(“Password”) = “123”
    CP.Item(“Data Source”) = “.\SQL2005”
    CP.Item(“Initial Catalog”) = “TWO”
Next tbl
CRReport.PrintOut False

Change “C:\rptAccounts.rpt” to your actual report path and enjoy!

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Advertisements

How to change item quantity from a Type to another??

I got a question from one of my clients wondering how to change the item quantity type from On Hand/Returned/In Use/ In Service/ Damaged to any other type, the answer is simply by navigating to: Transactions >> Inventory >> Transfer Entry, fill the same Site ID in both From/To fields and select your item, then press on “Quantity Type” as shown below:

image

Select the quantity type that you are interested to use and proceed, post the transaction and validate your voucher.

image

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Analysis Cubes for Dynamics GP Configuration Wizard

Error:

Dynamics GP Professional is required to proceed.

Strange error upon trying to configure Analysis Cubes using wizard.

Cause:

SQL Server doesn’t have Analysis Services Installed.

Resolution:

Install SQL Server Analysis Services and the wizard will proceed.

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

How to Create a New Report Using Report Writer and open it inside Microsoft Dynamics GP?

In this post, I will explain how to create a NEW report using Report Writer and open this report inside Microsoft Dynamics GP using Custom Reports form.

First, we’ll be creating a simple report that displays a list of accounts exists in the system and print the report within GP, as a start, open Report Writer and click on NEW as shown below:image

Name the report “Accounts List” under Financial Series and select “Account Master” as the main table, then press on Layout:

image

On the layout window, drag the fields from the left panel and drop it in the body section, choose “Account Number”, “Account Description”, and “Account Alias”:

image

Save and get back to Microsoft Dynamics GP, and go to “Reports>>Customized”:

image

You will find your new report added under Custom Reports List, print it and enjoy!

image

image

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Using Microsoft Dynamics GP Rapid Implementation Tools to Export/Copy/Backup Setup Between Companies

Guys,

I got an interesting question from one of my friends about this subject and thought its good to share how to utilize such feature in Microsoft Dynamics GP.

First of all you will need to download and install the tool using the link below, you can also download the installation and user manual PDF’s:

http://www.microsoft.com/downloads/details.aspx?FamilyID=D9DFA747-63DA-4CAC-B92D-28BB24192C1D&displaylang=en

After installing the tools, you will have two shortcuts installed at your start menu:

1. Rapid Configuration Tool: what we will currently explain.

2. Rapid Migration Tool: Which used to migrate your data from Quickbooks to GP.

To start, you will need to start “Rapid Configuration Tool” From start menu as shown below:

image

The application will start in an easy wizard mode, just press on Next:

image

We will need to choose “Export Data From GP to Excel 2007”, Choose the export location and click on Next:

image

Fill your database login information and press on Next:

image

Select your company and Next:

image

Click on export and enjoy having your company setup on your desktop available to be imported to any other company using the same wizard!

image

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Fix Fixed Assets!!!

Mark posted tips about fixed assets, check it out:

http://msdynamicsgp.blogspot.com/2009/10/weekly-review-putting-fix-in-fixed.html

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Management Reporter for Microsoft Dynamics

One day this might be our new FRx reporter, you never know! The beta version of this application will be released parallel to GP “11” in Jan 2010, if you are interested those guys are looking for Microsoft Dynamics GP users be their “Beta Testers” checkout post below:

http://blogs.msdn.com/dynamicscpm/archive/2009/09/30/announcing-management-reporter-beta.aspx

Thank Mark for pointing us to this post.

Regards,

Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com