Category Archives: Uncategorized

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

NET1 Payment Processing Solution Introduces New Multi-location Functionality

Reporting and security for enterprises with multiple locations can be handled through one point of access Fort Worth, TX—Wednesday, June 12, 2019 ECi Software Solutions, a leader in cloud-based business management solutions, today announced multi-location functionality for the NET1® Payment … Continue reading

Posted in Uncategorized | Leave a comment

Update Primary Vendor from Last PO Rec

Posted in Uncategorized | Leave a comment

MAX Install

There are only a few things that can cause the install to fail. Not a local admin on the machine (Windows – Computer) .Net 3.51 not loaded in Windows (Control Panel – Windows Features) Firewall is on or no exception … Continue reading

Posted in Uncategorized | Leave a comment

MAX 5.5.9

Compatible with GP 2018 R2 and qb2019 Enterprise

Posted in Uncategorized | Leave a comment