Author Archive:

rss feed

Dynamics GP 2013 R2 – New User Maintenance

| 06/05/2014 | 0 Comments

I liked the new active directory utilization for GP 2013 R2! take a look how does it look like now: Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Currency Symbol is incorrect for some GP forms

| 06/05/2014 | 0 Comments

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: 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

Continue Reading

Update Company ID field across all company database

| 06/05/2014 | 0 Comments
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

Continue Reading

Consolidating multiple Dynamics GP Companies into single DYNAMICS database

| 06/05/2014 | 0 Comments

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)

Continue Reading

Dynamics GP 2013 Excel Paste vs Dynamics Innovations Excel Paste

| 05/30/2014 | 0 Comments
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

Continue Reading

First look to Dynamics GP 2013 R2

| 05/29/2014 | 0 Comments

I just upgraded to GP2013 R2! I liked the way the changed the “Login” form, this to apply the identity management process! Next thing I liked is the new look and feel: Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Dynamics GP 2013 R2 has been Released

| 05/29/2014 | 0 Comments
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

Continue Reading