I need to create a business alert that will notify the user when a certain product has been selected to be shipped. I am not familiar with the SQL code that is needed. So far I have navigated through the Alert Set up, and am now stumped on the Define Alert Formula window. I am assuming that the Table will use the Inventory Transaction Work, and the Column name will need to be IV Document Number, but I am not sure. As far as the formula is concerned, I am not even sure how to start. Any and all help would be greatly appreciated.
Greg Wartes
RoseBud Technologies
*This post is locked for comments