There appears to be a discrepancy between a customer's total purchase amount displayed by Sales by Customer summary (front-end) and the data retrieved from NetSuite2.com, connected via Datagrip, using query 1 and 2 (see attached file).
Query 1 returns a table detailing each customer and the amount purchased by quarter. I've crosschecked a few customers (not all) from the result set and it does match with the front-end Sales by Customer summary. However, I discovered a particular customer in the result set that made no purchases during Q2 - Q3 2022, while having purchases in Q4 2022 and Q1 2023. The Sales by Customer summary report details that this customer did make purchases during Q2 - Q3 2022 and the purchase amount from my query does not match with the summary report for Q4 2022. Q1 2023 matches the front-end report.
Query 2 shows that the earliest purchase for this particular customer was made in Q4 of 2022, which contradicts Sales by Customer summary. All results from this query matches the result set found in query 1.
Any idea what's going on? I'm worried that there might be more instances like this in the result set.