Check Formula in Inventory Management App

[mastcorp]

Hello!

We have created an application that manages the stock and orders of a company.

In the field of orders, when a new order is added we want to put a check so that the storekeeper knows if he should continue or not.
So in case he has made a mistake with the quantity we want a message type "ATTENTION" to appear.

Here are some screenshots to help you understand exactly the formula we want to achieve.

In the first screenshot you can see the orders field, where we've categorized them into OPEN AND CLOSED. (sorry about the languange the app is for a Greek Company)

In the second screenshot, we show you what we want to achieve.

First you see the products contained in the order. 

Then you can see the scans of the products that the storekeeper must do so that they are the same as the above list (products, quantity of products, etc.)

 In the example we show you through the screenshots we see that there is a difference between the quantity that the list has for the product (6) and the quantity that the storekeeper put (5).
So in this case we want him to get a message to look at it again to avoid the mistake.

Thank you a lot for your time!

[WillowMobileSys]

I would recommend using column validation to present your desired message.  Then also include a Yes/No field that allows the user to confirm the counted value is correct and allow saving of mis-matched value.

NOTE:  It is frequently the case the expected Inventory does not match actual product on hand.  Inventory goes missing for a number of various reasons...sometimes "mysteriously" disappearing.   You will need to be able to allow adjustment of the expected Inventory counts in these cases.