I have a question about searches. Someone is asking for 2 searches one with invoices and then one with payments that shows the amount paid and the idea is to get these to link together in USD. In the invoice report I will see Invoice #123 - $100 In the payment report I will see 2 lines being applied to Invoice #123. One at $100 and another at $20. Is this some kind of consolidated rate true-up based on when it was paid? I tried looking for a field that I can exclude to stop that $20 line from showing, but I can't seem to figure it out. I have tried various applied to fields and the applied to link fields

What more is there to know about the $20? You could look for Transaction Line Type. Or look on GL Impact to see if there is a clue there.

The problem is I can't get a payment report that shows how much was paid to the applied invoice (in USD). Netsuite appears to be splitting things in a way that causes issues when trying to aggregate (either Discounts, currency revaluations, or duplication of the same line)