Running code on every insert

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi!

I would like to run some code on every new record of a table.

The INSERT trigger don't manage it because the lines are inserted by codeunits that do not run the trigger and I have no permisions to change them (Item Journal...).

Is there a way to do that?

In detail, I need to update a field on a table (50xxx) on every change of the item inventory. I thought to put the code on the INSERT trigger of the Item Ledger Entry, but how to run the trigger?

Waiting your thoughts!

Thanks in advance.

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Running code on every insert

Thanks!!

This solved my problem Amol Salvi ;) Your "trick" did it!

The resource suggested by Mirko Markovic would be fantastic but it seems to work only after Nav2015 :(

Thanks again!!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Running code on every insert

Thanks Mirko Markovic!

It would be great but it is NAV2015 :(

Is there any other workaround to the the same here?

The solution of Amol Salvi works here but not on every tables, so it would be good to know if we can do this on NAV2015...

Thanks once again.
Mirko Markovic on at

Like (1)

Report

RE: Running code on every insert

If working in NAV2016 or NAV2017 the best way is to use subscriber on Item Ledger Entry Modify and Insert trigger.
Verified answer

Amol Salvi 18,694 on at

Like (1)

Report

RE: Running code on every insert

Maybe after posting of record you can modify the record . You need to write code in Codeunit No 21