Assets expiration reporting

[Shiva Kumar8]

Hi Community,

I would like to create reports on Assets with the following criteria, can anyone please help?

1. Report on Assets which are going to be expired in next 3 months, 6 months, 1 year by location (There is a field Warranty Date on Assets which can be sued for this. Please note many assets still don't have this date populated yet)
2. Assets(machines) which are already expired
3. Machines not going to expire in next 1+ year by location

Thanks in Advance.

[Prateek kumar]

If you don't have the expiration date filled in, how can you classify them as expired, expiring and in use assets?

[Shiva Kumar8]

Hi Prateek,

we have a field called 'warranty expiration'

[Prateek kumar]

Warranty expiration is a date field and you can report on it.

1.Report on Assets which are going to be expired in next 3 months, 6 months, 1 year by location (There is a field Warranty Date on Assets which can be sued for this. Please note many assets still don't have this date populated yet)

Conditions will be something like below:

Warranty Expiration is between today and next 3 months.

Warranty expiration is between next 3 months to next 6 months.

[Shiva Kumar8]

Hi Prateek , Thanks for the quick response, we don't have next 3 months option in the available options please find the attachment for reference.