Forum Discussion
Slider! I am new to QuickBase and learning as I go.
I agree with you and it is a start to a solution!
There is a products table, inventory adjustment table and serial numbers table. Some products have individual serial numbers (think iPhone) each product is the same but has its own serial number. Other products are bulk(think water bottle) no individual serial numbers. These are all medical devices so the details can be less than exciting.
I do need to set minimum available quantity levels. Example...I have 100 of one single product remaining. When the available amount of that product = 99, I would like a notification sent to the office manager so that another order can be placed for more. There are multiple products and I would like to set individual limits for each product.
I have setup a lot of the relationships in different tables although not as much...or hardly any formula work in QB at this time. Any suggestions are much appreciated.
I agree with you and it is a start to a solution!
There is a products table, inventory adjustment table and serial numbers table. Some products have individual serial numbers (think iPhone) each product is the same but has its own serial number. Other products are bulk(think water bottle) no individual serial numbers. These are all medical devices so the details can be less than exciting.
I do need to set minimum available quantity levels. Example...I have 100 of one single product remaining. When the available amount of that product = 99, I would like a notification sent to the office manager so that another order can be placed for more. There are multiple products and I would like to set individual limits for each product.
I have setup a lot of the relationships in different tables although not as much...or hardly any formula work in QB at this time. Any suggestions are much appreciated.