Wednesday, November 11, 2009

Computer Check in Arabic Language in Microsoft Dynamics GP 10.0


As we had a customer who requested us to setup the check printing facility in ARABIC, here is how you can get it done very easily in Dynamics GP

Step 1: Install Multilingual Checks Module
-      Run Microsoft Dynamics GP 10 CD 1.
-      Select Install Microsoft Dynamics GP


 
-      Then Select “Add/Remove Feature”


-      Then Select “Multilingual Checks Option”

-      Press “ Install “ button.







 -      System will take some time to complete installation part like normal installations of additional modules.

 
Step 2: Setup Multilingual Checks Module

-      Login to Dynamics GP.
-      Go to Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Company
o    Click Options Button
o    Then click Additional Menu
o    Select ML Checks.


o    Select “Enable Multilingual Checks”
o    Select Format Type “”Default”, there are two formats
o    Default
o    Select this option to print checks in the default format defined in the
Microsoft Dynamics GP. Refer to the Microsoft Dynamics GP documentation
for more information on check formats.
o    Canadian
o    Select this option to print checks in the format specified by the
Canadian legal authorities. The Language, Check Date Separators, and Check
Date Format fields become available.

Canadian legal authorities. The Language, Check Date Separators, and Check
Date Format fields become available.

 Step 3: Setting up currency terminology
-      Open the Currency Terminology Setup window.
o    Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Currency >> Additional >> Currency Language
o    Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Currency Language
 


Step 4: Set up Check Book Language

-      Open the Default Language Setup window.
o    Cards >> Financial >> Checkbook >> Additional >> Checkbook Language Setup
o    Select “Multilingual” check box.
o    Select Language “Arabic”

 


-      Using Default Language Setup window you can assign a default language to a checkbook and this will be used as the default language to print payables computer checks batches and miscellaneous checks where as if require During transaction entry, you can change this language.


Step 5: Prepare & Print The Check.

-      Open transaction windows.
o    Payable
o    Transaction >> Purchasing >> Edit Check
o    Miscellaneous Check
o    Transactions >> Financial >> Miscellaneous Check











To Use Multilingual Checks options you need to make sure the followings pre-requisites

1- SQL Server Collation Should Be In Arabic ( SQL_ARABIC_100_CS_AI) SQL 2008.

2- Enable Arabic Language on the system where printing of checks will be done.

      To Enable you can ( Start >> Control Panel >> Regional and Language options




 












Sunday, November 8, 2009

Dot NET Framework 2.0 is not installed, Error message when you try to install Microsoft Dynamics GP 10.0




When you try to install Microsoft Dynamics GP 10.0, you receive one of the following error messages:

Error message 1

.NET Framework 2.0 is not installed. The installation cannot continue.
Error message 2
Product: Dexterity Shared Components -- .NET Framework 2.0 is not installed. The installation cannot continue.
Then, the installation is ended.
This problem occurs if the Microsoft .NET Framework 2.0 Service Pack 1 is installed on the computer. To get the full resolution check this KB article on Partner source
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;947538

Saturday, November 7, 2009

White Paper for Microsoft Dynamics GP and Microsoft SQL Server 2008


An interesting white paper on Microsoft Dynamics GP 10.0 and Microsoft® SQL Server 2008. 
This is what Microsoft Mentioned after benchmark performance
“Microsoft Dynamics GP 10.0 showed an impressive 18% increase in performance through upgrading from SQL Server 2005 Enterprise Edition to SQL Server 2008 Enterprise edition when using Row Compression on select tables.  Without Compression enabled, SQL Server 2008 still showed a 9% gain in performance when compared with SQL Server 2005.

An additional benefit demonstrated by the benchmark performance tests was how enabling Compression in SQL Server 2008 also reduced the disk drive space requirements of the Microsoft Dynamics GP company database, by as much as 52% in one benchmark test scenario.”

For complete details on the benchmark performance test, download the White Paper today!
https://mbs.microsoft.com/partnersource/documentation/whitepapers/mdgpsqlwhitepaper.htm?printpage=false

Friday, November 6, 2009

Help Achieving Compliance Objectives in Microsoft Dynamics GP 10




Recently working for one of our client who was in process of implementing SOX, I came across an interesting White Paper
Partner: https://mbs.microsoft.com/partnersource/documentation/whitepapers/helpachievecomplianceobjectivesgp.htm?printpage=false
Customer: https://mbs.microsoft.com/customersource/support/documentation/whitepapers/msdygp_whitepaper_achievecomplianceobjectives.htm?printpage=false

Thursday, November 5, 2009

Strategies for Multi-Entity Environments in Microsoft Dynamics GP 10


Strategies for Multi-Entity Environments in Microsoft Dynamics GP 10


Interesting White Paper



“Microsoft Dynamics™ GP serves the needs of many multi-entity customers today in a variety of business scenarios. While multi-entity deployments can carry a greater degree of complexity than single-entity deployments, the flexibility and strength of Microsoft Dynamics GP provide solid solutions for most scenarios. Because there are several options at your disposal, it is important to have a sound and disciplined process when determining the best deployment solution for any particular customer scenario


Partner:  https://mbs.microsoft.com/partnersource/documentation/whitepapers/strategiesmultientityenvironmentsgp10.htm?printpage=false
Customer: https://mbs.microsoft.com/customersource/documentation/whitepapers/strategiesmultientityenvironmentsgp10.htm?printpage=false

Creating a Dynamics GP DSN Manually on 64-bit Windows


Creating a Dynamics GP DSN Manually on 64-bit Windows


We have used 32-bit Windows, but Windows 2008 R2 is available in 64-bit.  Dynamics GP requires an ODBC Data Source Name (DSN) to be setup on the Windows machine where it is installed. It uses this to connect to SQL Server, and is usually very simple to setup.

But, if you install GP on a 64-bit version of Windows and manually setup a DSN, when you try and launch GP or GP Utilities for the first time, the "Server" drop down list will be blank.  If you setup the DSN by navigating to Administrative Tools --> Data Sources, you actually went into the 64-bit ODBC Administrator tool. GP is only able to 'see' 32-bit System DSNs, and will not see the 64-bit System DSNs.

In order to setup the DSN for GP, you will need to launch the 32-bit ODBC Administrator tool. The two windows appear to be indistinguishable, with no visible differences between them.   Here is a Microsoft Support KB article discussing the two versions.

You have to launch 32-bit ODBC by navigating to: %systemdrive%\Windows\SysWoW64\odbcad32.exe. Once you launch the 32-bit Administrator tool and setup your DSN, it should show up in GP and GP Utilities.



Dynamics AX – Vendor Scoring In RFQ Analysis Process

Vendor scoring is one of the important aspect of the RFQ process in any organization. While we were working with our client requirement fo...