Is there a clean way of getting rid of the entire invoice line if there’s a misc charge of a specific code? I can filter out specific misc charge codes, but if the invoice has that misc charge code + others it will still show in the query list.
An example-
AP Invoice # 123 has TAX and FREIGHT Misc charge on it… If I want to get rid of any TAX misc charge invoices it doesn’t actually get rid of #123, instead it just removes the TAX line but we can still see the invoice #123 in the list. How can I make it so it will get rid of it out of the query results list if it has a specific misc charge on the invoice?