Sage 100

Okay, so I just learned today that KnowledgeSync has no way to send an email when a record has been deleted from the database! Even Business Alerts had that capability! Anyone know of a workaround?

When you merge a part, it does not write to the IM Audit Log.

Could be done with a second table (B) that has a snapshot of the 1st table (A). If the record is in B, but not A, then trigger alert. You'd just have to query and alert based on the values in B before you take a new snapshot of A. If this were MSSQL (or MySQL, or Postgres), then KnowledgeSync could respond to a built in Trigger in the database, and you could simply alert on delete.

But this is ProvideX not SQL.

Vineyard (Farber) wasn't able to suggest something?

I've worked with Don Farber on this back in 2009. Here was his response back then: ""Regarding the tracking of deleted records, the answer again ""yes -- KnowledgeSync does support this"" but the solution is not quite as easy as in monitoring for changed records. To identify deleted records, the suggested approach is to use database triggers, as triggers can be kicked-off when a record is deleted from the database. In SQL, the trigger writes out audit details of the record a nanosecond before the record is physically removed from the database, so KnowledgeSync has access to the deleted record's details. In KnowledgeSync, the trigger then kicks off a corresponding KnowledgeSync event which sends alerts, executes actions, et cetera. I have one of our technicians looking into the options for tracking deleted records in a non-SQL database, and I'll get back to you with details on that as soon as I know them."" Here's a thought (assuming 4.4 or above): keep a mirror table to the item table, but do not add the usual script logic to delete records from the mirror. The mirror should contain fields that you would want to see in the alert. The query would have to be set up to only show records that exist in the mirror table, but do not exist in the CI_Item table. The event would only send emails for new records.

By the way, when he got back to me it was only to say that the request to track deleted records was added to their ""Change Management database"" so that it could be added to the product in a future release.

I wonder if it's coming in version 8.1. (Hopefully out next week per what they told me when it was delayed from being out on May 1.)

Hopefully we will know next week (but I wouldn't count on it).

I doubt they'll enable that; it is tough. The mirror table makes a lot of sense. In a simple minded case, refresh the table nightly from MAS. Then run events based on records in the mirror table that are not in MAS. You could use VI to run the nightly job to Access for Simple.

I think that's the only way. Funny how business alerts had this functionality and KnowledgeSync does not.

Perhaps the blame should really be on Sage for not writing a complete audit trail...........................

Can you write an event script that will create something KS can ""see"".

Not sure why Knowledgesync should feel they need to make major structural programming changes to their product just because Sage is the last company on earth still selling a non-sql, file shared ERP application. Even peachtree supports a SQL Database. This would be like Apple still selling a computer with a modem standard, and ethernet, an extra cost option.