Management Reporter Crash when Importing Reports

You click Building Block Groups and go to import some reports, when you navigate to the file and click import everything freezes.

This is an issue caused by a microsoft update. It was resolved in versions of Management Reporter 2012 CU13 and higher. If you are unable to use a version higher then all you have to do is not place your mouse icon into the area where the reports are on the import window.

Hence, just click import, navigate to the location and click select all and then proceed with the import, do not put your cursor in the top window or anything as this is what causes the application to crash. Seems to be some pop up message issue cause by a microsoft windows update.

Smartconnect Map runs in one company but does not run in another company

So you created a map, run it to test on your test company and it works.

Then you run it on the live company and boom, nothing happens. Smartconnect just counts your records and does not import any.

In your mapping you have a GP Rolling column created. You need to delete it and re-create it with your mapping on the live company (this is defined in the companies window in the front). This will make the rolling column look at the correct company.
Re-run integration and it will work now.

Dynamics SL Backups Required

 Here’s what should be backed up daily:

1. The Dynamics SL application database
2. The Dynamics SL system database
3. The FRx 6.7 folder in the Dynamics SL installation area (if you are still using FRx)
4. The Usr_Rpts folder in the Dynamics SL installation area

Backing up Custom Dynamics SL Reports

If there are any customized reports in the system they will be located in the Usr_Rpts folder in the SL Program Files.

Typically, this path is something like C:\Program Files (x86)\Microsoft Dynamics\SL\Applications.

To back them up - Make a copy of the Usr_Rpts somewhere and put it in a different location than the SL program files.

Workflow error Dynamics GP

I had Workflow working in Purchase Requisition processing up to the last time i used my vm.  Started using it today and when I submit a purchase requisition for approval I get the error below.  Note no changes had been made and this error appears now where everything worked previously:

"[Microsoft][SQL Server Native Client 10.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "SendWorkflowCompletionEmail". System.IO.FileLoadException": Could not load file or assembly 'System.DirectorSer[..." Error gets cut off at the end.

Resolution:

STEP 1:

Go to Microsoft Dynamics GP>> Maintenance>> SQL

Scroll to User Messages in the DYNAMICS db, insert and click 'create stored procedure'.

STEP 2:

Go to SQL and run the following script against DYNAMICS (system database)

exec wfDeployClrAssemblies

Unable to click arrows in SSRS

From IE 10 and up you will not be able to click on the drop down arrows in SSRS.

To resolve this issue you have to add the page to compatibility in ie.

How -
Go to the Menu bar in Internet Explorer then click Tools> Compatibility View Settings>> Click Add.

This will add the page to compatibility view and you will be able to click on those arrows now.

Scheduled Smartconnect map not running automatically only manually

So you have a schedule setup. File in folder ready for running but the file does not import. You look at smartconnect and see the map showing it ran but it didnt.

If you run it manually it works.

So what to do?
Restart eone service and then it will work.