Category Archives: Uncategorized

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

MAX Electronic Work Orders Factsheet

MAX Electronic Work Orders Factsheet.pdf MAX Electronic Work Orders Factsheet.pdf

Posted in Uncategorized | Leave a comment

Entitlement License of KNowledgeSync!

Have you heard about our new KnowledgeSync™ Entitlement Promotion? Customers who are active on their M&S are entitled to use a complimentary license of KnowledgeSync Alerts & Automation v9 Core Click here if you’re ready to get started or you’d … Continue reading

Posted in Uncategorized | Leave a comment

Using the MRP Explosion Stored Procedure

Posted in Uncategorized | Leave a comment

DO YOUR MAX UPGRADE TO 5.5.9 AND DYNAMICS 2018R2 / QB 2019 ENTERPRISE

I wanted to take a moment to provide you an update and also give you some very good news. Contact me to get assistance on any of this!! Let’s get your upgrades and installations scheduled for these new updates and … Continue reading

Posted in Uncategorized | Leave a comment

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

Posted in Uncategorized | Leave a comment

POSTED_15 Column in Transaction History

How does the POSTED_15 field in Transaction_History table work? The field is used to indicate whether or not a transaction can be posted by the From/To Charge report and has been posted. Possible values in this field are: Blank = … Continue reading

Posted in Uncategorized | Leave a comment

Analyze SQL/MAX Connections

Posted in Uncategorized | Leave a comment

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

Posted in Uncategorized | Leave a comment

Announcing the release of Max 5.5.9

Subject: Preview – Announcing the release of Max 5.5.9 ECi Software is please to announce the release of Max 5.5.9, batch 4775. Max 5.5.9 is available for download! Hi Friend, ECi is pleased to announce the release of Max 5.5.9, … Continue reading

Posted in Uncategorized | Leave a comment