Message for "out of stock" items when added to a sales order
I'm really new to SAP and have only been working in it for two months, but have picked up a few tips and tricks already and done som b1 validation configs to suit our company, but now I am stuck at this one query a colleague had.
He wishes for a pop up message to appear for a certain item, if it is out of stock at the time and added to a sales order.
I think I'm somewhere half there in my mind. I believe I need to set the function to trigger when validated (leaving a field) and to form 139, item 38 and column 1 and when the number in OITW.OnHand is equal to 0 and the field RDR1.ItemCode is equal to the item in mentioned, the message is triggered. But I have no idea how to write this in the SQL condition box or if I'm even close to the right thing!
It also needs to be triggered if the amount in the field for OITW.IsCommited is higher than in the field for OnHand or when the number in RDR1.Quantity is higher than in OnHands.
Hope this makes sense to anyone!