Skip to Content

Alert query for all transactions

Jun 09, 2017 at 11:39 AM


avatar image
Former Member

Hi, I'm absolutely when it comes to SAP.

I need to create an Alert query to alert someone when any transactions for any one item above 24 has occurred. Can anyone help?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K Jun 09, 2017 at 11:26 PM


It is possible to get alert for all transaction for an item. But the alert is query is not simple. You have to create and combine query from Journal entry tables, OINM tables and those documents which is not posting either journal entry or inventory posting.

If you want alert for specific transactions, then it will be easier to create an alert.



10 |10000 characters needed characters left characters exceeded
Peter Hartwich
Jun 09, 2017 at 11:40 AM

Dear Nicholas, welcome to SAP Community for SAP Business One!

I just published your valid question.

I know our search is not perfect, but you should be able to check various sources for required Information yourself, such as archived or open discussions like and more important as a first check, all the information we provide on like or There should be even much more information giving you guidance to get started. In this way, you should be able to get answers to your basic questions yourself fastest.

If you got more specific issues I’m sure SAP Community members are there to provide further help.

Hope this helps,


10 |10000 characters needed characters left characters exceeded