DynDeveloper.com

(sigh)

Steve says that I need to blog this article. I don't know why.

https://winthropdc.wordpress.com/2015/11/05/gpugsummit-day-2/

This is an advanced troubleshooting issue in the Web Client.

The symptom is that when you log onto the Dynamics GP web client and you enter in your AD username/password, you're directed to a second SQL logon request, shown below. We shouldn't need to do this, the AD logon should let us in.

This article discusses the fix.

You need to run Microsoft Dynamics GP Utilities before you can run Microsoft Dynamics GP.  Do you want to launch Microsoft Dynamics GP Utilities now?

I used an older code to try and migrate the logins from 2008 R2 to 2014  and it wasn't recognizing sysxlogins 

IF (@login_name IS NULL)
  DECLARE login_curs CURSOR FOR 
    SELECT sid, name, xstatus, password FROM master..sysxlogins 
    WHERE srvid IS NULL AND name <> 'sa'
ELSE
  DECLARE login_curs CURSOR FOR 
    SELECT sid, name, xstatus, password FROM master..sysxlogins 
    WHERE srvid IS NULL AND name = @login_name

so I found an updated code...

Hi,

 I have to import 3 types of Invoices into GP and was wondering what was the best method to accommodate the following scenarios.

In one file, 3 invoices will be present,  

1. Regular AP Invoices unrelated to PO's or Receipts, but in the same format as the next 2

2. 2 Way match - Invoices related to noninventory PO items (received or unreceived).

3. 3 Way Match - Invoices related to inventory PO items (received or unreceived).

 Should I use the Receivings Transaction Entry eConnect objects or the Enter/Match Invoice eConnect Objects, or both?

Any feedback will be very helpful.  thanks all!

~Mark

We are working on a larger Econnect Integration using .NET MVC.  We have come across an issue whereas the eConnect model is not binding to our form POST when working with eConnect objects but instead are returning an empty object.  All other objects are binding as expected in our bigger integration.  I have torn it down to its simplest form following Microsoft MVC standard below to show our issue. Is this expected behavior for eConnect objects?

The odd part about this is it works in WebServices using their objects.  Unfortunaly there are some missing peices from WebServices, like UpdateItem.

Test:

Hi,

 I have been given the task of integrating with a dynamics solution and creating Purchase Invoices.  This is all going according to plan, however there is one stumbling block that I cannot resolve.

For a purchase invoice, there is a TaxScheduleKey - this relates to the form within dynamics called Tax Schedule Maintenance, and each Tax Schedule has a configured Tax Detail.

What I need to do is pull a list of all of these Tax Schedules and their related Tax Details from dynamics and synchronise it with our own database to provide lookups so they can alter the tax rates of the invoice before posting to dynamics, but I cannot seem to find any method for retrieving either, I can only seem to set the Tax Schedule key.  

There are over 40 dynamics databases I need to synchronise with, so unfortunately I don't really see a manual import of the data as an option (except a last resort)

Thanks

Dynamics CRM 2013-2015 Upgrade Questions

Regarding some clarifications to the 2013-2015 Migration, I have the following thoughts and questions... would greatly appreciate any input insofar as corrects to the thought process and answers to these questions. Many thanks in advance.

1. As a prerequisite to installing the CRM 2015 Server product,  installation of SQL Server 2014 is performed. During the SQL Server 2014 installation, a new instance is created, e.g. CRM2015.

Question:

During the creation of this new instance (using SQL Server setup) should the ReportServer database be included ? It would seem that we would want only one ReportServer database in all instances, not one in each instance.

 2. Another SQL Server Instance is created so that the CRM2013 database can be restored to it, and from there the Organization Can be imported (which will be imported into yet another New Instance). Note: Only one CRM Database can exist in each instance.

Questions:

During the SQL Server Installation creation of this new instance should the ReportServer database be included ?

Does the ReportServer database from the original 2013 CRM Database need to be restored to this instance? What about existing and custom reports that may have been created in 2013 and how are they migrated ?

 3. The 2013 CRM databases:

PRMCRM2013_MSCRM

MSCRM_CONFIG

Are to be restored to the instance created in Step 2 above. This restored database will be used as the restore source during the Import Organization Utility, and will create a new database with upgraded 2015 data.

Questions:

Where is the data migrated to? Is a new instance created, since it is understood that only one CRM Database can reside in one SQL Server instance? In addition, in which instance is the primary ReportServer Database going to reside ? Are configuration changes required to be made to location of the ReportServer database, because during the Import Organization routine the ReportServer URL address was pointed to the CRM2015 Instance (the new install of 2015 where the SSRS Data Connection Tools were pointed to). It would seem like there needs to be a reconfiguration of the ReportServer URL after the database has been successfully upgraded to the new instance, and a re-install of the SSRS Data Tools Extensions and Data Connector to the new, upgraded database--uncertain where this new database will reside (e.g. in which SQL Server Instance).

4. Received an error message during Import Organization, User Mapping. All users are not mapped.

Question:

How can this be addressed without errors so the process is more streamlined?

5. Receiving a defragment/rebuild warning on indexes. This can be resolved using the following TSQL Script to rebuild all indexes in a database

DECLARE @Database VARCHAR(255)  

DECLARE @Table VARCHAR(255) 

DECLARE @cmd NVARCHAR(500) 

DECLARE @fillfactor INT

SET @fillfactor = 90

DECLARE DatabaseCursor CURSOR FOR 

SELECT name FROM master.dbo.sysdatabases  

WHERE name NOT IN ('master','msdb','tempdb','model','distribution', 'MSCRM_CONFIG','ReportServer$CRM2013', 'ReportServer$CRM2013TempDB')  

ORDER BY 1 

OPEN DatabaseCursor 

FETCH NEXT FROM DatabaseCursor INTO @Database 

WHILE @@FETCH_STATUS = 0 

BEGIN 

   SET @cmd = 'DECLARE TableCursor CURSOR FOR SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' +

  table_name + '']'' as tableName FROM [' + @Database + '].INFORMATION_SCHEMA.TABLES

  WHERE table_type = ''BASE TABLE'''  

   -- create table cursor 

   EXEC (@cmd) 

   OPEN TableCursor  

   FETCH NEXT FROM TableCursor INTO @Table  

   WHILE @@FETCH_STATUS = 0  

   BEGIN  

       IF (@@MICROSOFTVERSION / POWER(2, 24) >= 9)

       BEGIN

           -- SQL 2005 or higher command

           SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'

           EXEC (@cmd)

       END

       ELSE

       BEGIN

          -- SQL 2000 command

          DBCC DBREINDEX(@Table,' ',@fillfactor) 

       END

       FETCH NEXT FROM TableCursor INTO @Table  

   END  

   CLOSE TableCursor  

   DEALLOCATE TableCursor 

   FETCH NEXT FROM DatabaseCursor INTO @Database 

END 

CLOSE DatabaseCursor  

DEALLOCATE DatabaseCursor

 6. Received a warning that indexes are not consistent with Microsoft Dynamics CRM Indexes:

The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes.

The following indexes are not consistent with Microsoft Dynamics CRM indexes:

tablename:                              auditbase

indexname:                              ndx_primarykey_audit

remark:                                 deleted index

tablename:                              auditbase

indexname:                              ndx_primarykey_audit_primary

remark:                                 deleted index

Questions:

How should this be dealt with – does the Import Organization utility make necessary overrides ? Will this adversely affect the database ?

 7. Received a warning message THAT THE FOREIGN KEY CONSTRAINTS IN THE Microsoft Dynamics CRM Database are not consistent with Microsoft Dynamics CRM foreign key constraints:

The foreign key constraints in the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM foreign key constraints.

 The following foreign key constraint(s) are not consistent with Microsoft Dynamics CRM foreign key constraints:

name:                                   activity_pointer_new_dispatchlog

remark:                                 added foreign key

name:                                   activity_pointer_po_surveyactivity

remark:                                 added foreign key

name:                                   new_appointment_opportunity_quailifier

remark:                                 added foreign key

name:                                   new_competitor_lead_currentservicecompany

remark:                                 added foreign key

name:                                   new_contact_account_billingmanager

remark:                                 added foreign key

name:                                   new_contact_account_secondarycontact

remark:                                 added foreign key

name:                                   new_contact_contact_reportsto

remark:                                 added foreign key

etc. …

Question:

It looks like the import utility make corrections to these foreign key constraints. Is this correct?