Hello everyone,

New here.

I try to get a list of all our Supplier Invoices that we received since we started with IFS (roughly 3 years). If I click on populate it won’t do much and it just tries to work on it for hours with no results. Probably too much data, idk.

I noticed that it is possible to do SQL searches and was thinking to maybe create the following search: I want IFS to present me invoices from all suppliers, but only one invoice from each supplier. So I only want each Supplier ID to appear once. (I have basically no idea how SQL works and how to create searches from it)

First of all, what would be the code for that and second, would that even make it possible to populate a list for me?

Thanks for your help!