DynamicsGP.me - Support System Launched

DynamicsGP.me team today launched the incident tracking system for Microsoft Dynamics GP & Dynamics RMS with the aim to cater clients with critical issues.

The clients can track and follow up with the incidents logged in the system.

Please visit the Support System here.

Cheers.

Dynamics GP 2010 R2 Downloads

Microsoft Dynamics GP 2010 R2 can be downloaded through Partnersource and CustomerSource since Mid April.This is the one of the rarest moments when the Microsoft actually released their product BEFORE their announced launch date - 1st of May. :)

For New features : What's New document.

The Guides : Fix List and Install Guide

Product Download Links :

PartnerSource


Product Release Downloads for Microsoft Dynamics GP 2010
Word Template Generator for Microsoft Dynamics GP 2010 R2
Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Visual Studio Tools for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Web Services for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for eConnect for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Web Services for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Integration Manager for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Personal Data Keeper for Microsoft Dynamics GP 2010
Dexterity Development System Releases for Microsoft Dynamics GP 2010 (Available soon)

CustomerSource


Product Release Downloads for Microsoft Dynamics GP 2010
Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Visual Studio Tools for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Web Services for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for eConnect for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Web Services for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Integration Manager for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Personal Data Keeper for Microsoft Dynamics GP 2010
Dexterity Development System Releases for Microsoft Dynamics GP 2010

A Big Thank you goes out to Mariano for the compilation of links .

Cheers.

Feradh Zain

Nomination for Most Influential MS Dynamics People

Nomination for the 100 Most Influential MS Dynamics Person for year 2011 is on..

Cast your votes before 22nd April 2011 :

http://www.micropoll.com/a/mpview/1068215-410927

Mohammed Feradh Zain.

Dynamics GP 10/2010 : Login very slow after installing SP5

Hi there,

Many experienced a torturous delay when login to GP after installing SP5 of GP10 with Analytical Accounting module.The workaround by Microsoft for this issue till the hotfix is launched is given below.

********************************

A Microsoft SQL Server job can be created to remove the records from the SY07110 table for the Dynamics Online Services product as a workaround until the resolution is released. The Microsoft SQL Server job can be scheduled to run every morning and/or at other times during the day to remove the records

1. Open the SQL Server Management Studio.
2. Expand the SQL Server Agent.
3. Right-click Jobs and click New Job.
4. Enter a name for the job.
5. Under the Select a page area at the left, click Steps.
6. Click New.
7. Enter a Step Name such as "Remove SY07110".
8. Click to select DYNAMICS as the database.
9. Copy the following statement into the Command area.

delete DYNAMICS..SY07110 where PRODID = 6499

10. Click OK.
11. In the Select a page area, click Schedules.
12. Click New.
13. Enter a Name.
14. Click to select Daily under the Frequency area.
15. In the Daily Frequency area, enter a time early in the morning or if you would like to run this more times throughout the day click to select the Occurs Every option and set that option.
16. Click OK.
17. Click OK.
18. Right-click the job to verify it runs successfully....

Hope this is helpful.

Cheers.

Trial Balance Detail report is out of balance in GL

One of the most common problem you come across while using Multicurrency module is the Detailed Trial Balance report in GL being out of balance.Microsoft has already published an automated solution for this issue in the partnersource/customersource.

Here is the excerpt from the KB document to overcome this issue.

Step 1. First, open the Trial Balance Report Options window for the Detailed Trial Balance Report by selecting the report option and click the Modify button.

a. In the Include section, make sure the checkbox for Unit Accounts is not marked.

b. In the Include section, make sure the checkbox for Inactive Accounts is marked.

c. Print the report again.


Step 2. If the Detailed Trail Balance Report is still unbalanced, then you will need to identify the GL transaction that is causing the difference. To do this, use one of the methods below:

Method #1: Use SQL scripts

a. Use the appropriate step below to open SQL Server Management Studio:

• If you use SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

• If you use Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then clickSQL Server Management Studio.

• If you use Microsoft SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2008, and then clickSQL Server Management Studio.


b. Copy the below script in to a query window and execute against the company database to identify unbalanced journal entries.

select JRNENTRY, sum(DEBITAMT) - sum(CRDTAMNT) from GL20000, GL00100 where ACCTTYPE = 1 group by JRNENTRY having sum(DEBITAMT) - sum(CRDTAMNT) <> 0 

Method #2: Use the automated solution for "General Ledger Out of Balance" to find the unbalanced journal entries. This solution can be found using the link below to KB 935384.

KB 935384 - Automated Solutions that are available for the Financial series in Microsoft Dynamics GP
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;935384



Step 3. Once the unbalanced journal entry has been identified, you can correct the journal entry by setting up a dummy account in General Ledger to use as your offsetting account to key a journal entry. When finished, you can delete the side of the journal entry booked to the dummy account and then remove the dummy account to leave a one-sided entry to balance the Detailed Trial Balanced Report. To do this, follow the steps in KB 865712 on how to create a one-sided journal entry to balance out the difference.

KB 865712 - The beginning balance for the current year does not balance in the General Ledger in Microsoft Dynamics GP
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;865712

Displaying Hijri dates in Microsoft Dynamics GP

One of the key requirements through out GP users in the Middle East specially Saudi Arabia is to display date in Hijri format.

Just stumbled upon a great post by GP guru Mariano with regards to Hijri conversion customization.Awesome post and sample code.Check it out.

http://dynamicsgpblogster.blogspot.com/2009/02/displaying-hijri-dates-in-microsoft.html

Cheers..

Feradh

Discontinuation Dates for Business Portal technical Support

Mark your calendars for the upcoming service discontinuation for the Business Portal users.

Below are the details..

Cheers.

Feradh

Product Line - Microsoft Dynamics GP

Business Portal Release Version	Dynamics Release Version	Platform	Database	Release Date	Technical Support Discontinued
3.0	9.0	Windows 2003	Microsoft SQL	2/05	1/11/2011
2.5	8.0	Windows 2003	Microsoft SQL	8/04	10/13/2009
2.0	7.0, 7.5	Windows 2003	Microsoft SQL	1/04	1/09/2007
1.2	7.0, 7.5	Windows 2000	Microsoft SQL	8/03	10/01/2004
1.0	7.0, 7.5	Windows 2000	Microsoft SQL	4/03	10/01/2004

Product Line - Microsoft Dynamics SL

Business Portal Release Version	Solomon Release Version	Platform	Database	Release Date	Technical Support Discontinued
3.0	6.5	Windows 2003	Microsoft SQL	1/06	3/31/2011
2.5	6.0	Windows 2003	Microsoft SQL	8/04	10/13/2009
2.0	5.5	Windows 2003	Microsoft SQL	1/04	10/10/2006
1.2	5.0, 5.5	Windows 2000	Microsoft SQL	5/03	10/01/2004
1.0	5.0, 5.5	Windows 2000	Microsoft SQL	5/02	10/01/2004