Sage 100

Good morning! I have an alert set up for emailing SO confirmations to salespeople. It is running every minute but is not triggering for all new orders - definitely a timing issue of when the order is 'accepted' in Sage. According to the documentation, I need a 'database trigger' instead of scheduling the event.  The User Manual says to contact tech support. I have reached out but thought I'd check here while I wait.  Does anyone have experience with setting a database trigger?  Thanks!

------------------------------
Dawn Kulbacki
Capitol Computer Systems, Inc.
------------------------------

@Dawn Kulbacki Is this Premium?   If it is, the the tricky part of Sales Order Header triggers is that Sage 100 creates the record when you first grab the order number, but at that point almost all the fields are blank.  So the trigger needs to be for UPDATE, not INSERT, with some way to not keep firing it when orders are updated later.

------------------------------
Phil McIntosh
Friendly Systems
------------------------------

Sorry! This is Sage 100 Advanced.

------------------------------
Dawn Kulbacki
Capitol Computer Systems, Inc.
------------------------------

Original Message:
Sent: 03-20-2025 11:23
From: Phil McIntosh
Subject: Sage Alerts - real-time reporting

@Dawn Kulbacki Is this Premium?   If it is, the the tricky part of Sales Order Header triggers is that Sage 100 creates the record when you first grab the order number, but at that point almost all the fields are blank.  So the trigger needs to be for UPDATE, not INSERT, with some way to not keep firing it when orders are updated later.

------------------------------
Phil McIntosh
Friendly Systems
------------------------------

Add a filter to your query to ensure the required fields (like CustomerNo) are not blank, so SA doesn't try to send the alert too early.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 03-20-2025 11:28
From: Dawn Kulbacki
Subject: Sage Alerts - real-time reporting

Sorry! This is Sage 100 Advanced.

------------------------------
Dawn Kulbacki
Capitol Computer Systems, Inc.
------------------------------


Original Message:
Sent: 03-20-2025 11:23
From: Phil McIntosh
Subject: Sage Alerts - real-time reporting

@Dawn Kulbacki Is this Premium?   If it is, the the tricky part of Sales Order Header triggers is that Sage 100 creates the record when you first grab the order number, but at that point almost all the fields are blank.  So the trigger needs to be for UPDATE, not INSERT, with some way to not keep firing it when orders are updated later.

------------------------------
Phil McIntosh
Friendly Systems