Sunday, December 7, 2014

Dynamics GP Web Client: Kill all web client sessions

A customer has reported an issue with web client that many sessions are open while no body is working, they wanted to kill all these sessions without restarting the server, few researches over the internet returned the following CMD commands that did the trick, just Right Click the cmd.exe and run as administrator, then paste the following commands:

Taskkill /F /IM Microsoft.Dynamics.GP.Web.Services.Runtime.Process.exe
Taskkill /F /IM conhost.exe

Viola! You saved an hour of manually killing these in your task manager or session manager.

Note: To make sure that the windows cleans all sessions at night, I saved these commands into Batch.bat file and scheduled this with windows scheduler to run every night 4 AM, so users can find a clear log next morning.


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Dynamics GP: You cannot print unauthorized Purchase Order and the Purchase order is not available in the commitment

One of my customers reported an issue with their purchase orders after upgrading to Dynamics GP 2013 R2, below the message they got:

image

The customer is using PO Commitment to validates budgets and somehow the purchase order was not available in “CPO10110” table,  the script below will fix this for you by taking the record information from POP10110:

INSERT INTO [CPO10110]
           ([PONUMBER]
           ,[ORD]
           ,[ACTINDX]
           ,[REQDATE]
           ,[VENDORID]
           ,[APPROVL]
           ,[Committed_Amount]
           ,[POLNESTA]
           ,[QTYCANCE]
           ,[UNITCOST]
           ,[PostedSubtotal])

SELECT [PONUMBER]
           ,[ORD]
           ,[INVINDX]
           ,[REQDATE]
           ,[VENDORID]
           ,1 AS [APPROVL]
           ,0 AS [Committed_Amount]
           ,[POLNESTA]
           ,[QTYCANCE]
           ,[UNITCOST]
           ,[EXTDCOST] AS [PostedSubtotal]
FROM POP10110 WHERE PONUMBER = @PONUMBER


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Wednesday, December 3, 2014

Dynamics GP 2015 with 120+ enhancements!

As promised, Microsoft has released Dynamics GP 2015 on time! 120+ enhancements were introduced, see below the first look into the product:

Before you plan your upgrade, keep in mind that SQL 2008 is no longer supported, you must upgrade at least to SQL 2012 or later.

1. Icons has been Changed!

image

2. Login Page has been changed!

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Monday, November 24, 2014

Requisitions Management Purchase – Item Cost Selection

One of my customers reported that when they transfer the Purchase Requisition to Purchase Order, the cost they specified in the requisition for their items is not being transferred to the purchase order.

Checking the Requisition setup I didn’t find an option to keep the cost of requisition on Purchase Order, only the below options are available:

image

For this particular customer, they are not using the “last vendor originating cost”, so I have created a Trigger that updates the field for each update occurs on requisition screen, below the trigger code if anybody is interested.

CREATE TRIGGER [dbo].[DI_UPDATEITEMCOST]
ON [dbo].[POP10210]
AFTER INSERT, UPDATE
AS

DECLARE @ITEMNMBR VARCHAR(500)
DECLARE @UNITCOST numeric(18,5)
DECLARE CUR CURSOR FOR SELECT ITEMNMBR, UNITCOST FROM INSERTED

OPEN CUR
FETCH NEXT FROM CUR INTO @ITEMNMBR, @UNITCOST

WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE IV00103 SET Last_Originating_Cost = @UNITCOST WHERE ITEMNMBR = @ITEMNMBR AND @UNITCOST <> 0

FETCH NEXT FROM CUR INTO @ITEMNMBR, @UNITCOST
END
CLOSE CUR
DEALLOCATE CUR
GO






Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Saturday, November 15, 2014

Dynamics GP Purchase Order Workflow: Approver requires A Full User not Limited

 

If you are looking to implement the Purchase Order Workflow, you must keep in mind that limited users will not be able to approve Purchase Orders, user should be FULL user to be able to process orders, I am not sure why Microsoft folks designed it this way but I got one of my customers to purchase additional 5 users to get this implemented!

I have requested this enhancement from Microsoft and kindly asking for your votes to get this fixed, below is the article on MS Connect:

https://connect.microsoft.com/dynamicssuggestions/feedbackdetail/view/1030936/purchase-order-approval-to-work-with-limited-users

Happy ordering!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Friday, November 14, 2014

Dynamics GP Purchasing - Request for Quotations module

Thinking about this subject, can’t find a company who does not follow the standards in their procurement process, everyone brings 3 quotations from 3 different suppliers and selects the best fit from requirements and pricing!

I found this process on Connect requested since 2010 with very limited votes! I would kindly ask for your help in voting and getting this scheduled soon, below the description of the product suggestion:

I think Dynamics GP is one of the few applications in the ERP world that does not have the request for quotation functionality, the process is like this: - RFQ (enter details for items willing to purchase) - Select one or more vendors and the system should print separate RFQ for each (and prepare the system to receive responses from each) - Receive quotes from Vendors and update on system - Compare vendor’s prices against same lines in RFQ - transfer one of the quotes to Purchase order Note: The is the simplest cycle possible and there are many other advanced consideration that can be added later on like: - Issuing PO against more than one vendor quote for same RFQ - Ability to update quotation with new discounts and data maintaining original information and changes (quote version control). - Ability to make the budget commitment from RFQ point rather than PO point (and this will be major advance for the application as most of the people in business or government would like to reserve budget before knowing the vendor and not after like it is currently acquiring in GP) - Specify a minimum number of quotations if the RFQ estimated price is more than a specific value. - Include in GP workflow if possible - Link to specific one or more requisitions created in Business Portal.

Below the link for the connect article:

https://connect.microsoft.com/dynamicssuggestions/Feedback/Details/537585

Happy voting!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Web Client – Date Fields “Please check and reenter the date”

If you are using the web client, you might be going through the message in the subject, this is annoying for users with too many daily transactions!

image

As reported by one of my customers! This issue occurs only when you have the date format with string month (dd-MMM-yy) like the below:

image

Just make sure that the month is numeric (dd-MM-yyyy) and you will get rid of this message!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Tuesday, November 11, 2014

No Print for Purchase Requisitions!!

When you see the window print button you expect that the information of the window you are on is being printed on a report writer report, and when one of your customers inform you that no action is being taken upon pressing the report you just feel like the user is not aware whats going on and a privileges  issue should take place!

Well for Purchase Requisition Entry form this is not the case! the window print is not linked to any of the available reports, clicking the button will do nothing and you will feel a little bit confused about what to be done!

image

The button indeed does not have a report assigned, but you can design your report on SSRS and link it to this button! Just click the Small Arrow near the print button and hit “Assign Reports”, then select the report you need to link, see the below for clarification:

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Monday, November 10, 2014

Workflow 2.0 “OR” Operator not working

While working on the Dynamics GP 2013 R2 workflow, I realized that the “OR” operator is not working properly, take a look into the below example:

Step 1: Approval By User X --> Only when the Requester is "User 1" OR "User 2"
Step 2: Approval By User Y --> Only when the Requester is "User 3" OR "User 4"

When you submit the requisition it goes for both User X & User Y, this is for both the Requisition and the Purchase Order as well!

I reported this to the connect website, hope they will fix this in the upcoming 2015 release.

https://connect.microsoft.com/dynamicssuggestions/feedbackdetail/view/1026359/or-is-not-working-properly-in-dynamics-gp-2013-r2-workflows-po-requisition


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Saturday, November 8, 2014

Management Reporter CU10 is available

For customers with complicated reports and huge sizes, you need to consider the upgrade to this release of Management Reporter, noticeable improvements has been made to fasten up the report generation process, along with many more features found below:

http://blogs.msdn.com/b/dynamics_financial_reporting/archive/2014/09/30/management-reporter-2012-cu-10-now-available.aspx


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Thursday, November 6, 2014

Excel to GP – GL Transactions with Analytical Accounting

I know Mahmoud M. AlSaadi very well! He is a colleague and friend, I know very well his experience in Excel and SQL, I been watching Mahmoud last few months hardly collecting his experiences to make something and expected the thing to be big, he finally worked out his master piece and it was really amazing finding such a process in Dynamics GP.

He has created some refreshable sheets on a workbook that reads data directly from your GP database, and used this to validate a default sheet that represents your new GP GL Transaction Entry! Instead of manually creating transactions with complicated Analytical Accounting information, you just fill the Excel and his tool will automatically generate the macro needed to fill transactions inside GP.

Needless to say, it is a free tool that is shared on his blog post below:

http://mahmoudsaadi.blogspot.com/2014/11/analytical-accounting-entry-excel-to.html

I would advise you watch the below video and go to the download page to get your copy:

I would say good job Mahmoud! Looking to see you with us at the MVPs board soon.


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Sunday, August 24, 2014

Management Reporter 2012 Process Service Not being Started - The time zone ID 'Jerusalem Standard Time' was not found on the local computer.

Few days back I got a very wired case from one of my customers, the reports they are generating are not being processed and locked in the “Queued” state, which normally caused due to the fact that Management Reporter Services are not running, moving to the services I have noticed that the “Management Reporter 2012 Process Service” is not running and unable to be started.

I moved to the Event Viewer trying to find the cause of the issue and found the following wired error:

Service cannot be started. System.TimeZoneNotFoundException: The time zone ID 'Jerusalem Standard Time' was not found on the local computer.
   at System.TimeZoneInfo.GetTimeZone(String id)
   at System.TimeZoneInfo.FindSystemTimeZoneById(String id)   at Microsoft.Dynamics.Common.Scheduler.GenericScheduler.ExtensionMethods.ToScheduler(Trigger taskTrigger)
   at Microsoft.Dynamics.Common.Scheduler.GenericScheduler.Scheduler.SchedulerTask.CreateFromDataTask(Task task, Guid schedulerId)
   at Microsoft.Dynamics.Common.Scheduler.GenericScheduler.Scheduler.LoadTasks()
   at Microsoft.Dynamics.Common.Scheduler.GenericScheduler.Scheduler.OnHeartbeat()
   at Microsoft.Dynamics.Common.Scheduler.GenericScheduler.Scheduler.StartScheduler()
   at Microsoft.Dynamics.Performance.Reporting.Scheduler.SchedulerService.OnStart()
   at Microsoft.Dynamics.Performance.Common.ServiceComponent.StateChangeHandler(RequestedStateChange requestedState)
   at Microsoft.Dynamics.Performance.Common.ServiceComponent.<Load>b__0(RequestedStateChange s)
...

image

Tried to search everywhere looking what could cause this with no luck, that was indeed a very wired error that does not have any explanation.

I tried to search the web on the location where the windows saves the times zones to see what’s going on and noticed that it is stored in the windows registry under the following path:

HKLM\Software\Microsoft\Windows NT\CurrentVersion\Time Zones\

Tried to find “Jerusalem Standard Time” in the list with no luck, but noticed that there is a new time zone called “Israel  Standard Time” that in-fact replaced the “Jerusalem Standard Time”.

image

I renamed the folder back to “Jerusalem Standard Time” and the service started properly, it looks like folks at Microsoft has changed this for political reasons and forgot to apply the change correctly!

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Wednesday, August 13, 2014

ARABIC & ENGLISH Amount in Words for Excel

5 years back I have published a script that allows you to view amount in words in Arabic, what we call it “TAFQEET”, the article is published under the following link:

http://mohdaoud.blogspot.com/2008/10/convert-numbers-to-arabic-words-tafqeet_5647.html

I been getting many requests across the years on how to make this works for Excel and my answer was always that you cannot make it as it is an SQL based function and not a VBA.

This morning I have see a comment sharing me a video that shows how to make a simple VBA script to achieve the ENGLISH amount in words and the video is below:

https://www.youtube.com/watch?v=fYAxYtzBi5A

Moving forward I decided to make the same for ARABIC language considering that I have a script that works on .NET does the same and all what I need to do is to make this works for Visual Basic for Applications and the result is below:

1. Download the function from the following path:

http://www.di.jo/files/DI.bas

If that file was viewed and not downloaded, please right click and click “Save Target AS”.

2. Open Excel

image

3. Hit “ALT+F11” to get into the VBA editor

4. Right click the Microsoft Excel Objects Folder and click Import File

image

5. Select the file you just downloaded “DI.bas” and close the VBA editor.

image

6. Get back to your excel and start typing “=DITAFQEET“ you will see that the function was added to your library and ready to be tested!

image

7. Viola! Enjoy the below result

image

NOTE: upon saving the EXCEL you might be getting the following message:

image

Change the “Save As Type” to “Excel Macro-Enabled Workbook”

image

You can download a ready file from the below link:

http://www.di.jo/files/DI%20Tafqeet.zip

Enjoy!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Saturday, June 28, 2014

Dynamics GP Community is under attack!

It seems our community is under spam attack! It is getting spammed by few LOVE Specialists! I would kindly ask for users who has outstanding questions to “repost” their questions once Microsoft folks resolves this attack!

I feel like CAPTCHA will be added soon to the community to avoid such spammers and also to annoy users!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Analytical Accounting vs. Multidimensional Analysis

In earlier Dynamics GP versions, we used to use a module called MDA to manage our accounts dimensions and reduce the size of the chart of accounts, the module is very stable and works perfectly but with limited functionalities, when the Analytical Accounting was introduced, this module was retired and was no longer enhanced by Microsoft.

Personally, I been fighting with Analytical Accounting issues for many years now, I can count free hours spent to correct journals at the database level that unjustifiably corrupted and was not linked to the correct figures, which makes it a little bit annoying.

A couple of days back I seen a “conspiracy” being prepared between GP MVPs (including me!) against the Analytical Accounting pushing hard to get the MDA module back to track and enhanced to compete the AA module.

Frank has created the Connect request and we all voted to get this done, we need your help getting this ranked to the top of the list and to be considered in the very near release:

https://connect.microsoft.com/dynamicssuggestions/feedback/details/907907/bring-mda-back-to-dynamics-gp


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Thursday, June 5, 2014

Dynamics GP 2013 - Web Client Only Users & Active Directory Integration (LDAP)

This morning I been thinking about the new security structure for Dynamics GP web-client user who does not have SQL Users, and how these users will interact with SQL Server, I had to go through this as I have a client who’s running a very strict policy in granting SQL permissions for domain users.

Getting through this, I have created few users with multiple scenarios as below:

  1. The first user linked to domain account called that “TEST1”, but didn’t check “Web Client user only (no SQL Server Account)”
  2. The second user linked to domain account called that “TEST2”, and checked the “Web Client user only (no SQL Server Account)” option.

I have noticed that the first case created an “SQL User Account” called “TEST1” and didn’t granted the domain user any access to the database, and the second didn’t create any users which been a mystery to me understanding which user will be used to access the SQL Server!

To test this I have modified the GL00100 table and added a new column called “UserName” –this is for testing only, you cannot do this on GP tables!- and set the default value for this column to be “SUSER_SNAME()” function which returns the user who’s currently logged in and started my testing by creating new accounts!

Logged in by TEST1 to the web client and created a new account, the result was somehow wired, the user who was recorded was “DYNSA”

image

Logged in by TEST2 to the web client and created a new account, the result was the same, the user who was recorded was “DYNSA” as well.

Then logged in but selected “SQL Authentication” option from the login page:

image

The result was as expected, the logged in user was “TEST1”!

Now it been clear, all windows authentication users will be using one account to access the SQL, the login is the one you specified during the installation of the web client, so if you been counting on the user who is currently logged in in your customizations you might need to review your code!

Hope that helps giving you a good understanding to the new security process.


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Dynamics GP 2013 R2 upgrade: The following SQL statement produced an error: exec wfDeployClrAssemblies

During the upgrade process to Dynamics GP 2013 R2 with one of my customers we got the error in the subject, the issue is with dropping one of the SQL level Assemblies called “System.DirectoryServices” that been used by “Microsoft.Dynamics.GP.WorkflowGP.WorkflowEngine”.

The "System.DirectoryServices" assembly is being used by the Workflow module in Dynamics GP, if you have workflow installed you will not be able to drop this reference as you will be having another assembly depending on this and the other assembly is being used by 7 functions and stored procedures.

This assembly basically is used to connect your active directory and get the needed details that are being used by the system, dropping all these objects is safe as the upgrade process will automatically create them back for you.

To resolve the issue, first find the following functions and stored procedures, right click them one by one and hit drop:

image

Go to DYNAMICS database and navigate “Programmability>> Assemblies” and find “Microsoft.Dynamics.GP.WorkflowGP.WorkflowEngine”, right click the assembly and hit drop and then drop “System.DirectoryServices”:

image

Reinitiate Dynamics GP Utilities and and the upgrade will proceed safely, don’t worry about the deleted objects as the upgrade will recreate them all.

Hope that this helps.


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Update Currency Index field across all database

You might need to change the currency index for one of your currencies, I needed this during a consolidation project for multiple DYNAMICS databases and needed to change the currency index field for all company tables, take a look into the below script, I have used the “Information_Schema” to get all columns that are called “CURRNIDX” and updated these using SQL Cursor, considering that I taking a backup for each table before doing the operation:

DECLARE @Statement VARCHAR(8000)
DECLARE @TABLENAME VARCHAR(500)
DECLARE CURR Cursor FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'CURRNIDX' AND COLUMN_DEFAULT IS NOT NULL
OPEN CURR
FETCH NEXT FROM CURR INTO @TABLENAME
WHILE @@FETCH_STATUS = 0
BEGIN
SET @Statement = 'SELECT * INTO ' + @TABLENAME + '_BAK FROM ' + @TABLENAME
EXEC (@Statement)

SET @Statement = 'UPDATE ' + @TABLENAME + ' SET CURRNIDX = [NEW CURRENCY ID] WHERE CURRNIDX = [OLD CURRENCY ID]'
EXEC (@Statement)

FETCH NEXT FROM CURR INTO @TABLENAME
END
CLOSE CURR
DEALLOCATE CURR




Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Dynamics GP 2013 R2 – New User Maintenance

I liked the new active directory utilization for GP 2013 R2! take a look how does it look like now:

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Currency Symbol is incorrect for some GP forms

After updating the currency index field across all database, one of the users has reported that currency symbol does not match the functional currency symbol defined in the currency setup, and for some screens multiple currencies are shown as below:

image

After looking for this I have found this in MC40000 table, the Currency ID field represents the correct functional currency but the index was referring to another currency, updating the currency index field fixed the issue.


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Update Company ID field across all company database

A couple of weeks back I needed to consolidate two DYNAMICS databases and move companies from the first DYNAMICS to the second, this for sure requires Company IDs to be changed as it might be taken by another companies on the main DYNAMICS, to fix this once for all I have wrote the following script:

DECLARE @Statement VARCHAR(8000)
DECLARE @TABLENAME VARCHAR(500)
DECLARE CURR Cursor FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'CMPANYID' AND COLUMN_DEFAULT IS NOT NULL
OPEN CURR
FETCH NEXT FROM CURR INTO @TABLENAME
WHILE @@FETCH_STATUS = 0
BEGIN
SET @Statement = 'SELECT * INTO ' + @TABLENAME + '_BAK FROM ' + @TABLENAME
EXEC (@Statement)
SET @Statement = 'UPDATE ' + @TABLENAME + ' SET CMPANYID = [NEW COMPANY ID] WHERE CMPANYID = [OLD COMPANY ID]'
EXEC (@Statement)
FETCH NEXT FROM CURR INTO @TABLENAME
END
CLOSE CURR
DEALLOCATE CURR

 


Hope that this helps.





Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Consolidating multiple Dynamics GP Companies into single DYNAMICS database

Recently I had an interesting project with one of my customers, they had the following environment:

Server I:

  • Dynamics GP 9 RTM with 14 active companies.
  • SQL Server 2005 (Collation is Arabic_CI_AS).
  • Windows Server 2003 & FRx

Server II:

  • Dynamics GP 11 RTM with 3 active companies.
  • SQL Server 2008 R2 (Collation is Latin)
  • Windows Server 2008 & FRx

The customer simply wanted to upgrade to Dynamics GP 2013 SP2 and to SQL 2012, and also wanted to consolidate the databases into one single DYNAMIMCS database.

Challenges:

Now we have few challenges detailed below:

  1. Dynamics GP 2013 does not support upgrading from GP 9.0
  2. Dynamics GP 2013 does not support SQL 2005 and GP 9.0 does not support SQL 2012.
  3. Database collation differences between companies.
  4. Data stored in DYNAMICS database like currencies, users and BP objects.
  5. Changes that will occur on columns like “Company ID” and “Currency Index” which will be changed due to DYNAMICS data consolidation.
  6. Security migration from GP 9.0 to GP 2013.
  7. FRx migration to Management Reporter.
  8. Minimum downtime need to be maintained! 17 companies across multiple countries cannot stay down forever!

Resolutions:

Well we believe that nothing is impossible in the IT field, we have planned for everything and scheduled the upgrade process, below the steps we followed:

Server I:

  • Took a backup for all databases.
  • Upgraded from version (GP 9.00.0114) to 9.00.0371 that supports the upgrade to GP 2010 (we need GP2010 because it supports both SQL 2005 and SQL 2012!)
  • Upgrade from (GP 9.00.0114) to GP 2010 (GP 11.00.2320) that supports direct upgrade to GP 2013.
  • Moved upgraded databases from SQL 2005 to SQL 2012 with moving all users and configurations.
  • Upgraded to GP 2013 SP2.
  • Checked System stability.
  • Updated Users permissions and passwords.
  • Installed Dynamics GP 2013 with SP2 on all clients
  • Installed Management Reporter that replaces the FRx on the server and on the clients.
  • Migrated existing FRx Reports to Management Reporter
  • Activated SQL Reporting Services
  • Installed and activated Dynamics GP Web Client
  • Started the data entry!

This operation took the first weekend!

Server II:

  • Took a backup for all databases.
  • Upgraded from your current version GP to the service pack that supports the upgrade to GP 2013.
  • Upgraded to GP 2013 SP2.
  • Checked System stability
  • Created new companies on the new server
  • Restored databases from old server to PROCCOSQL over newly created databases
  • Update databases collation to match old server collation (I used the tool that updates the SQL database collation by dropping all functions, constraints and indexes that is collation dependence)
  • Updated CURRENCY ID in all databases columns to match the newly added currencies, it was indexed as “100X” and changed to “10XX”
  • Update Company ID in all databases columns to match the newly added companies.
  • Add newly created companies to Management Reporter
  • Activate SQL Reporting Services

This operation took the second weekend! Till now everything is working properly and this is how their GP looks like right now:

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Friday, May 30, 2014

Dynamics GP 2013 Excel Paste vs Dynamics Innovations Excel Paste

This morning i been working on the R2 release and been enjoying the newly added features and been playing around the newly added paste feature

Factor GP Paste DI Paste Winner
Speed (when pasting 1500 rows) 100 seconds 60 seconds DI
Data Validation Data validated No data validation Microsoft
Coverage* GL Only All forms DI
Intercompany** Not Available Available DI
Columns Order Modifications** Not available Available DI
Update Existing Journal Not available Available DI
Paste Multiple Journals** Not available Available DI
    • * All GP forms is covered in purchased version only.
    • **This feature is only currently available with purchased version, we expect this to be free soon.

Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Thursday, May 29, 2014

First look to Dynamics GP 2013 R2

I just upgraded to GP2013 R2! I liked the way the changed the “Login” form, this to apply the identity management process!

image

Next thing I liked is the new look and feel:

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Dynamics GP 2013 R2 has been Released

It has been finally released! With a long list of enhancements and new modules, below are download links:

Microsoft Dynamics GP 2013 Product Download Page  - NEW DVD is HERE!

Microsoft Dynamics GP 2013 Service Pack Page - click HERE


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Wednesday, May 28, 2014

Management Reporter CU9 does not support windows XP

One of my customers recently upgraded his environment to SQL 2012 and GP 2013 from windows 2003 and GP 9.0, upon installing Management Reporter with CU 9.0 that supports SQL 2012 I have realized that it cumulative update no longer supports windows XP, therefore I had to rollback my installation and install CU8 then re-imported my reports.

Published to let you know before planning any upgrades!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Wednesday, May 21, 2014

Disable “Remember Company” checkbox

I got a request from one of my customers to disable the flag of “Remember Company” that exists on the company login form below:

image

I have made this using VBA, please download the code using the link below:

http://di.jo/Files/RememberCompany.zip


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Tuesday, April 1, 2014

MVP for another year!

Today I received a mail from Microsoft informing me that I have been awarded the MVP for the sixth successive year!

Nothing else to be said, thank you Microsoft for considering my community contributions!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Monday, March 3, 2014

Dynamics Innovations - Careers Opportunity

I am proud to announce the availability of the following positions for talented candidates, if you feel that you are qualified to fulfill these positions, please feel free to submit your resume and we will be contacting you immediately.

I would kindly ask only “ready” people to send their resumes, honestly  we cannot look into resumes without having enough qualifications, we are looking for candidates to start working on projects from day five, the first 4 days will be an orientation to get introduced to our standards and how we do business.

Opening #1 – Microsoft Dynamics CRM Expert:

We are looking for a highly effective Dynamics CRM Consultant to join our team full-time. This person will utilize best practices and methodologies to design, customize, integrate, implement and/or upgrade Microsoft Dynamics CRM and associated solutions for our clients. This consultant will work extensively with internal teams, clients, and vendors throughout the project, providing subject matter expertise and hands-on implementation experience. Consultants will also play a lead role for smaller clients and projects. This consultant must have strong written and oral communication skills.

Requirements and Qualifications

  • 3-5 years of development experience, with at least 2 in Dynamics CRM versions 2011 or 2013 required.
  • Must have excellent communication and interpersonal skills
  • Microsoft certifications preferred
  • Consulting experience preferred
  • Ability to independently manage individual time and tasks.
  • Complete project tasks as assigned, on time and budget
  • Ability to quickly adapt to new requirements and changing situations.
  • Professional and clear working manner onsite with clients.
  • Technical experience with:
    • ASP.Net, C#, VB.Net
    • Microsoft SQL server, including SSRS and SSIS
    • Data Mining, T-SQL, Views, Stored Procedures, Database Design
    • HTML/DHTML/JavaScript/JQuery/VBScript/CSS
    • XML/XSL/Web Services

If you feel you are qualified to fulfill this position, please send an e-mail with the following format:

Subject : DI20140001: Dynamics CRM Consultant

To : careers@di.jo

 

Opening #2 – Microsoft Dynamics GP Support Specialist:

We are looking for a highly effective Dynamics GP Support Specialist to join our team full-time. This person will respond to and resolve support requests from customers, perform contracted maintenance and system management tasks, and identify and route consulting and development requests to the appropriate departments. This specialist must have very strong written and oral communication skills, be highly organized, and capable of multitasking and managing projects.

For sure due to the nature of our business, the role of position might be changed to Dynamics GP new implementations and therefore we are looking for resources who are capable to implement the product from the first day.

Requirements and Qualifications

  • Respond to support requests within the contracted response time.
  • Track and manage open cases to resolution.
  • Install and configure GP and related products for end users.
  • Troubleshoot issues in GP, FRx, Management Reporter, Integration Manager, Business Portal, and ISV products.
  • Manage support tickets for ISV products
  • Gather client requirements and document functional specifications
  • Perform system testing and end user client training
  • Troubleshoot and support Microsoft enterprise technologies
  • Complete project tasks as assigned, on time and budget
  • Provide client status updates to project manager and clients on a regular basis
  • Receptive to mentoring

Qualifications

  • 3-6 years working with Microsoft Dynamics GP in a consulting capacity, with at least 2 year experience with GP 2010 preferred.
  • Demonstrated understanding of core Financials, POP, SOP, and Manufacturing is a plus
  • Demonstrated understanding of Business Portal and requisition management
  • Demonstrated understanding of ISVs preferred
  • Ability to define, create and complete project deliverables with minimal guidance.
  • Ability to independently manage individual time and tasks
  • Ability to quickly adapt to new requirements and changing situations
  • Exhibits professionalism at all times
  • Microsoft Sure Step methodology certification and experience preferred
  • Dynamics GP certification and experience preferred

Travel
Support coverage is primarily by telephone and email, using remote support tools. Travel may be required to a customer’s sites, we pay good per-diem!

If you feel you are qualified to fulfill this position, please send an e-mail with the following format:

Subject : DI20140001: Dynamics GP Support Specialist 

To : careers@di.jo

 

DI-Logo (2)

Company Overview

Dynamics Innovations Co. Is the top seller, BEST team of consultants and the leading Microsoft Dynamics GP gold certified partner in Jordan.

It was founded mainly to bridge the gap in the daily haphazardly management practices by providing personalized business solutions based on a solid experience and computerization the functionalities of the business organization departments.

Why Work for Us

Software Answers continually seeks to hire talented individuals to join our growing company. We’re proud of our high-quality Microsoft products, and look for the brightest, hard-working, most innovative individuals who share our commitment to our values, to our products and to our school district customers. We offer exceptional career opportunities and are a growth-oriented company.

Our greatest asset is our people, and we’re proud that our employees are some of the most intelligent, innovative talents in Jordan. We offer an open, friendly culture, where working hard and producing high quality work is rewarded, and personal development is encouraged. Our work environment is fast-paced – yet relaxed and at the same time exciting! Collaboration and innovation is a staple at Software Answers! The team work and camaraderie makes it exciting to come to work every day!




  • Number of Employees: 14 - 25
  • Weekends: Friday & Saturday
  • Lunch Break: We call it "Gaming" hour any time during the day in the gaming center of the company.
  • Working Hours: 09:00 AM - 06:00 PM

  • How do we look like:


    IMAG0290 IMAG0291 IMAG0292 IMAG0293 IMAG0294 IMAG0295

    Sunday, March 2, 2014

    Unable to start execution of step 1 (reason: line(1): Syntax error)

    This morning I worked with one of the customers on configuring the database backups, and stuck with an issue that after finalizing the Maintenance Plan the job been generating an error, getting into the job history I have seen the below dumb message:

    Unable to start execution of step 1 (reason: line(1): Syntax error)

    Luckily I found the below articles about this subject and it helped:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/dc52e0d9-af14-46b9-9904-29b9afa798cd/syntax-error-executing-maintenance-plan-job?forum=sqldatabaseengine

    http://www.sqlserver-expert.com/2011/08/unable-to-start-execution-of-step-1.html

    I found few difficulties while looking into the “package” mentioned in the resolution and therefore I though I would share a screenshot, adding a slash “\” to the beginning of the text worked like a charm:

    image


    Regards,

    --
    Mohammad R. Daoud MVP - MCT
    MCP, MCBMSP, MCTS, MCBMSS
    +962 - 79 - 999 65 85
    me@mohdaoud.com
    http://www.di.jo

    Sunday, February 23, 2014

    Fell the Management Accounting power with ERP

    Hello Guys,

    I am joining Emad Al Faris from Microsoft in presenting a couple of sessions for JAMA (Jordanian Association for Management Accountants), under the subjects of:

    1. Get to know ERP solutions – by Emad Al Faris

    2. Fell the Management Accounting power with ERP

    Everyone is welcome to join! Below the session brochure:

    http://di.jo/files/erp.pdf


    Regards,

    --
    Mohammad R. Daoud MVP - MCT
    MCP, MCBMSP, MCTS, MCBMSS
    +962 - 79 - 999 65 85
    me@mohdaoud.com
    http://www.di.jo

    Wednesday, January 29, 2014

    Exchange Rates Feed

    Few days back I got mails from many customers reporting that the exchange rates feed stopped working due to an error with the host, the tool was linked to a free exchange rates provider source and therefore it is unsupported.

    Yesterday Mark Polino gave me a great idea to pull sources from YAHOO or GOOGLE and ignore the source we are using, and due to the large base of customers currently using this product I have redeveloped the product to count on more reliable source by readying from YAHOO which I believe will not go down for long time!

    YAHOO API provides the rates over a methodology that does not work with the product, therefore I had to “find/amend” a web-service that reads from YAHOO and send results back to the application and the web-service is currently hosted at our web host, I know that the host is not reliable as YAHOO but at least we can get rid of issues we used to face and minimize the downtime as it became controllable.

    To get the updated package, please drop me a mail and I will send it immediately!


    Regards,

    --
    Mohammad R. Daoud MVP - MCT
    MCP, MCBMSP, MCTS, MCBMSS
    +962 - 79 - 999 65 85
    me@mohdaoud.com
    http://www.di.jo

    Related Posts:

    Related Posts with Thumbnails