Hello Everyone!! Wondering if someone has any ideas on where to look for my issue I need assistance pulling in information into a saved search. I need to be able to pull in the amount $ from an Item Receipt Transaction into this saved search results but it's not pulling in. Instead I'm getting other amounts that I can't trace back. Any idea why or what criteria I need to add to pull this amount?

I’ve seen similar issues when using joined columns and aggregates like SUM, like double counting. The frustrating part is that if you were to click on the row in question, you would probably not see the all rows that make up the errant sum. You might try to add in additional groupings for Type (even though it’s filtered). You can also experiment with Mainline = True or False (on the transaction or even the Applying Transaction). Finally, you might want to try using NS_CONCAT or WM_CONCAT on amount with a MIN summary type to see what all the values are. Hope that helps.

Thank you! I actually got it through adding a new column transaction:amount which pulled in the right info

👍