@Michelle Firth Hello. You could try accomplishing this with an Item Saved Search. This is just an example, but it might point you in the right direction. In your criteria, add Transaction fields... Type = Invoice, Cash Sale, and None. Then, in the results, add "Name" with Group summary type, add Transaction fields... Quantity with SUM summary type, and then add Transaction fields... Amount with the SUM summary type. When you run the search it will show the QTYs sold for each item, and the total amount. For items w/o any transactions they will show on the search since you have your criteria to include Transaction type = none. It will just show blank for the transaction QTY and Amount for those ones. I hope this helps.