Catalog Item report with zero usage

Jeremyramirez12
Tera Contributor

How do I generate a report that will show all catalog items that have no or zero usage?

1 ACCEPTED SOLUTION

Dnyaneshwaree
Mega Sage

Hello @Jeremyramirez12 ,

In the report filter condition, you can add two condition:
1. Condition: active = true.
2. Related List Condition:
    table:  requested item-> item
    condition: created after last 12 months (time period is depend on your requirement)

If my answer helped you in any way, please mark it as helpful or correct.

 

Thank you in advance!!

Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!

Dnyaneshwaree Satpute
Tera Guru

View solution in original post

8 REPLIES 8

Hi @Dnyaneshwaree ,

 

In the related list condition, is it correct that it should be Requested Item -> Item and not just Requested item? Doesn't the latter pertain to catalog items rather than actual RITMs?

Dnyaneshwaree
Mega Sage

Please use given conditions and check the result and inform. So, I will try to suggest something.

Thank You!!

Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!

Dnyaneshwaree Satpute
Tera Guru

The results look good and accurate! Will use it for this purpose.

Dnyaneshwaree
Mega Sage

If my suggestions helps you any way then please add thumb from last of my post so it marked as a helpful.

 

Thanks a lot!!

Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!

Dnyaneshwaree Satpute
Tera Guru