Good afternoon,
I am trying to create an equipment asset tracker using dynamics 365 using an entity that stores equipment information, equipment ID, quantity of stock.
Each piece of equipment falls into a "bundle", which people can book out. For an example, a laptop, USB mouse and USB stick may fall into a "remote working packup" (not the exact stuff that's being used in the tracker, but just something to describe what i'm trying to do).
I want to create a form where people can book out these individual packups over a duration of time, or book out items separately. Ideally I would like to have it so that once someone books a packup, it subtracts the amount used from the stock quantity value for either the duration it's booked out or until it is signed back in.
However as I am rather new to Dynamics, I am unsure how to achieve this. I am thinking about using a second "equipment bundle" entity and having them work in tandem somehow, maybe using flow to subtract the value each time something is booked out. That being said, I am unsure if this is the correct way of doing this, or even best working practice.
Does anyone have any advice how to achieve this within Dynamics 365, or is this better done on something like PowerApps?