Sage Line 500 V7.1 CSAgent TCR and Form appear to start but ports never open
Recently we had this issue where after windows patches were applied, after a reboot the Sage Line 500 v7.1 Windows […]
Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10
The below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously […]
Force TSQL dateformat
If you get the following error on scheduled stored procedures, force the dateformat (The Microsoft SQL Server scheduler will probably […]
Use a case to make sure provided data is a date
I find this useful for using validating spreadsheet imports, using ISDATE can just blank the field if crap data is […]
Check the audit on Business Objects XIR3 SP7 for logons
This is useful to see who is using their licenses which are very expensive. I tend to check every few […]
In VBA strip out characters which cause TSQL to fail
A simple way to strip out characters which can cause TSQL Code to break. Assumes the SQL commannd is in […]
Sage EDI IN Intermediary Email
I have found users don’t always read the logs from the Adaptus EDI Module anymore in Sage Line 500. There […]
Maintain regtrans-ms and blf files generated by Georgia UTS sessions
A little script I schedule for servers using Georgia UTS. Below I use Robocopy to move files older than 3 […]
Force launch IE with a Shortcut
I needed to force Windows 10 to open a web browser in IE for some internal applications as they still […]
Disable Powerpoint 2016 extended display mode
Credit: http://tips.timscomputer.com/disable-powerpoint-2013-extended-display-mode-via-registry/ Disable the extended display mode upon login, same as the link just modified the version from 15 to […]