cancel
Showing results for 
Search instead for 
Did you mean: 

Alert for inventory movement

Former Member
0 Kudos

I want to fire an alert when the quantity of inventory goes below the minimum inventory.I created query as


if (SELECT onhand from oitm where itemcode='CHPESS0002') < 1000
print 'The quanatity has gone below the minimum inventory.'

The alert does not fire for the above query.It fires for,


SELECT onhand from oitm where itemcode='CHPESS0002'

I want to fire it for specific condition and display user defined message i.e.'The quanatity has gone below the minimum inventory.

Accepted Solutions (1)

Accepted Solutions (1)

former_member204969
Active Contributor
0 Kudos

Try this one:

SELECT t.onhand from oitm t where t.itemcode='CHPESS0002' and t.onhand < 1000

Former Member
0 Kudos

I don't have problem with the query.The problem is with the message.How do I display message in the alert ?

former_member204969
Active Contributor
0 Kudos

You can try this:

SELECT 'The quanatity has gone below the minimum inventory.',t.onhand
 from oitm t where t.itemcode='CHPESS0002' and t.onhand < 1000

Answers (0)