UPDATE: Nvm. I FOUND IT. I am an idiot. Please ignore this post.
I’ve been staring at my db for a few hours now and cannot seem to find the source of a discrepancy in values.
My DB stores cash advance transactions on one table for a set of customers (found on another table). To get the total of advances to display on the customer table, I simply do a rollup. HOWEVER… the rollup value is inconsistent with the total I’m getting in the other table. I’m stumped.
It’s maddening. Any ideas? Screenshots are attached if they can help.