I have a NetSuite account with a large volume of transactional data. The standard Inventory Profitability Report loads within a few minutes and performs reasonably well. However, when I customize the report and disable the "Show Zeros" option, the report takes an excessively long time to load.
I also attempted to generate the report through report scheduling, but the task failed with an error indicating that the report could not be completed due to the large volume of data.
My requirement is straightforward: I need to view the Inventory Profitability Report without displaying rows that contain zero or blank values. Could you please advise on the best way to achieve this while maintaining acceptable report performance? Are there any recommended alternatives, report settings, or NetSuite best practices for handling this requirement in accounts with high data volumes?
Any guidance would be appreciated.
