Report for fixed asset

[Amit_H]

Hi There,

I have a requirement to share list of fixed asset data which has depreciation value less than 5k.

[Runjay Patel · Accepted solution]

Hi @Amit_H ,

You can create a report on table "m2m_fixed_asset_to_asset" this will give all fixed assets.

put condition like below.

You can schedule this report to stakeholder who need this.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Runjay Patel · Accepted solution]

Hi @Amit_H ,

You can create a report on table "m2m_fixed_asset_to_asset" this will give all fixed assets.

put condition like below.

You can schedule this report to stakeholder who need this.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Amit_H]

Thanks @Runjay Patel . Also can we set monthly depreciation calculation?

[Runjay Patel · Accepted solution]

Hi @Amit_H ,

Yes, you can schedule it monthly basis but there is already job running on daily basis which trigger script include to calculate the depreciation.

In this schedule you can change from daily to monthly.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------