Category: Sage Line 500 ERP
Check scheme.plitempm for any orphaned entries
Check scheme.plitempm for any orphaned entries against plpy tables, found to be caused by third party app not Sage Line […]
V1 DBAuthorise grab a list of Purchase Orders
V1 DBAuthorise can be setup to have multiple Purchase orders, so I use a Common Table Expression in a view […]
Maximum History Reached in Code & Post Registered Invoices
Credit: Datel Code & Post Registered Invoices has a database limit on the plreghstm table and can hold 79 rows […]
Prevent Duplicate Audit Entry warnings on Sage Line 500 when migrating systems
The file .seqno in csmaster/master is used to maintain the current audit reference. Ensure its copied from the old server […]
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 […]