Monthly Archives: November 2019

SQL Server Compatibility with Windows Server

Windows Server Supported DBMS Version SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 Win 2003 SP2 N/A N/A N/A N/A Win 2008 Supported Supported N/A N/A Win 2008 SP2 Supported Supported N/A N/A Win 2008 … Continue reading

Posted in Uncategorized | Leave a comment

Using the MRP Explosion Stored Procedure

— To turn on Stored Procedure MRP IF EXISTS (SELECT * FROM CompanySettings WHERE KeyName = ‘UseMRPStoreProcedure’) BEGIN UPDATE CompanySettings SET BVal = 1 WHERE KeyName = ‘UseMRPStoreProcedure’ END ELSE BEGIN INSERT INTO CompanySettings (KeyName, BVal) VALUES (‘UseMRPStoreProcedure’, 1) END … Continue reading

Posted in Uncategorized | Leave a comment

MAX Client Troubleshooting

MAX ERP Client Install Troubleshooting New: Go to \\YourServerName\EXACTSHARED\EXACT\EXACT\RMSERVER\NET\SETUP.EXE then click through and perform a client install. If prompted for license location select: \\ YourServerName \EXACTSHARED\EXACT\RMSERVER\lic folder Login to workstation Navigate to \\ YourServerName \EXACTSHARED\SERVERMOVE Execute the ServerMove.bat as Administrator … Continue reading

Posted in Uncategorized | Leave a comment

Windows 10 Installs Failures and Crystal Upgrade – Report Button Click No Report

Windows 10 Installs Failures and Crystal Upgrade – Report Button Click No Report The issue with the Windows 10 machines is resolved with a workaround – pending development fix – reporting on CC to support herein. There is a workaround … Continue reading

Posted in Uncategorized | Leave a comment

Error Accessing Management Reporter

Management Reporter CU_16 A connection to the server could not be established. On the server side the user you are logged into Windows as is not a user in Management Reporter. Go to the server Login as user that install … Continue reading

Posted in Uncategorized | Leave a comment

Fill Down Visible Rows Only in Excel

Filter the data Select the cells in a Column you want to fill data F5 Click Special Click Visible Only Hit Space Bar Enter the Value to Fill Down Type CTRL-ENTER

Posted in Uncategorized | Leave a comment

MAX 5.5.10 Released

MAX 5.5.10 Batch 4800 MAX 5.5.10 Batch 4800 is generally available to MAX customers as of November 14, 2019. This release is an update only. Changes in MAX 5.5.10 • Support for SQL Server 2017 • Defect corrections MAX 5.5.10 … Continue reading

Posted in Uncategorized | Leave a comment

Move KnowledgeSync Event Manager to a New Server

How do I migrate KnowledgeSync to another server? Obtain the license for the new server. Open a ticket on the KnowledgeSync web site and request a new license by providing the new server name. 2) KnowledgeSync will not run on … Continue reading

Posted in Uncategorized | Leave a comment

Manual DB Updates

Put the *.SQL files that need to be applied to the MAX company database in a TEMP folder on the SQL Server and run the following command in a command prompt window from the TEMP folder, replacing SQL_Server and MAX_Company_Database … Continue reading

Posted in Uncategorized | Leave a comment