Single Quotes ( ‘ ) !?! And other Illegal Characters

Guys,

We used to have this problem when developing our applications that’s using SQL Database, as the single quotation used to cause un-handled exception upon inserting the record to the database as it cause miss in string formatting.

However, we used to handle such issues with replacing the single quotation ( ‘ ) with the other single quotation ( ` ) with ASCII code of 44, now with GP the issue is here as well! checkout below Mariano and Davids Posts on this subject and their available workarounds:

David:

http://blogs.msdn.com/developingfordynamicsgp/archive/2009/06/22/microsoft-dynamics-gp-and-illegal-characters-part-1.aspx

Mariano:

http://dynamicsgpblogster.blogspot.com/2009/06/fixing-microsoft-dynamics-gp-and.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/

How to Call GP Lookup using VBA??

Guys,

Allot of question comes to our minds when customizing GP on how to open GP lookup form while we are using VBA, here in this post, I will explain a simple workaround in details.

To get this done easily, we need to take the customer card as example, I will add a new lookup button and a new text field, the lookup button will call the lookup form and the value (Customer ID) will be placed in the text.

A. Customer Card Work:

1. Modify customer card form and add two objects, a lookup button and a string text box.

clip_image002

2. Add the “Modified” customer card form to VBA, and then add our lookup button with the text to VBA.

3. Now we need to add a Global Boolean variable to determine wither the lookup is called from this customized button or not.

4. On the button “Changed” event we need to call the customer lookup form, and this will require using Dynamics Continuum API, so you need first to add your reference to the API by following steps below:

  a. On your VBA window go to Tools >> References

  b. Check on “Dynamics Continuum Integration Library”

 

Then write the following code in the customer maintenance form:

Public bolFireLookup As Boolean
Private Sub btnCustomerLookup_Changed()
bolFireLookup = True
Dim GPApp As New Dynamics.Application
Dim ErrMsg As String
GPApp.CurrentProductID = 1493
GPApp.ExecuteSanscript “open form ‘Customer_Lookup’;”, ErrMsg
GPApp.ExecuteSanscript “run script ‘PB_Refresh_Scrolling_Window’ of window ‘Customer_Lookup’ of form ‘Customer_Lookup’;”, ErrMsg
End Sub

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

B. Customer Lookup Work:

1. Add the customer lookup form to VBA, and then add the Customer ID field and the select button.

2. As the Smart-list is a separate module that GP and has its own dictionary, you will need to reference the Dynamics_GP project by following steps below:

  a. Go to Tools >> References

  b. Check “Microsoft_Dynamics_GP”

3. Paste the following code:

Private Sub Select_Changed()
‘Validate that the Customer Card is open
If Microsoft_Dynamics_GP.CustomerMaintenance.IsLoaded Then
‘Validate that the lookup is called from customized lookup button 
If Microsoft_Dynamics_GP.CustomerMaintenance.bolFireLookup Then 
Microsoft_Dynamics_GP.CustomerMaintenance.txtCustomerID.Value = CustomersandProspectsDetail.CustomerNumber.Value Microsoft_Dynamics_GP.CustomerMaintenance.bolFireLookup = False 
End If
End If
End Sub

The complete sample package could be downloaded using the following link:

http://blog.greatpbs.com/LookupExample.zip

Hope that this helps.

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

MSN Messenger on your blog

Guys,

For those who blog, and would like to give their blogs a mouth! you might need to check out this feature from MSN, which allows you to directly chat with your Blog visitors:

http://settings.messenger.live.com/Conversation/IMMe.aspx?invitee=2a6f0835c3116ac6@apps.messenger.live.com&mkt=en-US&useTheme=true&themeName=green&foreColor=333333&backColor=DCF2E5&linkColor=333333&borderColor=8ED4AB&buttonForeColor=2C0034&buttonBackColor=CFE9D9&buttonBorderColor=8ED4AB&buttonDisabledColor=CFE9D9&headerForeColor=006629&headerBackColor=92D6AE&menuForeColor=006629&menuBackColor=FFFFFF&chatForeColor=333333&chatBackColor=F4FBF7&chatDisabledColor=F6F6F6&chatErrorColor=760502&chatLabelColor=6E6C6C
Free Counter

Below where you can customize color, size, font and visibility for this functionality:

http://settings.messenger.live.com/Applications/CreateHtml.aspx

Before starting, you might need to allow anonymous MSN messages by going to “Home” tab and check “Allow anyone on the web to see my presence and send me messages. “

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/

What is the difference between Dynamics GP, AX, SL and NAV?

Guys,

I found an interesting discussion in LinkedIn where experts were discussing differences between Microsoft Dynamics ERP’s, check the complete discussion @ the link below:

http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&gid=41656&discussionID=4323674&split_page=1

Updated:

Houston Neal posted a great topic about differences between the 4 Microsoft Dynamics ERP’s, check his blog post below:

http://www.softwareadvice.com/articles/manufacturing/understanding-the-difference-between-gp-nav-sl-ax-1111709/

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/

Dynamics GP Scalability, Figures and Numbers!

Dears,

Did you know that GP tested with 1,000 concurrent users and the following results was achieved? For those who never read the scalability white paper, check this out:

image

Download Microsoft Dynamics GP Scalability White Paper for the complete testing results.

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/
http://mohdaoud.blogspot.com/

Run Crystal Report in Dynamics GP Using VBA

Dear All,

I was a long time since my last post, that was due to my engagement in managing 3 concurrent projects in two different countries, now I am back with this interesting article.

Allot of GP developers used to ask how to run Crystal Report from GP, all the answers were to use Report Designer Component (RDC) for dexterity along with ReportView.exe and proceed, this is not an easy task to be done if you are not dexterity expert.

In this article I have created a .Net based application that view any crystal report using parameters passed through files.

Now to implement this solution you will need to follow steps below:

1. Download and unzip “Crystal Reports Viewer.zip” from the link below:

http://blog.greatpbs.com/Crystal%20Reports%20Viewer.zip

2. Run “GP Crystal Reports Viewer Setup\setup.exe” to start the installation.

Note: Crystal Report Runtime files and .Net framework should be installed on the client machine, if it’s not then you might need to read files under “CrystalReports” and “dotnetfx” folders.

3. Import “CustomerCard.Package” from Dynamics GP Menu >> Tools >> Customize >> Customization Maintenance.

4. Modify the VBA code to fit your needs.

Please don’t hesitate to post your comments.

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/
http://mohdaoud.blogspot.com/