I am working on an internal company "Craigslist" asset system. This will provide all of our sites with access to used equipment, chairs, etc.
But, I am trying to figure out the best way to record a Cost Estimate field when a record is deleted from the database. This will allow us to track an ROI for the solution in cost saving of buying new equipment.
So, I have a Cost Estimate Field in the record. If the asset is deleted(meaning the asset has been transferred to another site) and is now in use, how much did we save over time by reusing equipment.