[Feature Request]: Asset Lifecycle: allow Selling or Recycling at a price and enrich the Depreciation Report

[dimkasta]

Is your feature request related to a problem? Please describe.

In our experience, the lifecycle of an asset can end in a few ways

• Archive the depreciated asset in storage. This happens when Accounting is too busy to declassify them and we cannot get rid of them or recycle or sell them.
• Recycle the depreciated asset. This happens when Assets are declassified and they can be scrapped, usually at a fixed price per load or ton or whatever.
• Sell the depreciated asset. This can happen when Assets are declassified and can be sold, either to a wholesale vendor as refurbished or to employees.

In the case of recycling or selling, the totals have to be reported to accounting so that they can handle any further losses/profits from the final depreciated value.

Describe the solution you'd like

• A new numeric field "Market Value" defined per Model can help managers decide if it's worth selling the Assets, or if it's just too much hassle and they can be stored or recycled. The field can be manually updated each time accounting/management need to make a decision
• The depreciation report should also show the Market Value to help management decide.
• A new numeric field "Price Sold" should be defined per Asset
• A new date field "Date Sold" should be defined per Asset
• Extra Status labels "Sold" and "Recycled" should be defined. They should behave similarly to "Archived". They should require a "Price Sold" and "Date Sold" value before being applied
• The Depreciation Report should include the "Price Sold" and "Date Sold" fields, and provide an extra calculated column with the final profit (difference between Current Value and Price Sold)
• Aggregate sums below the table are not really needed. Most of the work should happen in excel using an export. The user would filter the rows based on "Date Sold" in excel and do any totals or aggregations there

Describe alternatives you've considered

Currently doing something similar on excel

Additional context

No response

[welcome[bot]]

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

[snipe]

I feel like 90% of the ask here is already possible through your own status labels (archived -> sold) and custom fields (date sold, etc).