Does anyone know how I can create a WHERE condition on a saved search. I currently have a report that pulls an invoice based on specific criteria, and then pulls the applying transaction (payment) related to that invoice. The problem is that when a payment was applied to two invoices, it pulls both of the payments into the report. In SQL I would simply set my WHERE condition to make sure that the payment pulled was related to the invoice in question. Any idea on how to do this in the saved search builder? I can't get it to accept a formula on the Criteria section.
Current Setup:
Criteria:
Type = Invoice
Results:
Type
Number
Date
Name
Account
Applying Transaction: Applied to Link Type
Applying Transaction: Date
Applying Transaction: Link Amount
Applying Transaction: Applied to Transaction
Results:
Invoice*INV1011*12/31/2008*Netsuite, Inc.*AR*Payment*2/2/09*17,750.00*Invoice1011
Invoice*INV1011*12/31/2008*Netsuite, Inc.*AR*Payment*2/2/09*2,250.00*Invoice1264
The second one is the one that is causing stress. I don't want it to pull payment lines that are not related to the Invoice Number.
Thanks...