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 — To turn off Stored Procedure MRP IF EXISTS (SELECT * FROM CompanySettings WHERE KeyName…

Read More

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 Review the Command Prompt screen for errors. All copies should succeed. Log into MAX MAX…

Read More

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 CORRECTIONS ID Backlog Group Title Resolved in Build D- 55265 COSTING Total Order Cost report…

Read More

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 with the correct information: for %%G in (*.sql) do sqlcmd /S SQL_Server /d MAX_Company_Database -E…

Read More