Enable CLR on SQL Server
To enable CLR on SQL Server run this script: sp_configure ‘clr enabled’, 1GORECONFIGUREGO
To enable CLR on SQL Server run this script: sp_configure ‘clr enabled’, 1GORECONFIGUREGO
SELECT INTERID ‘Database’, CMPNYNAM ‘Company_Name’ FROM DYNAMICS..SY01500
If you find that you click any item in MAX and you get no response as in adding a part or if you try to update a part and receive an DB Error 4. This could be cause by SQL Server CLR not being enabled. Check your SQL Server or ask your DB admin…
/* Code to List all Recovery Models */ select [name], DATABASEPROPERTYEX([name],’recovery’)from sysdatabaseswhere name not in (‘master’,’model’,’tempdb’,’msdb’)
1) Make sure that you have your anti-virus turned off. 2) Check your User Account control settings and make sure they are off 3) Make sure that .Net 3.51 is installed. 4) A new fresh install can also solve any issue that might be present due to other apps installed after MAX has been installed….
Good link to review the possible paths: http://waqasb.blogspot.com/2014/12/dynamics-gp-2015-upgrade-process-paths.html
First Date of last month =DateAdd(“m”, -1, DateSerial(Year(Now()), Month(Now()), 1)) =Today.AddDays(1- Today.Day).AddMonths(-1) Last date of last month =DateAdd(“d”, -1, DateSerial(Year(Now()), Month(Now()), 1)) =Today.AddDays(-1.0 * Today.Day) First date of current month =DateSerial(Year(Now()), Month(Now()), 1) =Today.AddDays(1 – Today.Day) Last date of current month =DateAdd(“d”,-1,(DateAdd(“m”, 1, DateSerial(Year(Now()), Month(Now()), 1)))) =Today.AddDays(-1 * Today.Day).AddMonths(1) Yesterday’s date =DateAdd(“d”, -1,…
/* Handy Date Stuff */ —-Today SELECT GETDATE() ‘Today’ –Full Day SELECT CAST(GETDATE() as date) AS DT —-Yesterday SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’ —- Previous Day DATEADD(day, DATEDIFF(day, 0, yourDate), 0) —-First Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘First Day of Current Week’ —-Last Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘Last Day of Current Week’ —-First…
After CU 11 you need to:Go to Microsoft Dynamics GP > Tools > Setup > Company > Company.Click on “Options” to open the “Company Setup Options” window There is a separate section for management reporter integration with Dynamics GP when the data mart provider is used. Make sure these are checked for that the data…