I want a filter to displays quotes that are open and have no repeating instructions

Where a database has different types of quotes - normal and those with repeating instructions, a custom filter is required to view normal templates that are not closed

Step-by-step guide

Use the following SQL code to create a new filter in Quotes that will display non-repeating quotes that do not have the status of 'Closed'

QO_Main.Status = 0 AND QO_Main.InvoiceID NOT IN (SELECT DISTINCT InvoiceID FROM QO_History WHERE InvoiceHistoryID IN (SELECT QuoteHistoryID FROM QO_HistoryActivate WHERE RepeatEvery <> 0))

Related articles