Hi,
I am working on an inventory.
How do I block sales if a products inventory quantity is equal to 0?
So letโs say Product A with Bar Code 123 has 0 in quantity.
When I want to add a sale and I scan the Bar Code 123, I donโt want it to be allowed to make a sale, since the quantity is already in 0. How can I block that?
I did the following but donโt know how to make it work.
IF([Quantity].[Product] = โ0โ, โvalue_1โ, โvalue_2โ)
Virtual Column: Quantity
For table (not current table): Product
Value 1 and 2: I donโt know what I should input.
Thank you
Solved! Go to Solution.
Thanks Lynn,
it says "Unable to find column โQuantityโ "
Iโm thinking its because it is a Virtual Column. So I wrote
([Quantity].[Product])<=[Current Stock]
but it still wonโt work.
Quantity is a Virtual Column inside the Product Table.
User | Count |
---|---|
40 | |
35 | |
30 | |
23 | |
17 |