Vincent Stefanetti

Vincent Stefanetti Senior Consultant MAX Manufacturing Software Working with MAX and Related Technologies Since 1987 MAX ERP System Implementations and Projects MAX, Dynamics GP, Synergy, Event Manager, Crystal Reports, SQL Reporting Services, Database and System Migrations and Updates, MAX Training Classes - All Levels, Custom Reporting.

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

T-SQL XML Path Solution to BOM Notes to a Single Row

SELECT SS.PARPRT_02, SS.COMPRT_02, SS.EFFDTE_02 , SS.QTYPER_02, (SELECT ‘~’ + US.NOTES_61 FROM Windows_Notes US WHERE US.PRTNUM_61 = SS.PARPRT_02 AND US.COMPRT_61 = SS.COMPRT_02 AND US.EFFDTE_61 = SS.EFFDTE_02 AND US.TYPE_61 = ‘BM’ FOR XML PATH(”) ) [BOM/NOTES] FROM Product_Structure SS WHERE PARPRT_02 <> ” GROUP BY SS.PARPRT_02, SS.COMPRT_02, SS.EFFDTE_02, SS.QTYPER_02 ORDER BY 1, 2 Vincent Stefanetti Senior Consultant…

Read More

Clear GP Users

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 DYNAMICS..ACTIVITY)

Read More