How to display EURO Currency symbol in Dynamics GP?

 

Looks an easy question right? Go to Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Currency >> Currency expansion button and select the € symbol!

Well not that’s easy, if you had languages other that the English or your collation for SQL is not Latin you will get the below:

image

This symbol actually represents the Euro currency symbol, select this symbol and go try to print a report, you will find the symbol there:

image

Enjoy!


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Advertisements

Dynamics GP 2010 Web Services Installation – The Security ID structure is invalid. (Exception from HRESULT:0x80070539)

 

I been trying to install the web services for one of my clients, they are running a complicated environment, clustered SQL Server environment over three servers and clustered Hyper-V server to manage virtualized web applications like Workflow and Business Portal.

We have installed the SharePoint Server Farm and configured the Load Balancer to manage the load balancing between servers and created web applications for both Workflow and Business Portal and then moved to the web services installation which was already installed on the production environment, unfortunately the installation never succeeded with the above error message.

I tried everything, reinstalled it more that 100 times with no luck, searched every where with no result where I realized that the web services cannot be installed on a multiple server environment which does not make sense.

Finally I have decided to select the same Web Services database of the production environment and it worked! Looks like the Web Services cannot be installed with more that security database which is logically right due to the complication of the security roles and tasks on the web services entities.

Next time do not waste your time and directly select one name for web services database!


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

MVP for another year!

 

I like that feeling when receiving the same mail from Microsoft! Informing me about the MVP award renewal.

Glad that I made it, thank you all for your support.


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Microsoft Dynamics Most Influential People Top 100 – 2012

 

DYNAMICS WORLD launched the 2012 process for nominations! Votes were started, and below is my poll:

http://www.dynamicsworld.co.uk/top-100-voting-page-6/

Awaiting for your votes!!


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Dynamics GP Workflow Issues, Server Error in “/” Application

 

Yesterday I been through a wired issue with Dynamics GP Workflow, after activating Vendors Addition and Purchase Order workflows users were getting the below message when trying to open any workflow:

Server Error in ‘/’ Application.


Runtime Error

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed.
Details: To enable the details of this specific error message to be viewable on the local server machine, please create a <customErrors> tag within a “web.config” configuration file located in the root directory of the current web application. This <customErrors> tag should then have its “mode” attribute set to “RemoteOnly”. To enable the details to be viewable on remote machines, please set “mode” to “Off”.

<!– Web.Config Configuration File –>

<configuration>

<system.web>

<customErrors mode=”RemoteOnly”/>

</system.web>

</configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the “defaultRedirect” attribute of the application’s <customErrors> configuration tag to point to a custom error page URL.

<!– Web.Config Configuration File –>

<configuration>

<system.web>

<customErrors mode=”On” defaultRedirect=”mycustompage.htm”/>

</system.web>

</configuration>

I doubled check the web.config and been sure that the web.config in the inetpub folder has the <customErrors mode =”off”>, after doing many researches I found another web.config located in the below path:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS

Which has the <customErrors mode =”on”>, switching off this returned the actual error behind the workflow as shown below:

Server Error in ‘/’ Application.


The application encountered an unhandled system exception. Contact your system administrator for details.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException: The application encountered an unhandled system exception. Contact your system administrator for details.
Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a “Debug=true” directive at the top of the file that generated the error. Example:
<%@ Page Language=”C#” Debug=”true” %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug=”true”/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:

[SoapException: The application encountered an unhandled system exception. Contact your system administrator for details.]

System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +413241

System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +300

Microsoft.Dynamics.GP.Proxy.DynamicsGP.GetCurrencyList(CurrencyCriteria criteria, Context context) +98

Microsoft.Dynamics.GP.Formatter.GetCurrencyList(DynamicsGP service, Boolean useHttpUser) +505

Microsoft.Dynamics.GP.Formatter.CacheCurrencyFormatData(String webServiceURL, Boolean useHttpUser) +85

Microsoft.Dynamics.GP.Workflow.DocumentViewer..ctor() +159

ASP._layouts_dynamics_workflow_gp_vendorviewer_aspx..ctor() +18

__ASP.FastObjectFactory_app_web_dynamics_workflow_gp_vendorviewer_aspx_2a428413__lml_jl2.Create_ASP__layouts_dynamics_workflow_gp_vendorviewer_aspx() +31

System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +138

System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +50

System.Web.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +425

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +263


Version Information: Microsoft .NET Framework Version:2.0.50727.5448; ASP.NET Version:2.0.50727.5456

That was a new challenge, trying to figure our the resolution behind the new error, doing more researches returned that such an issue are web-services related issues as the workflow was unable to read information from Dynamics GP, you will need the administrator user you are using to run the services to the BDC Administrator role in web-services administration console.

The issue will be resolved!!!


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Error Converting Request to Purchase Order–Business Portal 5.1

 

I have installed Business Portal 5.1 for one of my customers and been through the below error in converting Purchase Request into Purchase Order

The specified Protocol is invalid

Doing researches about this subject returned that the web.config of the business portal might be missing from this path “C:\Program Files\Microsoft Dynamics\Business Portal” and it was!

To resolve this I have connected to another client whose running the business portal with no issues and copied the web.config! It worked perfectly, below is the web.config content:

<?xml version="1.0" encoding="utf-8" ?>
<
configuration>

<
system.web>

<
xhtmlConformance mode="Legacy" />

</
system.web>


<
appSettings>

<
add key="Protocol" value="1"/>
<
add key="TaxEngineServiceAssembly0" value="Microsoft.Business.Taxes.Services"/>
<
add key="TaxEngineServiceClass0" value="Microsoft.Business.Taxes.TaxEngine"/>

<
add key="TaxEngineDataServiceAssembly0" value="Microsoft.Dynamics"/>
<
add key="TaxEngineDataServiceClass0" value="Microsoft.Dynamics.Common.TaxEngineData"/>

<
add key="TaxEnginePreCalculateDocumentEventAssembly0" value="Microsoft.Dynamics"/>
<
add key="TaxEnginePreCalculateDocumentEventClass0" value="Microsoft.Dynamics.Common.TaxEngineISV"/>
<
add key="TaxEnginePreCalculateDocumentEventMethod0" value="DocumentPre"/>

<
add key="TaxEnginePreGetTaxGroupIDsEventAssembly0" value="Microsoft.Dynamics"/>
<
add key="TaxEnginePreGetTaxGroupIDsEventClass0" value="Microsoft.Dynamics.Common.TaxEngineISV"/>
<
add key="TaxEnginePreGetTaxGroupIDsEventMethod0" value="PreGetTaxGroupIDs"/>

<
add key="TaxEnginePreCalculateCodeEventAssembly0" value="Microsoft.Dynamics"/>
<
add key="TaxEnginePreCalculateCodeEventClass0" value="Microsoft.Dynamics.Common.TaxEngineISV"/>
<
add key="TaxEnginePreCalculateCodeEventMethod0" value="PreCalculateCode"/>

</
appSettings>

</
configuration>

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Mass Item/Vendor Link

 

I got a request from one of my customers to have the ability to link multiple items with a vendor without the need to add them one by one and I have created this using the .Net toolkit, the screen will look like the below:

image

The user can filter items from the list on the left panel, click on insert and process! The system will link the selected items with the selected vendor!

I am willing to publish this tool soon, will update the article with the download link once doing some fine tuning on the utility.


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com