Tuesday 25 October 2016

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.

Monday 17 October 2016

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