Category: Sage Line 500/1000 ERP
Sage Line 500 password policy implementation and force password reset
I wrote a simple script to aid users moving to a new password policy, users were put on a policy […]
Remove invalid Datalinx WHM Report Records
Where printers have been removed can cause issues with the user report program where you can control where users print […]
Sage Line 500 User Activity Data
Sage Line 500 ERP maintains user activity data in: DATABASE_SERVER.csmaster.scheme.uar
Tidy Sage Line 500 ERP Temporary Tables via TSQL
The official Sage Help has a select statement to delete temporary tables, but doesn’t allow an automated way to remove. […]
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 […]
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 […]
DBForms: Check and format email addresses from Sage Line 500/1000
As the email field can sometimes not be used for the correct purpose I use a bit of code to […]
Sage Line 500 EDI IN Intermediary tables inner join on sql query
On ocassion I need to look at what is in the EDI IN modules intermediary tables, scheme.eiordtm has an annoying […]