the inventory valuation is getting cut off and not...
# inventoryt
texmc
09/08/2021, 8:57 PMthe inventory valuation is getting cut off and not even showing 20% of our inventory saying results too large
k
KevinJ of Kansas
09/08/2021, 9:06 PMfind some way to reduce results - location/custom field on items/starting letters/numbers
KevinJ of Kansas
09/08/2021, 9:06 PMThat's actually one of the reports I know dies when people have a large number of SKUs
r
RJMNS
09/08/2021, 9:16 PMClick the "Alert me when ready" option when the little window comes up while it's thinking. That sends the report to the background to run.
It will display more lines that way, but I still think there's some upper size limit so it may not display everything. You can file a case with NS to try and increase that limit.
If none of that gets you the full report, you may be stuck having reports for parts of the alphabet, eg an A-E report, F-K report, etc. Clunky and slow as hell, but I've had to do that before.
k
KevinJ of Kansas
09/08/2021, 10:17 PMYou are limited to 1 million records I think even if you use the alert me when ready.
KevinJ of Kansas
09/08/2021, 10:18 PMAnd it should be noted those 1 million records are transactions in this case to calculate the quantities and values
KevinJ of Kansas
09/08/2021, 10:19 PMSo if you are a high volume shop you may hit that limit with just a few items, but then I'd probably ask why you are using NetSuite
3 Views