ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
DrillDown Icon Verify System License Message
DrillDown Icon Trigger
DrillDown Icon Desktop Time Out
DrillDown Icon Stimulsoft
DrillDown Icon Clear Cycle count-SQL
DrillDown Icon Error Code 0x80004005
DrillDown Icon Error: Update has Failed Database "MANEX" is Full
DrillDown Icon Learn More About Creating SQL Queries from SQL Joins
DrillDown Icon Stop SQL Server Transaction Log (.LDF) files from Growing Indefinitely
DrillDown Icon Version of MSSQL and License Requirement for SQL
DrillDown Icon What Kind of Re-Indexing and Other DB Maintenance will need to be Done?
DrillDown Icon What are the hardware requirements to install SQL Server?
DrillDown Icon Zendesk Ticket
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Trigger Detail and How To's

Triggers Setup 

Please note in order for this trigger setup to work you must be on Desktop Version 2018.04.01 

(If you are not on V2018.04.01 Please contact support for help setting up triggers)


Here are the following Triggers we currently offer on SQL

 

Trigger Name    Description  
SO Acknowledgement Notify me when a SO has been acknowledged
ECO Initiated When a new ECO is Created, review/approve new ECO (If you use trigger name 'ECO' it will subscribe both ECO Initiated and ECO Released)
ECO Released When ECO is completed (If you use trigger name 'ECO' it will subscribe both ECO Initiated and ECO Released)
Rejected Material Notify when material was rejected during upon receiving
RMA CM Created Notify when RMA Receipt has generated a new Credit Memo
DMR DM Created   Notify me when DMR Shipment has generated a new Debit Memo

 

​The attached script can be used to add/change/remove triggers. 


NOTE: You can only add triggers for users setup in ManexCloud with an email address. 

 

You can run the below part of the script to see a list of users to choose from. 


NOTE: You can run the first line in the attached script to see a list of users currently subscribed to a certain trigger. 

 


Below Example Trigger

Subscribing two users to the RMA CM Created trigger 


Another Example Trigger:

Removing a user from the ECO Initiated trigger.

 

 

 

 

 

Attachments
Article ID: 6089