Skip to main content
Solved

How to find Accounts with no connections

  • May 15, 2026
  • 2 replies
  • 30 views

Forum|alt.badge.img+5

Hi!

 

We have over 25 000 Accounts in IFS. Is there an easy way, or any way, in IFS Cloud to search for accounts without connected objects such as sales quotations, orders, leads or business opportunities? An account clean-up is long overdue.

Best answer by VihanW

Hi ​@linjen,

As far as I know, there is no standard functionality or filtering at the application level to isolate customers or accounts with no associated objects (such as orders, quotations, leads, or business opportunities). However, this can be effectively achieved via an SQL query.

Thanks,

Vihan

2 replies

Forum|alt.badge.img+5
  • Sidekick (Employee)
  • Answer
  • May 15, 2026

Hi ​@linjen,

As far as I know, there is no standard functionality or filtering at the application level to isolate customers or accounts with no associated objects (such as orders, quotations, leads, or business opportunities). However, this can be effectively achieved via an SQL query.

Thanks,

Vihan


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • May 18, 2026

Thanks! We will look into usin quick reports to identify these.