Report is showing multiple of the same line item

​@BenjaminCrisman It was those two tables that were causing the problem. I’ve broken them off into a sub table per your suggestion. However, I’m having trouble brining in only the tracking number for that specific invoice. I’ve attached the two reports for refence on what I tried.

Figured it out ​@BenjaminCrisman. Thanks.

​@BenjaminCrisman  - checking my understanding so I can make sure I’m giving good advice to anyone who asks me.

I think you can achieve the deduplication without a sub report if you’re very careful with Grouping formulas, and there are times where I’d recommend this for performance reasons vs embedding subreports.

Do you agree that my method would at least work in principle?

​@WillH Yeah, I’m sure it’s possible, but the problem is that when you are including these results in the grouping, most of the time there is a quantity or amount field also included and grouping the values will Sum these amounts. It might be possible with a variable I suppose but subreports are so much easier in my opinion. I do understand about the performance, but for this report the most common way to add the package and/or tracking details to the report is via subreport

Thanks ​@BenjaminCrisman , appreciate the opinion shared.

I think it reflects the specific ERP product I learnt to write reports in, and my experience unpicking legacy calculations. 

For reference incase anyone wants to pursue the kind of logic I’m mentioning and shows up in this thread reply:
You should be able to achieve this kind of thing by using the variable logic and Groups in various Acumatica reports. 
If you’re going to pursue this, make sure you’re dealing with the identity key values when you create your groups, since you’ll be needing to transfer the value you need into the variable & sum that going forward, rather than summing the individual line value.

I think Benjamin is 100% right that the logic is easier if you program this with subreports, once you wrap your head around subreports.  My concerns/preferences are generally based around performance impacts due to the way subreports are called.