2018

Compatible with GP 2018 R2 and qb2019 Enterprise

SOI – Prerequisite Information fails Revision Date: 08/09/2018 Module: Synergy Office Integration – (SOI) Version: 258sp6 Description: While installing SOI with Office 2013, 2016 or 365 already installed the following error may appear. Executing the Exact.SOI.Prereqquisite.installer.exe runs but does not appear to do anything. The only choice when complete is "Download" or "Next", selecting "Next"…

If you do not have a SAMPLE DB create one in the system manager. DELETE FROM ExactMAXyourdb..MAX_Security where USERNAME_82 = ‘MANAGER’ INSERT INTO ExactMAXYOURdb..MAX_Security ( [USERNAME_82] ,[PASSWORD_82] ,[MODULE_82] ,[LOGIN_82] ,[FEATURES_82] ,[SYNUSER_82] ,[SYNPASSW_82] ,[CONVERT_82] ,[CreatedBy] ,[CreationDate] ,[ModifiedBy] ,[ModificationDate] ,[DOMAINNAME_82]) SELECT * FROM ExactMAXSAM..MAX_Security

Here it is. Create a SQL Job that executes this to clear users that have logged off. USE ExactMAX DELETE FROM ERMUD where MachineName not in (select distinct(hostname) from master.dbo.sysprocesses where program_name=’Exact MAX’) AND MachineName not like ‘%##Terminal##%’ and CompanyName not like ‘%-##-%’

Concise Guidelines for MAX and Dynamics GP Multi-Company Packaged software utilization is driven by the organizational structure. Software and computerization allows for speed of communication across the organizations landscape and provides information, control, security and predictability through analytic techniques. Thus, to model software usage that increases production, service and efficiency, it is required to have…

Found this on a search engine site – handy – full article here: https://www.searchenginejournal.com/google-search-operators-commands/215331/ Advanced Google Search Operators Cache Using the cache operator, you can find out what the most recent cache of a specified webpage is. This is useful for identifying when a page was last crawled. Example use: cache:websitename.com Allintext This operator will…

20180824-00:00:00:000 — SELECT CONVERT(VARCHAR,@date,112) + ‘-‘ + CONVERT(VARCHAR,@date,114) 20180824-203947843 — SELECT CONVERT(VARCHAR,@date,112) + ‘-‘ + REPLACE(CONVERT(VARCHAR,@date,114),’:’,”) 08/24/2018 101 SELECT CONVERT(VARCHAR,@date,101) 2018.08.24 102 SELECT CONVERT(VARCHAR,@date,102) 24/08/2018 103 SELECT CONVERT(VARCHAR,@date,103) 24.08.2018 104 SELECT CONVERT(VARCHAR,@date,104) 24-08-2018 105 SELECT CONVERT(VARCHAR,@date,105) 24 Aug 2018 106 SELECT CONVERT(VARCHAR,@date,106) Aug 24, 2018 107 SELECT CONVERT(VARCHAR,@date,107) 10:00:00 108 SELECT CONVERT(VARCHAR,@date,108) Aug 24 2018…

Part_Master Key Value not Found – CLR was disabled If you run into an error like this when you’ve just installed SQL Server and MAX is could be the CLR was not enabled. Verify CLR is enable by running the following server Configuration script. sp_configure @configname=clr_enabled, @configvalue=1 GO RECONFIGURE GO