I thought I would list out some important dates to help folks to plan for the end of support dates. If you have questions please contact me ASAP. 1) SQL 2005 End of Support April 2016 2) MAX Shop Calendar End of this Year 3) Access End Dates for those on Alliance and those who…
Processing a Configured Order – Concise 1) Add Configured Sales Order a. System Manager > Customer Tab > Sales Order Processing b. Activity > Order Entry c. Sales Order > Sales Order > New d. Select Customer e. Add Line for Family Part f. Tab off price and date > Note the Master Scheduled Shop…
Alert Manager Archive Manager Bill of Lading (Advanced Shipping) Bill of Materials Consignment Consolidated Invoicing Costing Crystal Report Viewer Crystal Report(Europe) Data Collection Module ECO CAD Import ECO Manager Module EDI Integration Manager (EDI) Enhanced Time Ticket Feature Option Configurator Financial Integration Manager Inventory Control Labor Tracking Landed Cost Tracking Lot/Serial Tracking Maintenance Manager Manufacturer…
Wishing Everyone a Merry Christmas and a Happy New Year!! Vince Stefanetti Senior Consultant
delete from DYNAMICS..ACTIVITY where USERID not in (select loginame from master..sysprocesses) delete from tempdb..DEX_SESSION where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY) delete from tempdb..DEX_LOCK where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY) delete from DYNAMICS..SY00800 where USERID not in (select USERID from DYNAMICS..ACTIVITY) delete from DYNAMICS..SY00801 where USERID not in (select USERID from…
1. In SQL Management Studio, run this script to remove the existing password. UPDATE DYNAMICS.SY02400 SET PASSWORD = 0x0202020202020202020202020202020 2. In GP, reset the system password.
Latest Service Pack At this writing it is very important when upgrading to Dynamics GP 2015 that you are on the current service pack/hotfix release. There are known issues that were resolved. Prior Version data in Tables Use the reference below to untangle the problems of prior versions in the tables https://community.dynamics.com/gp/f/32/t/134557
select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500
select name, compatibility_level , version_name = CASE compatibility_level WHEN 65 THEN ‘SQL Server 6.5’ WHEN 70 THEN ‘SQL Server 7.0’ WHEN 80 THEN ‘SQL Server 2000’ WHEN 90 THEN ‘SQL Server 2005’ WHEN 100 THEN ‘SQL Server 2008/R2’ WHEN 110 THEN ‘SQL Server 2012’ WHEN 120 THEN ‘SQL Server 2014’ENDfrom sys.databases