Hey everyone,
I have a question or an idea in mind.
We have a scheme:
IT Asset Management
There is an object type ‘Hardware Catalogue’ and there are e.g. object types like Supported Laptops, Supported Computers in it.
These object types then contain objects such as Apple Macbook Pro M2.
These objects have a ‘Restock Level’ field as an integer.
Then there is the object type:
IT Hardware with the underlying object types ‘Laptops’
A data record would look like this:
Asset tag, model, status
The status can then be ‘In stock’,"Active","Inactive".
I would now like an e-mail to be sent when only X devices still have the status ‘In stock’. X devices should then be the restock level that has been stored for the respective model.
Does someone have a idea?
Interpretation = restock level is point of reordering stock.
Need filter: current inventory = Restock and status = 'In Stock' then send email.
What is the standard for inventory levels- max 10 units?
So can include 10-restock = Number of units that need to be reordered.
---
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.