Date-Specific Comparisons in the Sales by Customer YTD Report
If we use NetSuite's report function to create a report of sales by customer compared to last year, is it possible to compare sales by date for each customer?
For example, different customers may have different payment sites.
For example, Customer A closes on the 15th of the month, so if we want to get the sales results for the year, it would be from October 16, 2023 to October 15, 2024.
As you can see, the aggregate sales performance for one year for each customer will vary from period to period.
How can NetSuite's standard reporting function handle this case?
With the Sales by Customer report, all customers are listed and if you specify the current fiscal year in the date filter, the results for the current fiscal year are displayed.
However, this is different from the actual aggregation period.
What should I do?
Translated with DeepL.com (free version)