Monthly Archives: June 2019

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