Blogs

Smith & Allen Consulting joins Njevity

in


Belinda Allen: Smith and Allen ConsultingBelinda Allen: Smith and Allen ConsultingNjevity, Inc. and Smith & Allen Consulting, Inc. (SACI) are pleased to announce they are joining forces effective April 1, 2016. The combined organization will be known as Njevity, Inc.


The combination of these two organizations will provide more geographic reach for Njevity and will add a second Microsoft MVP in Belinda Allen to the Njevity team. SACI is a Microsoft Certified Partner with both east coast and offshore team members, and has over 25 years of experience delighting customers with Dynamics GP and business intelligence solutions.


"Njevity and SACI share very similar core values and cultures and are both focused on delivering exceptional experiences to our customers. The blending of our teams will provide our customers with a greater number of Dynamics experts to serve them. Plus, Njevity's expertise delivering Dynamics GP in the cloud will provide our customers with a world class cloud option that will allow them to extend the life and value of their Dynamics investments," says Belinda Allen, one of SACI's founders.


"We couldn't be more excited to have Belinda, her team and her customers join the Njevity family," said Chris Dobkins, President of Njevity. "The sun will never set on the new Njevity team. Once the integration of our teams is complete, we will not only be able to support our partners and customers at any time of the day or night, but we will also be able to provide our Cloud customers with live analytics and reporting experiences that blur the lines between local Excel, Microsoft's Power BI platform, and Dynamics data stored securely in our Cloud."

 Click Here to read the full press release

 

 

After GP Company database restore: The selected company is not configured as a company of the current Microsoft Dynamics GP syst

After restoring a GP Company Database from another SQL server you may get the following error when trying to log into the restored company:

"The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company"

The following SQL scripts may resolve the issue.

select
CompanyDbId = c.CMPANYID
,DynamicsDbId = d.CMPANYID
,DynamicsDbName = d.INTERID
,DynamicsCompanyName = d.CMPNYNAM
from sy00100 c
left join dynamics..sy01500 d
on d.interid = db_name()

--update SY00100 set CMPANYID = (select CMPANYID from DYNAMICS..sy01500 where INTERID = db_name())

HTML code displayed on the bottom of a navigation list pane instead of returning actual results. GP 2013 and GP 2015.

This has been an issue that Njevity has been struggling with on new GP 2013 and GP 2015 installs. The confusing part has been that it will occasionally go away. With a lot of help from Daryl Anderson at Microsoft we finally found a work around. First of all, the issue goes away as soon as an application is installed that drops a DLL file in the AddIn folder of the GP program files.

For cases where there are no DLL files in the AddIns folder simply copy the Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll
file from the root of the GP installation (example: c:\Program Files (x86)\Microsoft Dynamics\GP2013) to the AddIns sub-folder.

Give users access to SSRS Report Builder

To create role assignments that grant access to Report Builder

Start Report Manager.

Click Site Settings.

Click Security.

If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit.

Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: \. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.

Select System User, and then click OK.

Click Home.

Click the Properties tab.

Click the Security tab.

If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit.

Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: \. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.

Select Report Builder, and then click Apply.

Repeat to create or modify role assignments for additional users or groups.

Increase the Maximum Number of Records Exported from Excel

Microsoft Dynamics CRM by default will allow an export from CRM to Microsoft Excel of up to 10,000 records. If you are trying to export more than 10,000 records, CRM will allow the export, however there is no warning that only 10,000 of your 10,000+ records just exported. The solution for this is to increase the size of your export by changing a database value.

To do this, perform the following steps (applies to CRM 4.0, 2011, 2013, 2015):

1. Open SQL Management Studio
2. Use the _MSCRM database
3. Open the OrganizationBase table
4. Locate the column - MaxRecordsForExportToExcel
5. Change the value to the new value

For a link to Microsoft's KB Article supporting this, please visit http://support.microsoft.com/en-us/kb/911395

Syndicate content