Category Archives: Uncategorized

MAX 5.5.9

Compatible with GP 2018 R2 and qb2019 Enterprise

Posted in Uncategorized | Leave a comment

SOI – Prerequisite Information fails

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 … Continue reading

Posted in Uncategorized | Leave a comment

Analyze Connection Data

Posted in Uncategorized | Leave a comment

Reset MANAGER Password in MAX

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 * … Continue reading

Posted in Uncategorized | Leave a comment

Clearing Disconnected Users

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 … Continue reading

Posted in Uncategorized | Leave a comment

Concise Guidelines for MAX ERP and Dynamics GP Multi-Company

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, … Continue reading

Posted in Uncategorized | Leave a comment

Advanced Google Search Operators

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 … Continue reading

Posted in Uncategorized | Leave a comment

SQL Date Conversion Formats

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 … Continue reading

Posted in Uncategorized | Leave a comment

Part Master – Error 4 Key Value Not Found

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 … Continue reading

Posted in Uncategorized | Leave a comment

Mathematical Symbols

Symbol What it is How it is read How it is used Sample expression + Addition sign … plus … Sum of a few values 3 + 5 = 8 Logical OR symbol … or … Logical disjunction ¬(A + … Continue reading

Posted in Uncategorized | Leave a comment