I'm curious if something like this is possible, it may not be
We have an app that tracks products sold and the price they were sold at. However, it is a manual process where the users enter in the product, price, and any discount. However, a user could select the wrong product ID but put the correct price in. We'd like a way to clear those out. The product name can't be fixed in the database.
For example, the prices are:
Apple $1
Orange $0.75
Banana $0.25
Let's say the second entry in the table below the user selected the wrong product of Orange but put in the correct price for the item which is $1 for an Apple. Would there be a way to have an extra column somewhere where a supervisor who is reviewing these can "clear" it from the list. We could create an Excel file to hold exceptions and remove them that way but I'd like a more automated and clean solution.
In other words, I want the supervisors reviewing the list to be able to clear them without us developers having to code around them.
Customer | Product | Price | Discount | Total | Expected Price | Difference |
555 | Apple | 1 | | 1 | 1 | 0 |
556 | Orange | 1 | | 1 | 0.75 | -0.25 |
557 | Apple | 1 | 0.5 | 0.5 | 1 | 0 |
558 | Banana | 0.25 | | 0.25 | 0.25 | 0 |
559 | Banana | 0.25 | | 0.25 | 0.25 | 0 |
560 | Orange | 0.75 | | 0.75 | 0.75 | 0 |
561 | Orange | 0.75 | 0.5 | 0.25 | 0.75 | 0 |
562 | Banana | 0.5 | | 0.5 | 0.25 | -0.25 |