Material Tracking / Transaction log - Application event system

I am wanting to fire an event when something new is entered into the matltrack_mst Table.
Using the application event system, what event and trigger should I be using?
I am trying
Event Name: IdoOnItemInsert
Applies To Objects: SLMatltracks
With an event of a simple notification.

Then using the form Quantity Move I move some items from a lot, this form uses SLLotLocs but the matltrack_mst table does get new items inserting into it. But the event will not fire. What am I missing here?

Find more posts tagged with

Syteline Development

Accepted answers

All comments

unknown

Hello,

I believe the collection you should be using is SLItemlocs.

Thanks,

Ben

unknown

The events don't work like db triggers. They only fire if the collection that is bound to the form that is causing the change is the collection on the event itself... one of the downsides to events. If someone knows otherwise please let me know.

dmitchell

I believe Ben is correct.

The IdoOnItemInsert event is only triggered when a record is inserted via the IDO Runtime Service (such as a new record created/saved on a form bound to an IDO, or some other type of an IDO Request). There are a lot of processes (at least in the version we run, 9.00.30) in which transactions are handled with stored procedures instead of through the IDO layer, which do not cause the Ido* AES events to trigger.

I'd say the Quantity Move form eventually makes a Method Call (stored procedure) to do its posting...outside of the IDO layer.

You could still handle the notification with the AES, but would have to create your own AES Event and a way to trigger that event (eg. Form Event Handler, AES Trigger, SQL Table Trigger...just depends on your environment and context of the situation).

unknown

This is the answer I needed to get my head right. Thanks!

unknown

Thanks 1345201, gotta love our names on here.

This gives me a path forward. We are on prem single site, so we have options. My goal is to stick with what I think Infor is aiming at, so to keep that cloud friendly would be keeping it all within CSI/Infor OS. That said, a SQL SP would be an easy fast way to get the job done.

dmitchell

Ha...yeah, I guess I should update my profile

We are in a similar situation...on prem, but trying to keep in line with Infor development best practices (and trying to keep custom SQL code to a minimum). That has been challenging as we continue to run into these kind of situations.

Anyway, have a good day 1295924!

Welcome To Solutions Development.docx

unknown

Jason,

Were you able to get this working? Did you do an extgen on an existing stored procedure?

Copyright © 2025 Infor. All rights reserved.