I have a simple search to show quote transaction-project-applying invoice. When invoicing multiple times on a quote transaction, it doubles up the line items. This affects the rolling sum at the bottom of the search.

Is there a way to prevent this? Attached image

Let me know if you need more info. Here are my Results fields:

Document Number  

 Name  

 Amount  

Quoted Amount  

 Project (Main Line) : ID  

 Project (Main Line) : Project Manager (Custom)  

 Project (Main Line) : Projected End Date  

 Applying Transaction  

 Applying Transaction : Date  

 Applying Transaction : Amount  

 Project (Main Line) : Project Notes (Custom)